![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}
Good evening
I do have a not so big Calc file for my personal "accounting" (keeping
track of my work)
The one from last year was about 160 kb. This year's contains naturally
less data.
And that suddenly jumped to 27 MB and file constantly crashes.
Copying the data into a new few file gives me about 78 kb.
Where does that giant data package of 27 MB suddenly come from?
Can I get rid of it?
Thank you
Thomas
Hi,
Do you often copy/paste data? It is possible that some behavior changed
regarding this.
Anyway, to find exactly what is taking so much space, you can try this:
- Copy your file somewhere (just to be safe)
- Rename it to .zip
- Open it
There, you should be able to see what file take that much space. If it's in
contents.xml, then it will need further examination, but if it's in another
file, it might be easier/quicker to deal with.
(2014/04/17 20:14), Cley Faye wrote:
I do have a not so big Calc file for my personal "accounting" (keeping
track of my work)
The one from last year was about 160 kb. This year's contains naturally
less data.
And that suddenly jumped to 27 MB and file constantly crashes.Copying the data into a new few file gives me about 78 kb.
Where does that giant data package of 27 MB suddenly come from?
Can I get rid of it?Hi,
Do you often copy/paste data? It is possible that some behavior changed
regarding this.Anyway, to find exactly what is taking so much space, you can try this:
- Copy your file somewhere (just to be safe)
- Rename it to .zip
- Open it
There, you should be able to see what file take that much space. If it's in
contents.xml, then it will need further examination, but if it's in another
file, it might be easier/quicker to deal with.
I am afraid, I do not understand.
Renaming the file to "current name.zip" does not change anything.
Creating a Zip Folder/file generates only ONE folder, containing ONE file = the calc file. Size as stated.
I cannot see any XML file anywhere ....
To answer the question about copying:
No, I do not often "copy" things. Only entering data once in a while. Think of this file as a notebook.
It has always worked in the past ...
You have to change the file extension from ".ods" to ".zip". If you're
under windows, the file explorer probably hide the file extension, so you
have to unhide them (it's easy, the procedure is described here:
http://support.microsoft.com/kb/865219/en)
Once you can change the file extension to zip, you should be able to open
it and see how files are laid out. You'll have something that ressemble
this structure: http://i.imgur.com/eAEuZZ5.png
(2014/04/17 22:36), Cley Faye wrote:
I am afraid, I do not understand.
Renaming the file to "current name.zip" does not change anything.
Creating a Zip Folder/file generates only ONE folder, containing ONE file
= the calc file. Size as stated.
I cannot see any XML file anywhere ....You have to change the file extension from ".ods" to ".zip". If you're
under windows, the file explorer probably hide the file extension, so you
have to unhide them (it's easy, the procedure is described here:
http://support.microsoft.com/kb/865219/en)Once you can change the file extension to zip, you should be able to open
it and see how files are laid out. You'll have something that ressemble
this structure: http://i.imgur.com/eAEuZZ5.png
Thank you.
I managed that.
It shows a "content.xml" file of about 54 kb and a folder named "Fonts", that contains 17 fonts with numbers (no names), worth about 25 MB.
This seems to be the villain.
I think, I found under "properties" an item "embed fonts in document".
Unchecking that reduced file size to about 100 kb.
Hopefully that solved my problem und will prevent the file from crashing.
Thank you, again.
Thomas
Hi 
Brilliantly found! That is quite a new feature that some people have been
keen to see for quite some time. I tend to use boring fonts that almost
everyone ends up getting or already has even though they are MS ones.
Regards from
Tom
