Bug 159616 - no screen refresh after editing cell or changing column with, when macros are activated
Summary: no screen refresh after editing cell or changing column with, when macros are...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: x86-64 (AMD64) Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, regression
Depends on:
Blocks:
 
Reported: 2024-02-07 10:19 UTC by Franz Preyser
Modified: 2024-02-23 14:07 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
quite big calc-file with custom macros (2.10 MB, application/vnd.oasis.opendocument.spreadsheet)
2024-02-07 10:19 UTC, Franz Preyser
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Franz Preyser 2024-02-07 10:19:33 UTC
Created attachment 192445 [details]
quite big calc-file with custom macros

First of all, I already found out, that the following error only occurs, when macros are activated. When the macro security level is chosen in a way that prohibits the execution of macros, the error does not occur. When I sign my document so I can use the macro also with higher security settings, the error occurs again. 

The error occurred also in a previous version of libreOffice, which a can not remember. But the version is the one which you can currently get from the official kubuntu 22.04 package sources. I updated via the ppa:libreoffice/ppa to cersion 7.6.4.1 to see if the error disappears in a newer version. But error still is there.

The faulty behavior ist the following:  
After editing a cell content and confirming it by typing "enter", the cell content is displayed empty. Also other cells which use the cells' content in a formular do not change. However, when clicking on the cell, the correct (edited) content is shown in the input-line. After scrolling down and up again, the correct cell content is displayed and also for cells which use the cells' content in a formular. This can also be achieved by not scrolling down and up again, but by clicking into the input line while the cell is marked (clicking into it suffices - no need to type enter).
Same thing happens when for example the width of a Column is altered. You can see the result only after scrolling away and back again.
Comment 1 Franz Preyser 2024-02-07 11:00:26 UTC
I found out now, that when I open the macros-Editor, the error does not occur. Meaning, while the Macros Editor is open, the error does not occur. After closing the editor, the error occurs again.
Comment 2 Buovjaga 2024-02-23 14:07:28 UTC
Before 4.1, there was a brief flash of blankness, but the cell content was repainted without additional action.

In the history of 4.1, there are two changes that are relevant for the test file.

The first change is that most of the cells appear as blank upon opening and if you edit a cell, it remains blank. This change happened in this range:

https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=a8f3d75184e52f4c379754f9965488aa4ff832f8..a8da9a9e6b32a0479bf9fad3624ad10f329e86c1

For some reason the cgit query is not showing this commit: a8f3d75184e52f4c379754f9965488aa4ff832f8

Then, the second change is to the current behaviour: 7a13e3dc20908bad26b65606ce6efbfeb97fca55
ScBaseCell::nTextWidth is no more.

Bibisected with linux-41max.