Question Locked
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 arunjoseph001 Accepted solution
Clarifications
by kingbackwards Accepted solution
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 Accepted solution
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 Accepted solution
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.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies
Discussion
Is There any Reverse Video Search Tool
0 helpful
8 replies