[Libreoffice-bugs] [Bug 133085] New: Calc is very very slow compared to MS Office - EDITING, FILEOPEN, FILESAVE

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133085

            Bug ID: 133085
           Summary: Calc is very very slow compared to MS Office -
                    EDITING, FILEOPEN, FILESAVE
           Product: LibreOffice
           Version: 6.4.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: knimer at gmail.com

Description:
Hello,

When I open the file in LibreOffice Calc, whether as ODS or XLSX it hangs up
when opening and I need to wait while it is frozen.

Then when I want to change the sheet to another, it simply hangs and I need to
wait for so long again.

Saving the file is a nightmare as it hangs to the point that sometimes I need
to kill the LibreOffice Calc or simply restart.

I really hate to say this, but when I use MS Office 2019 Pro Plus 64Bit, it
just opens, asks to update from linked sources, I answer yes, in a wink it
updates, then it all works super convenient. Saving the document is as fast as
everything else with MS Office Excel.


Good to know:

I use LibreOffice 6.4.1.2

LibreOffice runs on Solus Linux 4.1

The file reads from 3 linked source files of data.

The file has many calculations in each row.

The file has almost 1,000 rows.

I tried to create the file in ODS format, the same result.
Create it in XLSX format, again the same.

I tried to have the source files as ODS and then XLSX still the same.

Until this problem is solved, I switched to Excel as I cannot afford the loss
of time.

My PC specs:

Intel® Core™ i7-8550U CPU @ 1.80GHz × 8 CPU
8 GiB RAM
SSD 256 GB Drive
Intel® UHD Graphics 620 (Kabylake GT2) GPU

I am ready to test any configuration, send more info, or try alpha or beta
releases.

Thanks for a great product.

Khaldoun




Steps to Reproduce:
1. Download the ZIP file with Main file and Data sources files. All files are
in XLSX format.

ZIP File link: xyz

2. Place all files: Sub-All.xlsx, Ren-All.xlsx, Unsub-All.xlsx, and "Main.xlsx"
in the same folder.

3. Open the "Main.xlsx" file in Calc.

4. Wait until the file is opened, then try to work on it.

Actual Results:
The file is very very slow and it is actually not usable.

Expected Results:
The file should open quickly and perform normally.


Reproducible: Always


User Profile Reset: No



Additional Info:
The file should load fast. Hate to see Excel doing better and be forced to use
it instead of LibreOffice.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200516/85af99d4/attachment.htm>