Ask Your Question

File size twice as big with calc update [closed]

asked 2014-07-09 00:12:18 +0200

Basile gravatar image

updated 2015-09-01 21:15:12 +0200

Alex Kemp gravatar image

Hello, I have just updated to and I did notice that when I edit my old spreadsheets (version 4.1.6), even if I just "touch" them, the file size doubles.

I wonder if this is ok, I'm sensitive about this as I use several medium sized spreadsheets.

Language is french for both LibreOffice/calc (v4.2.5.2 x86) and OS (Windows 7 x64).

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-29 16:38:20.825096


Please provide details of actual file sizes and the file format being used. Thanks.

oweng gravatar imageoweng ( 2014-07-09 04:50:06 +0200 )edit

Actually I can even give the link to the different file versions :

  • New, ods type, 86 Ko

  • Old, ods type, 47 Ko

For information this my (empty) automatic character sheet for a dungeon & dragons-like rpg.

The completed characters suffer the same issue, for exemple 62 to 113 Ko (I can give the link too if needed, all of this is in dropbox).

Basile gravatar imageBasile ( 2014-07-12 08:28:32 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-07-12 10:30:37 +0200

oweng gravatar image

updated 2014-07-12 10:31:15 +0200

Thanks for the example files. The only difference between the two files (in terms of file size) is the PNG in the Thumbnails/ sub-directory in the ODSs. After unzipping them into directories named according to the version this is what I see:

$ ls -l v4162/Thumbnails/
total 16
-rw-r--r-- 1 oweng users 12976 Jul  3 12:11 thumbnail.png
$ ls -l v4252/Thumbnails/
total 52
-rw-r--r-- 1 oweng users 53003 Jul 11 22:46 thumbnail.png

That basically accounts for the difference in size. This would appear to be related to the change in thumbnail handling made between v4.1 and v4.2 as described in the answer relating to turning off storing of thumbnails.

edit flag offensive delete link more


So if I understand, this is a well known problem but I can't solve it until 4.3 version. Ok then. I was far from suspecting thumbnails anyway, I don't even use them...

Basile gravatar imageBasile ( 2014-07-12 12:10:05 +0200 )edit

@Basile, you can turn off thumbnail inclusion in v4.2 using the instructions in the linked answer I provided.

oweng gravatar imageoweng ( 2014-07-12 13:54:05 +0200 )edit

Question Tools

1 follower


Asked: 2014-07-09 00:12:18 +0200

Seen: 162 times

Last updated: Jul 12 '14