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