I have an LibreOffice Calc document (file.ods) with the size 71 Kb.

If I open it and modify something (even delete 1 cell) and then save, it comes with the size 78 Kb.

I'm sure that major version of LibreOffice didn't change since last saving (I use libreoffice-calc 1:5.1.6~rc2-0ubuntu1~xenial1 with Kubuntu 16.04.2 LTS).

I'm trying to investigate. If I create new OpenDocument Spreadsheet (newfile.ods), manually insert the data from old file into it and save (making sure that there are no invisible unused rows there), the newfile size is still 78 Kb.

What is the reason of such unexpected grow of file size? How to debug that?

Added: I've solved half of the problem (now gile grows from 71 Kb to 73 Kb): size could grow because of built-in thumbnail saving in libreoffice (when saving file, it puts a little graphical preview of spreadsheet in PNG format into *.ods file). If thumbnail shows area with colorized data, it could be at least 10 Kb, and if thumbnail shows area with a little text and no extra colors, it could be just 3 Kb. I turned off thumbnail saving by setting "GenerateThumbnail" into "false" (Tools → Options... → LibreOffice → Advanced → Expert Configuration). But the question is still actual: why does file.ods size increase, while there are no new extra data in it?

  • LO adds Meta data: change timestamp and author are saved, too. – ngulam Mar 28 '17 at 17:55
  • is there a chance to disable/decrease metadata saving? – AntonioK Mar 30 '17 at 6:24
  • If I disable Tools>Options...>LibreOffice>User data>Use data for file properties I got a slightly fewer increase in Bytes... AFAIK you cannot turn meta data saving off at all (e.g. last saved timestamp always indicate a document change). though one can clear document properties by macro. Why does is matter in these times of terrabyte(s) discs, anyway? – ngulam Mar 30 '17 at 11:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.