Re: [libreoffice-users] Problem loading and saving XLS files

Hi :)
Forget about Gnumeric.  The only reason i suggested it was as a quick&easy OpenSource alternative 
that is a dedicated Spreadsheet program.  If it's not quick&easy then forget it.  
Regards from 
Tom :)  






> ________________________________
> From: Carl Paulsen <carlpaulsen@comcast.net>
> To: users@global.libreoffice.org 
> Sent: Tuesday, 26 February 2013, 12:50
> Subject: Re: [libreoffice-users] Problem loading and saving XLS files
>
> Thanks, Tom.  I'm on a Mac so those memory settings are under 
> LibreOffice->Preferences->Memory.
>
> I set per object memory to 18MB and then 20MB based on the 15MB file 
> size and left the others.  I don't care if it's slow for testing 
> purposes.  I run 4GB ram and typically have over 1GB available, so no 
> problem there...at least in theory.
>
> Changing the memory didn't affect the file opening.  Still truncating at 
> 7,600+ records.  Note there are no images in the files.  They are 
> straight text and numeric data with up to 25,000 records and 17 
> fields/columns.  The  only formatting is that the first row is 
> boldface.  When I save the .csv file (the one that contains all records) 
> as a .xls, the files size is 3-4MB, much more like what I expect.
>
> I will certainly inquire with Salesforce to see what they do for file 
> generation, though I don't expect much of a response.
>
> Re: gnumeric, I don't see a build for Mac OS and I always have LOTS of 
> trouble building from source code.  I may try it eventually, though, so 
> thanks.  It certainly sounds interesting.
>
> Carl
>
>
> On 2/26/13 6:44 AM, Tom Davies wrote:
> > Hi :)
> > I'm just wondering if Gnumeric might be better at opening the file?
> >
> > Calc 'should' be able to handle it easily so there is something weird there.  The file-size drop 
> > sounds like the old bug about images dropping out but we haven't seen that happen for around a 
> > year afaik.  Is it definitely an Xls and not an XlsX?  XlsX and Odt can be opened as though they 
> > were Zip files which allows you to poke around inside a lot more.  On the other hand Xls is 
> > usually a lot more stable than XlsX.  15Mb is pretty large for a normal file unless it does have 
> > images embedded inside.
> >
> > Could you just open LibreOffice itself, without opening the Xls, and go to
> >
> > Tools - Options - Memory
> >
> > and bump up those figures a LOT.  Particularly the "Memory per object" to maybe around 15Mb, or 
> > something huge like that.  I'm assuming your Ram is over 1Gb and could handle it quite easily.  
> > Perhaps drop the number of undo steps it remembers to maybe 50.  Mine seems excessive at 100.
> >
> > I don't know why the file-size keeps changing.  It's something that would worry me so i would 
> > save as an Odt to make sure i got a stable copy and then possibly start exploring the Xls to see 
> > why it's so unstable.  Csv holds no formatting information so it's bound to be a lot smaller 
> > than an Xls or Odt.  It also strips out any images and macros and stuff.
> >
> > Regards from
> > Tom :)
> >
> >
> >
> >
> >
> >
> > > ________________________________
> > > From: Jay Lozier <jslozier@gmail.com>
> > > To: users@global.libreoffice.org
> > > Sent: Tuesday, 26 February 2013, 4:19
> > > Subject: Re: [libreoffice-users] Problem loading and saving XLS files
> > >
> > > On 02/25/2013 06:19 PM, Carl Paulsen wrote:
> > > > I'm using LO 3.5.6.2  on a Mac OS 10.6.8
> > > >
> > > > I'm working on a critical project analyzing data from Salesforce (I'll call it SF) for 
> > > > non-profit SF users.  When I export xls files from SF, if those files are greater than 
> > > > something like 7,000 records (a dozen or so fields), the file gets truncated by LO.  The files 
> > > > (some with 21,000+ records) open fine in MS Excel (on a PC at least - I don't own Excel on my 
> > > > Mac).
> > > >
> > > > If I export from SF as .csv files, these open fine in LO and I can manipulate them fine.  
> > > > Saving is also OK and I seem to be able to export to .xls, which then opens fine in LO with 
> > > > all 21000 records.
> > > >
> > > > Any idea why the SF export of .xls file type won't open properly in LO?  What could cause this 
> > > > problem?  Could this be a bug in LO?  I realize there could be oddities in the SF export 
> > > > function, but given it opens fine in Excel (on a PC at least)
> > > >
> > > > Note I can see something going on with the file size.  The .xls direct from SF is 15MB.  After 
> > > > opening this file and then saving it, the file size is 3-6MB (and it has only about 7000 
> > > > records). The .csv file that's exported from SF is about 2-3MB, but when I save the .csv file 
> > > > as .xls, the file is still only 3-4MB but it's complete (all 21000 records).
> > > Carl
> > >
> > > The problem is not the number of records since importing the csv file does not truncate. Most 
> > > spreadsheets do have an upper limit for the number of records and for Excel and Calc I believe 
> > > it is much larger than 21K.
> > >
> > > Can you import the csv file and then save as an xls file and then reopen the xls file without 
> > > data loss?
> > >
> > > -- Jay Lozier
> > > jslozier@gmail.com
> > >
> > >
> > > -- For unsubscribe instructions e-mail to: users+help@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
>
> -- 
>
> Carl Paulsen
>
> 8 Hamilton Street
>
> Dover, NH 03820
>
> (603) 749-2310
>
>
> -- 
> For unsubscribe instructions e-mail to: users+help@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
-- 
For unsubscribe instructions e-mail to: users+help@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