Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index

Hi Remy:

        Thank you for your answer an explanation. I'm sorry to answer
some days after but the e-mail was in the spam folder.

        I know that I have only 1.5 GB free space on my hard disk.
Probably it is the problem if LibreOffice make a temp file wile running
it great than 1.5 GB when I'm increasing the spreadsheet size.


Jorge Rodríguez

El lun, 24-09-2018 a las 19:25 -0400, Remy Gauthier escribió:
I have a spreadsheet that contains Canadian weather data since 1953
(more or less) for 25 weather stations. For each station, there are
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 >

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
/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
less 2,7 GB). Could it be that the disk partition you are using to
/tmp is almost full? My /tmp partition (Linux Fedora) is 4GB-large
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
écrit :
Hi all:

    I use LibreOffice Snap process and LibreOffice
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
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
could confirm the size : 35 kb.

    LibreOffice sent to my screen the following message (Please see
the link)

    It is in spanish but in english is something like this:

"Error when save the document: Sin titulo 1
Writing Error
It couldn't write"

I greatful with any help. It would be a bug ?


Jorge Rodríguez 

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.