Re: [libreoffice-users] Slow Loading and Saving LibreOffice Cal File

Sorry, forgot to say that if you have the time

Make process iterative...with each change, save as "{new}.xls" and test 
for load time.

If find the error, report it.

Happy Holidays



On 12/4/24 09:20, Paul D. Mirowsky wrote:
> Procedure
>
> If you have a lot of data and not much calculating, I suggest that you
>
>  * save your file as a "csv" and a different {name}
>  * Open both (use "xls" as reference for formulas)
>  * Add formulas to "{name}.csv", confirm calculations are happening
>    properlyand save as "{name}.ods"
>  * close "xls"
>  * Open "{name}.ods" and confirm calculations are happening correctly,
>    save as "xls" with {new} name
>  * Open "{new}.xls" and see how long it takes.
>
> Hopefully it will strip out the load error and any cruft accumulated 
> over time.
>
> Note: Copy/Paste from XLS to ODS might work but CSV probably has less 
> possible aberrations.
>
> You will still have to check the "{new}.xls" to confirm it is correct.
>
> If you find a difference, submit findings and reply here so others 
> know what to look out for.
>
> Hope this helps
>
> Paul
>
> On 11/27/24 12:03, Richard England wrote:
> > Are you saving this file as an Excel formatted file (file.xlsx)? If 
> > so I wonder if the conversion from Excel into (and out of) 
> > Libreoffice spread sheet format ( .ods )  is taking extra time.
> >
> > An experiment to determine if my guess is accurate would be to save a 
> > copy of the spreadsheet as .ods and see if the load time is better 
> > when opening it.
> >
> > Might be worth the time if only to pin down the cause.
> >
> > ~~R
> > Non fenestras quia MCMXC
> >
> > On 11/24/24 19:32, Paul wrote:
> > >    I am using LibreOffice, but it takes a long time to load and save 
> > > large
> > > Excel files. I am running Windows 11 Pro with 96 GB RAM and a 4 TB 
> > > SSD. Can
> > > you provide a step-by-step guide to speed up the time it takes to 
> > > load and
> > > save large Excel files?
> > >
> > > *Filesize*: 191 KB
> > > *Version*: 24.8.3.2 (X86_64) / LibreOffice Community
--
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