https://bugs.documentfoundation.org/show_bug.cgi?id=174013
--- Comment #3 from [email protected] --- Reproduced with a minimal file of my own. I did not use the attached files. 1. Made an XLSX with a script: sheet1.xml has <sheetFormatPr defaultRowHeight="99.75" customHeight="1"/> and short text in A1:B5, with no row-level heights. 2. Opened it in Calc: every row is about 3.5 cm tall. 3. Selected rows 1-5, row header context menu > Optimal Row Height, Add 0.00 cm ("Default value" checked), OK. Result: rows 1-5 do not change. The Row Height dialog for row 1 still shows 3.52 cm with "Default value" checked. 4. Saved as ODS, closed and reopened: rows 1-5 now fit the text, while the empty rows below keep the tall height. So Optimal Row Height seems to use the stored defaultRowHeight instead of the content height, as described. I did not test changing customHeight on its own. LibreOffice: Version: 26.8.1.1 (X86_64) Build ID: bf6ef2662401c7d6dce671ab4deb26ee0af3a7c1 CPU threads: 20; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win Locale: zh-CN (zh_CN); UI: zh-CN Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.
