Why LibreOffice Calc under Ubuntu is 100 times slower than Excel for Windows?
Trying to open the file .xlsx with LibreOffice Calc, which was created in Excel., the file weighs in at 26 MB.
A very long time to open and after opening greatly freezes when you move the slider up and down.
Tried to wait, thought it would be cached (well, you never know) and then will fly like in Excel, but nothing happened. Tried to save to your computer in the end, LibreOffice did a file size of 26.6 MB --> 20 MB, but the problem remained.
Why is this happening and can it be solved? Advise a working alternative.
Not enough optimization. It is obvious that it is not MS Libre.
If the file is just a database to use a database for storage.
Try to save in ODS.
What is your file not as a normal working size is 4..5 megabytes.
Esta_Upton answered on June 14th 19 at 20:27
1. To enable QuickStart if boontobody not otchekryzhili it - it will load part of office into memory, disable check automatic updates
2. 26Мб file is too big for the table. Yeah, I saw stoogemania table...Rosalina for any failed save. Hedgehogs placable, injected, but s/ate cactus/worked in the table instead of a DB/g Try to resave to ODS if there are no complicated formulas, charts, a super-duper wrapped macros
3. The file may be trying to pull external data. Check and disable if not critical
Mohammad.Cole22 answered on June 14th 19 at 20:29
A non-native format.
Why it needs to be as fast as native MS products???????????????????????????
Jensen.Rosenbaum answered on June 14th 19 at 20:31
File velikovat for moralnogo. Check that the file has no infinite ranges of empty cells (both vertically and horizontally) with the specified styles. If there are any, should be cleared of their contents and styles to remove.
Kirk.Strosin answered on June 14th 19 at 20:33
Can a joke that in such a case, Steve jobs refused Adobe Flash on iPhones )
If in the case of two options:
to the above:
1 Try WPS Office
2. through wine works well in Excel 2003. It seems there is a standalone version (without installing the whole office, etc.) when it runs directly from the folder.