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
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