Ask Your Question

Can I save a spreadsheet file without compression, if it reduces the loading/saving time of the file?

asked 2019-03-26 08:57:09 +0100

gcaltabiano gravatar image

updated 2020-08-31 19:12:55 +0100

Alex Kemp gravatar image

I have a spreadsheet with lots of formulas. It is 2.6MB. I normally change just a few cells (including those changed by the formulas, it must be less than 20 cells). It takes me over 1 minute to load the file. 5 seconds to make the changes I make. 15 minutes or more to save the file. It is very inefficient.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-03-26 09:32:05 +0100

Opaque gravatar image

updated 2019-03-26 09:34:34 +0100


AFAIK the answer is "yes, you can save as Flat XML ODF Spreadsheet (.fods) at [ File -> Save As ] A rough guess is, that your 2.6 MB file will be about 20 MB in size (but I doubt of ZIP compression being your real problem).

edit flag offensive delete link more


Thanks. The Flat XML ODF Spreadsheet is much quicker and only takes less than a minute to save. The file size is about 45MB, but I don't care. I prefer to save time.

gcaltabiano gravatar imagegcaltabiano ( 2019-03-27 08:29:24 +0100 )edit

Thanks for the comment and the info therein. I'm very surprised by the compression rate of your file.

Opaque gravatar imageOpaque ( 2019-03-27 08:55:56 +0100 )edit

pls. check if your document contains plenty of comments (annotations). you can use Navigator - F5 - and unfold 'comments' there. if it's many (up from 1000 i'd expect 'impact') gather information about slowness regarding comments and ways to avoid.

newbie-02 gravatar imagenewbie-02 ( 2019-05-31 02:29:38 +0100 )edit

answered 2019-03-26 10:12:40 +0100

kiloran gravatar image

15 minutes to save seems way too long. I have spreadsheets with lots of formulas and opening/saving is just a matter of seconds. I guess it depends on what you mean by a lot, and the complexity of the formulas. What happens if you switch off Autocalculate? Does your spreadsheet have links to other documents? That would certainly slow things down

edit flag offensive delete link more


replaced ..

newbie-02 gravatar imagenewbie-02 ( 2019-05-31 02:28:55 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-26 08:57:09 +0100

Seen: 133 times

Last updated: Mar 26 '19