Re: [libreoffice-users] Great File size problem

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.

Regards,

Jorge Rodríguez



El lun, 24-09-2018 a las 19:25 -0400, Remy Gauthier escribió:
> Hi,
> 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
> > Stats):
>
> 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.
> Rémy.
> Le lundi 24 septembre 2018 à 15:02 -0600, jorge Rodríguez Fonseca a
> écrit :
> > Hi all:
> >
> >     I use LibreOffice 6.1.1.2 Snap process and LibreOffice 6.0.6.2
> > 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
> > and
> > 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
> > the
> > properties file because it had 35 kb instead 13.5 MB, but in the
> > screen
> > I could see the spreadsheet as nothing passed. With the file
> > browser
> > I
> > could confirm the size : 35 kb.
> >
> >     LibreOffice sent to my screen the following message (Please see
> > the link)
https://www.dropbox.com/s/pjvd4tuiz7p0m2w/Great%20File%20size%20-2018
> > -09-24.png?dl=0
> >
> >     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 ?
> >
> > Regards,
> >
> > Jorge Rodríguez 


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy