Ask Your Question
0

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

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

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

Opaque gravatar image

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

Hello

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

Comments

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 +0200 )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 +0200 )edit
0

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

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 55 times

Last updated: Mar 26