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 <[email protected]> >To: [email protected] >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 <[email protected]> >>> To: [email protected] >>> 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 >>> [email protected] >>> >>> >>> -- For unsubscribe instructions e-mail to: [email protected] >>> 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: [email protected] >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: [email protected] 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
