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

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