Re: [libreoffice-users] Re: Where is Base?

2015-03-02 Thread Tom Davies
Hi :)
The way Andreas describes Base's internal back-end makes a lot of sense out
of what i have always heard about the internal back-end functioning so
badly.  Trying to read/write into a file inside a zip-file is often tricky
and i just hadn't thought about that wrt Base.

However, i was under the impression that the devs move to using a different
internal back-end would give them a chance to do a better job of it.
Sometimes prototyping really helps identify difficult areas.  Also running
a system for a long time does sometimes flag up issues that may not have
been noticeable at the time.

So i thought the move to a different internal back-end would at least make
it possible to upgrade that back-end and maybe keep it less heavily tweaked
and thus more inline with their own documentation to help people with all
sorts of issues.  Even just a couple of things like that might be a huge
improvement.
Regards from
Tom :)




On 1 March 2015 at 23:10, Virgil Arrington  wrote:

>
> On 03/01/2015 02:03 PM, Andreas Säger wrote:
>
>> Without Base you give up the capability to print serial letters and
>> labels from lists.The vast majority of Base users are Writer users creating
>> a serial letter or sheet of labels. These wizards generate Base documents
>> in the background. In 99% of all these cases the Base documents constitutes
>> a connection to a spreadsheet.
>>
>
> You have described my situation exactly. I use Base once a year, to print
> out address labels for Christmas cards. I keep the address list in a
> spreadsheet and link to Writer through Base. It took me forever to learn
> how to do it, but now that I know, it works great.
>
> Virgil
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] libreOffice 4.4. Format file when make Save As

2015-03-02 Thread krmed
Dear The Document Foundation.

Please, consider set the default file format when I do Sava As. See
screenshots.

1. I set default file format as MS Office .doc or .xls
2. make Save As
3. LebreOffice set .odt file format

It would be very convenient Save As file format coincides with the default.

All the best
Всего доброго
Денис.



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Re: libreOffice 4.4. Format file when make Save As

2015-03-02 Thread V Stuart Foote
No,  the dialog is in Tools -> Options -> Load/Save -> General:  Default File
Formats and ODF settings

There the default for all modules can only be set to one single type-- Text,
HTML, Master, Spreadsheet, Presentation, Drawing, Formula. And with that
set, the document will Save or Save-As the format selected for that single
type.  

However, documents of type other than the selected will remain with
LibreOffice Default ODF formats.

It works correctly in 4.4.1 and current master.





--
View this message in context: 
http://nabble.documentfoundation.org/libreOffice-4-4-Format-file-when-make-Save-As-tp4141977p4141979.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



[libreoffice-users] Calc issue: display bug

2015-03-02 Thread Xbot
Hi,

I've a display bug with a xlsm file opened with LO: 

how it is displayed in Libreoffice (4.3.4.1 and 4.4.1.2) :  
http://i.imgur.com/1gmRFnF.png
how it is displayed in Excel (2007) : http://i.imgur.com/2ApxxVQ.png
the xlsm file: 
http://demo.ovh.eu/download/81443811d52fef29c48908a28e57b895/1.xlsm

How to fix it?

Best regards









-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Re: libreOffice 4.4. Format file when make Save As

2015-03-02 Thread Brian Barker

At 07:49 02/03/2015 -0700, V Stuart Foote wrote:

At 20:59 02/03/2015 +0700, Denis Noname wrote:
Please, consider set the default file format when I do Save As. See 
screenshots.


1. I set default file format as MS Office .doc or .xls
2. make Save As
3. LibreOffice set .odt file format

It would be very convenient Save As file format coincides with the default.


No, the dialog is in Tools -> Options -> Load/Save -> 
General:  Default File Formats and ODF settings


There the default for all modules can only be set to one single 
type-- Text, HTML, Master, Spreadsheet, Presentation, Drawing, 
Formula. And with that set, the document will Save or Save-As the 
format selected for that single type.


However, documents of type other than the selected will remain with 
LibreOffice Default ODF formats.


It works correctly in 4.4.1 and current master.


I think I can see what the original questioner is asking. The 
relevant settings (at Tools | Options... | Load/Save | General | 
Default file format and ODF settings | Always save as) are of course 
respected when saving a file for the first time. Although this is 
necessarily in effect a Save As..., users will generally use Save and 
think of this as a Save operation, not a Save As... .


The situation in which they expect to use Save As... is when saving a 
new copy of an existing file, quite possibly with the precise purpose 
of selecting a different file format. Here the default format in the 
Save As dialogue appears to be the existing file format, not that set 
in Options. The questioner wants the Options selection to be the 
default here too. Perhaps he receives .odt and .ods files from others 
and uses Save As... to save copies in .doc and .xls formats.


I make no comment on the desirability of any change. But I do suggest 
that using Microsoft Office file formats as standard is not the best 
way to use LibreOffice. If you keep ODF as the default and save 
copies in foreign formats only when necessary, you preserve more of 
LibreOffice's functionality.


Brian Barker  



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: Where is Base?

2015-03-02 Thread Peter Goggin
I have read with interest the emails on Base.   I have always regarded 
the data base component of Open Office, Libre office as the equivalent 
to the datbase component of MS Access.   I have 5 data bases, originally 
run under windows and MS Access which I have converted to run under 
Libre Base. I have found the LibreBase is probable slightly easier to 
use than MS Access and it certainly copes very well with my data bases, 
all of which are small. (The biggest has about 5000 records) The only 
problem I have had is in a new database where I needed to store photos 
against each record. It quickly gave up after about 4 records. I am not 
certain why, but other claims on my time have prevented me for 
investigating what caused the problem.


I was a database administrator for many years with extremely large data 
bases (millioms of records) using Oracle, etc.  When I needed to manage 
a large data base (about 100,000 records, 30 to 40 users) in linux, I 
used MySQL with web based front end using PHP to connect to the database.


My advice to people needing to use databases is to use Base for small 
databases (less than 1 records). For larger bases consider using 
Mysql with a web based front end and PHP to connect to the databse.


Regards


Peter Goggin



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Re: Where is Base?

2015-03-02 Thread Florian Reisinger
Just a short note: Base can connect to a MySql database using a connector.
I even think, knowing not much about Base, that an external database for 
storage is a very good way to go...Am 02.03.2015 16:54 schrieb Peter Goggin 
:
>
> I have read with interest the emails on Base.   I have always regarded 
> the data base component of Open Office, Libre office as the equivalent 
> to the datbase component of MS Access.   I have 5 data bases, originally 
> run under windows and MS Access which I have converted to run under 
> Libre Base. I have found the LibreBase is probable slightly easier to 
> use than MS Access and it certainly copes very well with my data bases, 
> all of which are small. (The biggest has about 5000 records) The only 
> problem I have had is in a new database where I needed to store photos 
> against each record. It quickly gave up after about 4 records. I am not 
> certain why, but other claims on my time have prevented me for 
> investigating what caused the problem.
>
> I was a database administrator for many years with extremely large data 
> bases (millioms of records) using Oracle, etc.  When I needed to manage 
> a large data base (about 100,000 records, 30 to 40 users) in linux, I 
> used MySQL with web based front end using PHP to connect to the database.
>
> My advice to people needing to use databases is to use Base for small 
> databases (less than 1 records). For larger bases consider using 
> Mysql with a web based front end and PHP to connect to the databse.
>
> Regards
>
> Peter Goggin
>
> -- 
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? 
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Re: Where is Base?

2015-03-02 Thread Andreas Säger
Am 02.03.2015 um 19:33 schrieb Florian Reisinger:
> Just a short note: Base can connect to a MySql database using a connector.
> I even think, knowing not much about Base, that an external database for 
> storage is a very good way to go...Am 02.03.2015 16:54 schrieb Peter Goggin 
> :

External is the one and only way to go. The embedded HSQL 1.8 simply
does not work well enough. There are far too many reports of total data
losses which is inacceptable for a database product.
You can connect MySQL via ODBC, JDBC and the SDBC driver built into the
office suite.
I prefer external HSQL 2.3 via JDBC because the office frontend is
tailored around HSQL, because HSQL 2 converts formerly embedded HSQL 1.8
on the fly and because any connection to an external HSQLDB requires
only one file hsqldb.jar anywhere on the system. In server mode it takes
this file plus self made start/stop scripts and a backup script.
I just opened my oldest HSQL 2 database running in server mode on a
Windows machine, accessed during 12 hours a day by means of Writer forms
and Calc reports from 7 client machines. The first record is of
2011-Apr-28. This database never caused lost a single byte of data. Of
course we run nightly backups anyway.



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Re: Where is Base?

2015-03-02 Thread Tom Davies
Hi :)
Apparently another great database program to use as a back-end is
Postgresql.  Some of the Postgresql people worked with the LibreOffice
people to make a really good connector and then got that connector into
LibreOffice main trunk.

So, Postgresql has an advantage over MySql in not needing a connector,
apparently.  I dunno how it gets updated though!

Also MariaDb is a drop-in replacement for MySql and i think a few places
use it but continue to claim they are using MySql.  Apparently all the
MySql connectors work just the same but i've only heard from a very small
number of people about that and the person who makes/builds the MySql
connector wasn't certain they would work.

I think those are all the larger database back-ends but HSqlDb is
supposedly faster and more efficient with small databases such as almost
all address books.  There are tons to choose from though so you might find
that whatever is being used somewhere already can probably be viewed and
edited through Base.  I think the way Base makes it so easy to connect to
external back-ends is one of the huge advantages that Base offers.  Instead
we try to cripple it by giving it an internal back-end to make it as broken
as Access.
Regards from
Tom :)


On 2 March 2015 at 19:04, Andreas Säger  wrote:

> Am 02.03.2015 um 19:33 schrieb Florian Reisinger:
> > Just a short note: Base can connect to a MySql database using a
> connector.
> > I even think, knowing not much about Base, that an external database for
> storage is a very good way to go...Am 02.03.2015 16:54 schrieb Peter Goggin
> :
>
> External is the one and only way to go. The embedded HSQL 1.8 simply
> does not work well enough. There are far too many reports of total data
> losses which is inacceptable for a database product.
> You can connect MySQL via ODBC, JDBC and the SDBC driver built into the
> office suite.
> I prefer external HSQL 2.3 via JDBC because the office frontend is
> tailored around HSQL, because HSQL 2 converts formerly embedded HSQL 1.8
> on the fly and because any connection to an external HSQLDB requires
> only one file hsqldb.jar anywhere on the system. In server mode it takes
> this file plus self made start/stop scripts and a backup script.
> I just opened my oldest HSQL 2 database running in server mode on a
> Windows machine, accessed during 12 hours a day by means of Writer forms
> and Calc reports from 7 client machines. The first record is of
> 2011-Apr-28. This database never caused lost a single byte of data. Of
> course we run nightly backups anyway.
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Re: Where is Base?

2015-03-02 Thread Ian Whitfield

Hi Peter

Noted on your comments and others

I can confirm that using the embedded DB in Base is a disaster - I 
battled with it for a couple of years until I found out about using an 
external engine - I use MySQL and have had _NO_ problems, (except my own 
finger problems!!) since then.


Regarding images in the Database I have about 2600 records with a 
maximum of 7 images per record. I had no problems with this under 
Base/MySQL except that the DB file gets very large as a copy of each 
image is included in the DB. I just recently came across a tutorial on 
'Linking Images' rather than including them and this works like a charm 
and the DB stays much smaller and therefore faster.


The tutotial can be found here -/_www.youtube.com/watch?v=IsHqqvn2zYg_/ 



Another nice plus is that if you control your image file names you can 
be sure that your DB always shows the latest image - works for me!!


Hope this helps

IanW
Pretoria RSA.

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Re: Where is Base?

2015-03-02 Thread Andreas Säger
Am 02.03.2015 um 21:23 schrieb Tom Davies:
> Hi :)
> Apparently another great database program to use as a back-end is
> Postgresql.  Some of the Postgresql people worked with the LibreOffice
> people to make a really good connector and then got that connector into
> LibreOffice main trunk.
> 

This is not a matter of partisanship, fanboyism nor objective evidence
of the better product. The important thing is that you are able to
connect to whatever you already have. The database of your online shop,
your business software, your accounting software, some dBase directory,
spreadsheets or csv files. The connectivity feature lets you use tabular
data without troublesome export/import.

If all you have is an embedded HSQLDB, you can convert this to HSQL 2
within minutes. Conversion into Postrgre/MySQL/whatever would require
careful editing of SQL scripts, testing and possibly adjustment of
queries, forms, reports.



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Re: Where is Base?

2015-03-02 Thread Fernand Vanrie

Andreas ,

i must strongly confirm your vision.
We must see Base  as a connector and a front end for any possible 
database server


We have 100 users, using LO as a front end  to a MySQL server without 
any problems to use the MySQL data in Writer and Calc.
The front end itself is writen with LO basic mainly using Dialogs to 
view the data and to feed the server with new and modified data.

Greetz

Fernand

Am 02.03.2015 um 19:33 schrieb Florian Reisinger:

Just a short note: Base can connect to a MySql database using a connector.
I even think, knowing not much about Base, that an external database for storage is a 
very good way to go...Am 02.03.2015 16:54 schrieb Peter Goggin 
:

External is the one and only way to go. The embedded HSQL 1.8 simply
does not work well enough. There are far too many reports of total data
losses which is inacceptable for a database product.
You can connect MySQL via ODBC, JDBC and the SDBC driver built into the
office suite.
I prefer external HSQL 2.3 via JDBC because the office frontend is
tailored around HSQL, because HSQL 2 converts formerly embedded HSQL 1.8
on the fly and because any connection to an external HSQLDB requires
only one file hsqldb.jar anywhere on the system. In server mode it takes
this file plus self made start/stop scripts and a backup script.
I just opened my oldest HSQL 2 database running in server mode on a
Windows machine, accessed during 12 hours a day by means of Writer forms
and Calc reports from 7 client machines. The first record is of
2011-Apr-28. This database never caused lost a single byte of data. Of
course we run nightly backups anyway.






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] first step forward

2015-03-02 Thread anddo
 
Hello,

Just few days've gone, I had opportunity to discover your LibreOffice 4.4.1.2.

I've got really impressed. Unfortunatly, there is not enough time, till now, to 
answer the question:

Is the LO abbly, for example, to proceed efficiently a specific arrey of 
numbers (a kind of compilation)?

I'm pretty sure, but to get forward I've attached  simple sample as below.

Is the spreadsheet, or rather is the database the proper tool?

Could you proceed the sample, please?




Best regards,




Andrew Anddos




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: Where is Base?

2015-03-02 Thread Ralf Kersanach
Hi everbody,

although I am not an data IT person, I've been a long time user of 
openoffice/libreoffice. I'll allways wanted to use LO as an official front end 
for an database; first of all because I do not know how to program html (even 
with all those facilities we have today) and also I don't want to start now 
learning how to program in an script language. So I always hoped to find an 
GUI front end for an database, that would feel very similar to FileMaker 
(Mac/win). Well those that claim, that base is already very similar probably 
never used FileMaker intensly. Even Kexi which is also claimed to be as good 
as FileMaker is mile away from it. Don't take me wrong here I don't want to 
make any apology to this program, but they really got it quite right.

Even though still thing that LO and similar are the way to go. But I think for 
sometime its being a unstable GUI crashing once and a while. After lefting it 
to rest for some time, last week, I took courage to restart an small project I 
wanted to move from an Calc tables to an real DB. I started using Kexi and 
tested again if LO Base would connect to the MariaDB with the native mysql 
driver it went flawlessly. One improvement I immediately saw (or at least as 
far as I remember), was the hability to see tables not generated by LO and 
read/write data as well. The last time I used base, if I remember well, base 
could only read tables from an DB if it generated the tables.

But other simple things like changing the order of fields (with MariaDB as 
backend) do not work in LO but in Kexi it works. It seems also that crashing 
event were eliminated or reduced to a minimum. I don't want to compare GUI and 
list advantages or disadvantages, I just want to point out that although big 
leaps happened since I last tried to use base, what makes me very happy. On 
the downside, to become an great and easy to use GUI for developing grahical 
DB interfaces, if comparing with FileMaker, there is still along way to go. I 
tell this because I've used FileMaker for a while. I've learned to use it in 
quite a short time (~ 3-4 month) and did fairly complex reports, queries, etc 
in graphic mode.  I can not say the samething for SQL likes. Probably my 
problem.

But I belive that base is the right way to go, because it is an multiplataform 
program that links to several diferent DB programs and is open, I think two 
key conditions for the success of an software, as Fernand Vanrie mentioned. 
More up to date literature and how-to's would be a nice help and also an 
harder development unfortunately this last one I can not help due to my 
limitations. 

Greetings


-- 

On Monday 02 March 2015 20:23:49 Tom Davies wrote:
> Hi :)
> Apparently another great database program to use as a back-end is
> Postgresql.  Some of the Postgresql people worked with the LibreOffice
> people to make a really good connector and then got that connector into
> LibreOffice main trunk.
> 
> So, Postgresql has an advantage over MySql in not needing a connector,
> apparently.  I dunno how it gets updated though!
> 
> Also MariaDb is a drop-in replacement for MySql and i think a few places
> use it but continue to claim they are using MySql.  Apparently all the
> MySql connectors work just the same but i've only heard from a very small
> number of people about that and the person who makes/builds the MySql
> connector wasn't certain they would work.
> 
> I think those are all the larger database back-ends but HSqlDb is
> supposedly faster and more efficient with small databases such as almost
> all address books.  There are tons to choose from though so you might find
> that whatever is being used somewhere already can probably be viewed and
> edited through Base.  I think the way Base makes it so easy to connect to
> external back-ends is one of the huge advantages that Base offers.  Instead
> we try to cripple it by giving it an internal back-end to make it as broken
> as Access.
> Regards from
> Tom :)
> 
> On 2 March 2015 at 19:04, Andreas Säger  wrote:
> > Am 02.03.2015 um 19:33 schrieb Florian Reisinger:
> > > Just a short note: Base can connect to a MySql database using a
> > 
> > connector.
> > 
> > > I even think, knowing not much about Base, that an external database for
> > 
> > storage is a very good way to go...Am 02.03.2015 16:54 schrieb Peter
> > Goggin
> > :
> > 
> > External is the one and only way to go. The embedded HSQL 1.8 simply
> > does not work well enough. There are far too many reports of total data
> > losses which is inacceptable for a database product.
> > You can connect MySQL via ODBC, JDBC and the SDBC driver built into the
> > office suite.
> > I prefer external HSQL 2.3 via JDBC because the office frontend is
> > tailored around HSQL, because HSQL 2 converts formerly embedded HSQL 1.8
> > on the fly and because any connection to an external HSQLDB requires
> > only one file hsqldb.jar anywhere on the system. In server mode it takes
> > this file plus self 

[libreoffice-users] Can't open .xls files in LibreOffice 4.4 calc

2015-03-02 Thread infinityplusb
Hi allI'm trying to open an .xls file (actually a number of xls files) I
downloaded from the Australia Statistics agency website and want to check if
other people can open it before I raise it as an issue with ... someone.The
file is attached  3303_1_underlying_causes_of_death_(australia).xls

 
The versions I'm using are:LibreOffice Version: 4.4.0.3Build ID:
de093506bcdc5fafd9023ee680b8c60e3e0645dI'm using Ubuntu 14.10Can someone try
and open up the file attached in LibreOffice please?Also if someone could
let me know what I need to do to trouble shoot that would be great.PS I can
open some .xls files, just not this (or a few others) so it might be
something *in* the file. A workaround rather than solution would also
suffice for my purposes.



--
View this message in context: 
http://nabble.documentfoundation.org/Can-t-open-xls-files-in-LibreOffice-4-4-calc-tp4142025.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Can't open .xls files in LibreOffice 4.4 calc

2015-03-02 Thread Tim Lloyd

Hi,

same problem for me...Fedora 21 and LO4.4.1

However, LO4.2.0.4 on XP manages to open the file with no problems. I 
don't know whether 4.2 will perform the same feat on Linux.


If I save with 4.2.0.4 on XP I can open with 4.4.1 on Fedora. With the 
extension unchanged.


A bit of a convoluted answer but a few options anyway :)

Cheers

On 03/03/15 12:16, infinityplusb wrote:

Hi allI'm trying to open an .xls file (actually a number of xls files) I
downloaded from the Australia Statistics agency website and want to check if
other people can open it before I raise it as an issue with ... someone.The
file is attached  3303_1_underlying_causes_of_death_(australia).xls

The versions I'm using are:LibreOffice Version: 4.4.0.3Build ID:
de093506bcdc5fafd9023ee680b8c60e3e0645dI'm using Ubuntu 14.10Can someone try
and open up the file attached in LibreOffice please?Also if someone could
let me know what I need to do to trouble shoot that would be great.PS I can
open some .xls files, just not this (or a few others) so it might be
something *in* the file. A workaround rather than solution would also
suffice for my purposes.



--
View this message in context: 
http://nabble.documentfoundation.org/Can-t-open-xls-files-in-LibreOffice-4-4-calc-tp4142025.html
Sent from the Users mailing list archive at Nabble.com.



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Can't open .xls files in LibreOffice 4.4 calc

2015-03-02 Thread Steve Edmonds

All fine, OpenSuse 12.2 and LO 4.1.6.2
steve

On 2015-03-03 20:13, Tim Lloyd wrote:

Hi,

same problem for me...Fedora 21 and LO4.4.1

However, LO4.2.0.4 on XP manages to open the file with no problems. I 
don't know whether 4.2 will perform the same feat on Linux.


If I save with 4.2.0.4 on XP I can open with 4.4.1 on Fedora. With the 
extension unchanged.


A bit of a convoluted answer but a few options anyway :)

Cheers

On 03/03/15 12:16, infinityplusb wrote:

Hi allI'm trying to open an .xls file (actually a number of xls files) I
downloaded from the Australia Statistics agency website and want to 
check if
other people can open it before I raise it as an issue with ... 
someone.The

file is attached 3303_1_underlying_causes_of_death_(australia).xls
 


The versions I'm using are:LibreOffice Version: 4.4.0.3Build ID:
de093506bcdc5fafd9023ee680b8c60e3e0645dI'm using Ubuntu 14.10Can 
someone try
and open up the file attached in LibreOffice please?Also if someone 
could
let me know what I need to do to trouble shoot that would be great.PS 
I can

open some .xls files, just not this (or a few others) so it might be
something *in* the file. A workaround rather than solution would also
suffice for my purposes.



--
View this message in context: 
http://nabble.documentfoundation.org/Can-t-open-xls-files-in-LibreOffice-4-4-calc-tp4142025.html

Sent from the Users mailing list archive at Nabble.com.






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted