I am trying to move from Excel to LO Calc (… again …) especially since I’ve been a Linux fan for years. (I’ve been using Excel for over 25 years.) However, in particular the Automatic Row Height problems, e.g. extremely slow performance, are likely to prevent this. The key question is "How to
disable the Automatic Row Height"? Especially if this can be done by default on a permanent basis.
In my work this automatic function is simply annoying, and (for me) only wastes productive time because I have to undo what it does (i.e. the “damage” it causes). Fortunately in Excel it is turned off by default.
Since it is sooooo slow - for my current worksheet taking 10 minutes or more !!! each time it starts up. This makes it impossible to contemplate using LibreOffice Calc. (In comparison Excel takes only 2 or 3 seconds for this size worksheet.)
The current worksheet has 169,548 rows and 9 columns - in total 1,525,932 cells with data. Yes, it is a large spreadsheet but it is handled by Excel and should be within the scope of Calc. I found following posts with related problems:
So I created a fresh, empty Calc file in ODS format and pasted the data points in using CTRL-SHIFT-V to avoid any formatting or other unwanted artifacts. Just one single column of 169,548 rows with long text entries took 6 minutes to complete! The same operation using a number between 0 and 20 was almost instantaneous.
What can be done to permanently disable the automatic Row Height adjustment (which I would never actually use even if it wasn’t so slow)?
- AMI Motherboard with a quadcore i5
- CPU (16GB RAM)
- Linux Mint 18.3 MATE (64bit)
- LibreOffice Calc 18.104.22.168
I tried with the latest version of LibreOffice Calc, which is LO 6.3.3. Since this version doesn’t install on LM 18.3 a virtual machine was used (VirtualBox 6.0.14). Unfortunately, after over 35min the ODS file was still stuck on “Adapt Row Height”. So updating doesn’t seem a solution. As virtual machines often run at close to bare metal speeds if graphics are not an issue I am assuming that bare metal speeds would be similar.
My favoured solution is to turn automatic Row Height adjustment off by default. Since I wouldn’t want it even if it did work well, and since it seems to be causing real problems (evidenced by the posts above and my own experience) to me there seems no reason to have this on by default.
During these really long Row Height adjustments only one single core is running at 100%, all others are idling. Since I am providing either 4 or 6 cores for use then multi-threading this operation would greatly reduce delays. My graphic card also has over 1,000 CUDA cores so potentially also accessible for this task. Since the row height for each row (indeed every cell) is independent of others this task must lend itself admirably to multi-threading, wouldn’t it?
- hardware as above
- VM: VirtualBox 6.0.14
- Host: Linux Mint 18.3 MATE (64bit)
- Guest in VM : Linux Mint 19.1 MATE (64bit)
- LibreOffice Calc 6.3.3
The same extremely slow row height (and also column width) adjustments occurs with the Windows version of LibreOffice, whereas Excel on this same system performed without issue. On LibreOffice I can wait a half hour or longer on both the Windows and the Linux versions, whereas Excel takes about a second if asked asked to do the same thing (which in Excel is thankfully off by default).
Version: 22.214.171.124 (x64) (Calc:threaded) Windows Server 2012 R2
(VMWare with Tools ver.9.10.1) (Xeon CPU E5)
- Xeon CPU E5
- VM: VMWare with 6GB RAM (Running Tools ver.9.10.1)
- Host: unknown
- Guest in VM : Windows Server 2012 R2 (64bit)
- LibreOffice Calc ver. 126.96.36.199 (x64) (Calc:threaded)
- Microsoft Office Excel 2016 MSO (32bit) with threaded calcs