Openoffice creates huge Excel file

Questions about applications and software
Forum rules
Before you post please read this

Openoffice creates huge Excel file

Postby lotech on Sun Jan 27, 2008 10:20 pm

I have been using OO for some times now, there are some things I like it, such as the ability to export to PDF, and a simple read and save will reduce PPT file size, but the bad is a small Excel file will become 4 times as big once edited. I have a simple worksheet with non English characters in a small table about 7x30, no formula and no longer than 20 characters average in each cell, a few do have about 50 characters, but I don't think this will make a big different.

For example :

Original Excel : 21K
Open and save in ODF becomes 17K
Save as Excel becomes 74K

This is not a big problem with small file, but bigger file will be trouble to me as I've a slow line.
Do you Yahoo ? No I hiccup only ;p
lotech
Level 2
Level 2
 
Posts: 70
Joined: Thu Jan 24, 2008 10:19 pm

Linux Mint is funded by ads and donations.
 

Re: Openoffice creates huge Excel file

Postby Husse on Mon Jan 28, 2008 8:38 am

I think this has to do with "Save as excel"
Check the OO forum
http://www.oooforum.org/forum/
Image
Don't fix it if it ain't broken, don't break it if you can't fix it
Husse
Level 21
Level 21
 
Posts: 19710
Joined: Sun Feb 11, 2007 7:22 am
Location: Near Borås Sweden

Re: Openoffice creates huge Excel file

Postby lotech on Mon Jan 28, 2008 10:00 am

What's wrong with save as excel ?? I asked why the bigger file size OO created in the same format, if you know the answer please tell me, thanks.
Do you Yahoo ? No I hiccup only ;p
lotech
Level 2
Level 2
 
Posts: 70
Joined: Thu Jan 24, 2008 10:19 pm

Re: Openoffice creates huge Excel file

Postby McLovin on Mon Jan 28, 2008 3:28 pm

I don't know about anyone else, but I don't know, and I am assuming that Husse dose not either, that is why you were referred to the OpenOffice forums, you will find better answers there as that forum is devoted to it. If we knew that answer, we would tell you, Husse is trying to give you the best advice he/we can, as this is not a Mint issue, but an Oo issue.
User avatar
McLovin
Level 5
Level 5
 
Posts: 788
Joined: Thu Aug 23, 2007 6:53 pm

Re: Openoffice creates huge Excel file

Postby lotech on Tue Jan 29, 2008 10:36 am

Yes there is nothing to do with Mint, but there is such a section people post their question regarding various applications so here I go and try my luck here, it is easier than joining 100+ forums just to get answers for different apps., sorry if you don't feel right about that....

Beside, I feel OO forum is not as user friendly and my other questions never get answered so I gave it up, I thought all Linux forum works similar, and I just switch from Ubuntu I feel Mint is more suitable for me.
Do you Yahoo ? No I hiccup only ;p
lotech
Level 2
Level 2
 
Posts: 70
Joined: Thu Jan 24, 2008 10:19 pm

Re: Openoffice creates huge Excel file

Postby Husse on Tue Jan 29, 2008 7:33 pm

The simple answer is - we don't know everything -not me, not even Clem.
But we/I answer everything to the best of our/my ability, which sometimes can be to refer to another forum
Image
Don't fix it if it ain't broken, don't break it if you can't fix it
Husse
Level 21
Level 21
 
Posts: 19710
Joined: Sun Feb 11, 2007 7:22 am
Location: Near Borås Sweden

Re: Openoffice creates huge Excel file

Postby lotech on Tue Jan 29, 2008 10:28 pm

Yes, may be some other will know, or not, never mind, thanks.
Do you Yahoo ? No I hiccup only ;p
lotech
Level 2
Level 2
 
Posts: 70
Joined: Thu Jan 24, 2008 10:19 pm

Re: Openoffice creates huge Excel file

Postby molom on Tue Jan 29, 2008 10:30 pm

I've had the a same problem saving in .doc files with OpenOffice. I imagine its because the Microsoft office file code is copyrighted, so OpenOffice has to create their own code to be compatible with MS office files. The MS files start large in OpenOffice, but when putting more info into the file it doesn't make the file much bigger. This is something I believe can't get fixed until OpenOffice develops better code. I imagine that is why OpenOffice has there own file format.

Cheers,
molom
User avatar
molom
Level 4
Level 4
 
Posts: 390
Joined: Wed Nov 28, 2007 6:24 pm
Location: Australia

Re: Openoffice creates huge Excel file

Postby lotech on Tue Jan 29, 2008 10:37 pm

Oh I don't know about that, my experience was, a 90M PPT open and then saved in OO in the same format reduced to 30M !! IMHO, since my excel is so simple without formula, OO should have removed some unneeded codes to save as smaller size.....
Do you Yahoo ? No I hiccup only ;p
lotech
Level 2
Level 2
 
Posts: 70
Joined: Thu Jan 24, 2008 10:19 pm

Re: Openoffice creates huge Excel file

Postby Chi on Wed Jan 30, 2008 5:50 am

Here goes nothing.

Had a quick look at a couple of examples.
Excel Native: 56k
OpenOffice Saved Excel: 142k

Viewed the .xls files in nano.
Nano can tell me 801 lines vs 1733.

So more stuff is included. There have been some issues with formatting in viuOpenOffice and xls in the past (like explicitly stating each cells format).

Also looked at a file of data (no formatting) MS Excel 3.2mb and openoffice saved as .xls 1.73mb.

Obviously MS and OpenOffice have two completely different approaches to the xls file format. Possibly only those who coded it would know properly.
Time is what keeps everything from happening all at once.
User avatar
Chi
Level 2
Level 2
 
Posts: 79
Joined: Wed Jan 09, 2008 5:02 am
Location: New Zealand

Re: Openoffice creates huge Excel file

Postby lotech on Wed Jan 30, 2008 7:40 am

Thanks for the info., this surprised me much as Linux used to have cleaner codes than windows, if this is not bug I don't know how come the big difference, the OO specific codes should have removed when save as non native format.
Do you Yahoo ? No I hiccup only ;p
lotech
Level 2
Level 2
 
Posts: 70
Joined: Thu Jan 24, 2008 10:19 pm

Linux Mint is funded by ads and donations.
 

Return to Software & Applications

Who is online

Users browsing this forum: Google Adsense [Bot], Preyed and 18 guests