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 Paulsen
Dover, NH 03820
--
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
Context
- [libreoffice-users] Problem loading and saving XLS files · Carl Paulsen
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.