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.