LO 7.2 Calc: why is direct cell editing less responsive than formula editing when typing text?

Hello,

I’ve a question regarding Calc text editing in LibreOffice 7.2.3.2 on Ubuntu 20.04.
I am trying to figure out why editing directly a cell text is not as responsive as editing the cell text in the formula editor field. Edit in the cell can take up to 1 sec to show the change.

This is a behavior I haven’t notice in my previous uses of Calc. (I don’t know when last LO update came in)
It makes editing text (even few chars) almost unusable.
In Writer, writing text is as responsive as using the formula editor field in Calc.

At first I thought it was a rendering issue. But when you use the formula editor field to type the text, the cell updated text appears as fast as the typing. There is no delay in text update.
While doing the same directly in a cell the delay to see typed characters appearing could be more than 1 sec depending of the typing speed.

I did all my tests on a new spreadsheet without any formula, no auto calculation, no spell or grammar check on type, no more anti-aliasing, with and without hardware acceleration.

This is no cells re-calculation: I’ve tested it and cell calculation always happen on cell quit.

I know enough in UI and dev to understand there might be differences in both input methods:

  • formula editor field is most probably only allowing to edit the formula property of the cell (string variable directly)
  • cell text editing might allow a lot more properties change to the current cell and thus checks are made when editing it

Is that the reason?

But still that does not explain why simply typing text makes such a difference.

Are other peoples encountering same behavior?

Thanks in advance.

Cell text editing does not change any cell property other than the cell’s text.
First of all: Don’t misuse spreadsheets as databases.
Since everybody misuses spreadsheets as databases, turn off Tools>“AutoInput”, automatic spellcheck, and the “AutoCorrect” features.

Hi Villeroy. Thanks for your answer.
But my test was simply: typing text in single cell on a new empty spreadsheet.
As described I’ve disable all automatic features.
And I think I get the difference between spreadsheets and DB :wink:

I have no idea. I don’t observe this on Linux nor Windows10. Windows is a can of worms, though. Are you running a native LO from Debian packages or some container thing?

Ubuntu and LO aren’t running within a container. I use the version provided by the Ubuntu software center.
Continuing what I was doing before this message, I notice interacting with the cells is slow when there is a value in: selecting, editing. If there is nothing in then I can click and switch cells as it should be…

I’ve just looked at the user reviews in the Ubuntu software manager and peoples are complaining this version is slow, unusable and same comment as mine above: no problem when empty cell, very slow when not empty. Looks like a bug or integration issue with Ubuntu.

Most probably a more general problem then what I first thought.
I will try uninstalling and use another version.
Strange, it was working before …

I use an older Ubuntu version 18.4 with a recent LO 7.2 downloaded from libreoffice.org. I used the distributed LO 6.4 for many years without serious problems (OK, they mess up the UI every time but users grow with bad user interfaces).

Hi Villeroy. I’ve downgraded to 7.1.8 using the packages (.deb) available on the official website and my problems are gone. Calc works as it was before.

This episode made me get interested in working on LO code (debug/fix) but it looks like hell to start…

@spikeuh Best way to start is to build the code and get on IRC and see entry points at Developers | LibreOffice - Free Office Suite - Based on OpenOffice - Compatible with Microsoft.