I have a spreadsheet that contains Canadian weather data since 1953
(more or less) for 25 weather stations. For each station, there are 28
columns and about 11000 rows of data, with one station per sheet. On
top of that, there are some other sheets that I use to mine into the
data. For good measure, I copied one of the worksheets 3 times, and
added data via copy/paste to have 560 columns on the last worksheet.
Overall, the "big" spreadsheet has these properties (file > Properties
33 worksheets22134827 used cells368 pages10073 formula groups
53.1 MB of disk space used.
It saved, no problem. HOWEVER, LO uses space in /tmp when it creates
the ODS files (it is a ZIPped archive). While it was saving, I went to
/tmp and looked at the files that were created during the saving
process. This is the last "ls" before the save was finished:
total 2756644drwx------ 2 remy remy 160 24 sep 19:06
.drwxrwxrwt 18 root root 420 24 sep 19:06 ..-rwxr-xr-x 1 remy
remy 43484017 24 sep 18:57 lu4577gvthcz.tmp-rw------- 1 remy
remy 43484017 24 sep 19:06 lu4577gvthd0.tmp-rw------- 1 remy
remy 12288 24 sep 19:06 lu4577gvthd2.tmp-rw------- 1 remy remy
2683118605 24 sep 19:06 lu4577gvthd4.tmp-rw------- 1 remy
remy 52688515 24 sep 19:07 lu4577gvthd6.tmp-rw------- 1 remy
remy 458 24 sep 19:00 NewHelp0.html
As you can see, there is quite a lot of disk space being used (more or
less 2,7 GB). Could it be that the disk partition you are using to hold
/tmp is almost full? My /tmp partition (Linux Fedora) is 4GB-large and
when I look at its usage when saving the workbook, it goes up to 68%
from 2% when nothing is happening.
I can only assume the save fails because you run out of disk space.
This will generate the error message, the ODS file will be small
because pieces will be missing, and the in-memory copy of the
spreadsheet will be intact, as if nothing happened.
I hope this helps.
Le lundi 24 septembre 2018 à 15:02 -0600, jorge Rodríguez Fonseca a
I use LibreOffice 188.8.131.52 Snap process and LibreOffice 184.108.40.206
Ubuntu 18.04.1 default.
I tried recently to make a spreadsheet with both LibreOffice
options and I had problems when the file reached more than specified
size. In my case, the last size that I saw was 13.5 MB (512 columns
8,000 rows, more or less)
Then when I included more data into the file, suddently it
can't be saved in any way, and lost all the content as I can see in
properties file because it had 35 kb instead 13.5 MB, but in the
I could see the spreadsheet as nothing passed. With the file browser
could confirm the size : 35 kb.
LibreOffice sent to my screen the following message (Please see
It is in spanish but in english is something like this:
"Error when save the document: Sin titulo 1
It couldn't write"
I greatful with any help. It would be a bug ?
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy