Re: [libreoffice-users] Problem loading and saving XLS files
On 02/26/2013 07:25 AM, Carl Paulsen wrote: Yes, thanks Jay. I CAN save the .csv as an .xls file, then open it successfully, which suggests some kind of formatting issue. And that's what I ended up doing for the 4 or 5 files that were failing. I'd still like to know what's going on - I may contact Salesforce to let them know if it's a problem on their side. Carl I was not sure what to expect but if csv to xls works I agree the exporting function for Salesforce has quirk in it. I use Linux and receive/send xls and xlsx files and do not have have problems (knocks on wood). I have seen some strange formating in doc files screw up imports in non MSO word processing programs. Often Google Docs is a testing platform to test misbehaving files. Jay On 2/25/13 11:19 PM, Jay Lozier wrote: 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? -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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] 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 >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 >>> 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
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 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 jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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+h...@global.libreoffice.org Problems? http:
Re: [libreoffice-users] Problem loading and saving XLS files
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 >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 >jsloz...@gmail.com > > >-- For unsubscribe instructions e-mail to: users+h...@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+h...@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] 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 jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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