Question Locked

Why Open Office sheets are of small size than MS Excel

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I use Open office (don't have ms excel at my desk) and use the xls format for saving spreadsheets. When i saved a 1.5 MB xls sheet in ods format it was only of 305 KB. Is there any way to reduce the file in xls format to this size, because when i will have to send it, it should be in xls format only.

4 replies

by kingbackwards

Have you tried saving your ODS back to an XLS?
Usually their file sizes are comparable.

If its a fairly generic spreadsheet you can try and save it out as a CSV. Then re-add your colors and formatting if any exist.

You may have a picture or some kind of formatting or macro thats using that extra space that is not getting save into the ODS

by arunjoseph001

No use saving it back. Gets back the same heavy size in xls. It has about a dozen sheets and goof amt of formulas and some small icons which is there in ods also. These files are very slow in getting opened or saving in Open Office.

by kingbackwards

Saving out at XML and then back to an XLS also might help (I think that strips out all graphics though, but preserves the formulas) the other option is reducing the resolution on the graphics in a separate program and reinserting them.

This discussion is closed to new replies.