Bug 161018

Summary:	EDITING Calc says "adapt row height" for a short amount of time whenever I select a cell
Product:	LibreOffice	Reporter:	aer0a137
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	minor	CC:	buzea.bogdan, miguelangelrv, telesto
Priority:	medium	Keywords:	bibisectRequest, regression
Version:	24.2.2.2 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108364
Attachments:	Video of the bug One of the spreadsheets where this bug happened Sample file modified.

Description aer0a137 2024-05-10 04:32:37 UTC

Description:
Sometimes, when I select a cell, Calc flashes "Adapt row height" on the bottom bar three times. It also does this but with one flash when I select a cell with the arrow keys and changing the font for a column is slower. Whenever this happens, it also happens for every cell until I restart Calc

Steps to Reproduce:
1.I don't know how to reproduce it, it just happens. It might have something to do with left to right scripts
2.
3.

Actual Results:
Calc flashes "Adapt row height" on the bottom bar three times. It also does this but with one flash when I select a cell with the arrow keys and changing the font for a column is slower.

Expected Results:
Selecting a cell and changing the font for a column takes the same amount of time as usual


Reproducible: Sometimes


User Profile Reset: No

Additional Info:
I need to fill in this field

Comment 1 aer0a137 2024-05-10 04:43:22 UTC

Created attachment 194060 [details]
Video of the bug

Comment 2 m_a_riosv 2024-05-10 16:18:34 UTC

Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.

You can test, cleaning the direct format outside of ranges with data.

If it doesn't work, please test in Menu/Help/Restart in Safe Mode

Comment 3 aer0a137 2024-05-19 23:44:11 UTC

The bug usually starts when I change the font for a column

Comment 4 aer0a137 2024-05-19 23:47:57 UTC

Created attachment 194203 [details]
One of the spreadsheets where this bug happened

I've attached a sample file of one of the spreadsheets where this bug happened

Version: 24.2.2.2 (X86_64) / LibreOffice Community
Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01
CPU threads: 2; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: en-AU (en_AU); UI: en-GB
Calc: CL threaded

Comment 5 m_a_riosv 2024-05-20 02:07:20 UTC

Created attachment 194207 [details]
Sample file modified.

I can see it with
Version: 24.2.3.2 (X86_64) / LibreOffice Community
Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: default; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

But I think it has something to do in how the sheet is formatted.

Applying a direct format for the font to an entire column, make that all cells in the column has that format not only the cells with data, what induces LO to recalculate the row heights.
In your file, the entire sheet has a direct format for the font.

Test cleaning the direct format [Ctrl+M] for the rows below the last data, in your sample file, from row 19 up to the last.

Comment 6 m_a_riosv 2024-05-20 02:18:33 UTC

Not reproducible with
Version: 24.2.0.0.alpha1 (X86_64) / LibreOffice Community
Build ID: 06946980c858649160c634007e5fac9a5aa81f38
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

Comment 7 aer0a137 2024-05-21 00:52:04 UTC

I tried clearing the direct format of all the rows without data, both in safe mode and normal mode, and it still happens. The bug also happens when I select multiple cells vertically or diagonally and change the font

Comment 8 BogdanB 2024-06-05 19:30:50 UTC

I tried today on 24.2.3 on Windows to make the hight of the rows optimal, and the bavaviour was strange in a document with 300 rows.