Bug 170326 - FILESAVE XLSX to ODS: Row height reduced upon save
Summary: FILESAVE XLSX to ODS: Row height reduced upon save
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Regressions-row-height
  Show dependency treegraph
 
Reported: 2026-01-13 11:33 UTC by Gabor Kelemen (Collabora)
Modified: 2026-01-16 17:33 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
The original xlsx attachment saved as ODS (15.46 KB, application/vnd.oasis.opendocument.spreadsheet)
2026-01-13 11:33 UTC, Gabor Kelemen (Collabora)
Details
Screenshot of the xlsx and its saved ods version in Calc (129.49 KB, image/png)
2026-01-13 11:35 UTC, Gabor Kelemen (Collabora)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (Collabora) 2026-01-13 11:33:51 UTC
Created attachment 205033 [details]
The original xlsx attachment saved as ODS

This is related to bug 169997

When attachment 204666 [details] is saved as XLSX and reloaded, it looks like the form controls move downwards a bit.
This seems to happen because the row height for the first few rows (at least) is reduced by a few hundredth millimeters, which adds up.

1. Open attachment 204666 [details]
2. Right click on the row header 1 (checkec until 10, all the same), select Row Height...
-> Row height is 0.53 cm, the Standard Value box is unchecked
3. Save as ODS, reload
-> checkboxes look to jump down a bit, the box in cell B5 seems to have jumped from sticking to the top border of the cell to sticking to the bottom border of the cell
4. Right click on the row header 2, select Row Height...
->  Row height is 0.49 cm.

Version: 26.2.0.1.0+ (X86_64)
Build ID: bdc4b4cafd092ead7eb5a0fc67d02b9c289f8df7
CPU threads: 32; OS: Linux 6.14; UI render: default; VCL: gtk3
Locale: hu-HU (hu_HU.UTF-8); UI: en-US
Calc: threaded

Seems to have changed in 6.2, before this commit the row height was kept 0.53 cm:

https://git.libreoffice.org/core/+/1e55a47e89a9d9d6cf9cb3993484022aaf2c097b

commit 1e55a47e89a9d9d6cf9cb3993484022aaf2c097b	[log]
author	Vasily Melenchuk <Vasily.Melenchuk@cib.de>	Fri Apr 06 20:19:10 2018 +0300
committer	Thorsten Behrens <Thorsten.Behrens@CIB.de>	Fri Jun 08 00:47:06 2018 +0200
tree 3a3372525645775c32721e59ce8c205c8f474ffd
parent 2a7f74900fb646235b74d4c9bd4690e44edc3ed4 [diff]

tdf#62268: allow row height recalculation on document load
Comment 1 Gabor Kelemen (Collabora) 2026-01-13 11:35:10 UTC
Created attachment 205034 [details]
Screenshot of the xlsx and its saved ods version in Calc
Comment 2 Gabor Kelemen (Collabora) 2026-01-13 11:40:44 UTC
Correction: "saved as XLSX and reloaded,"  - it must be saved as ODS.
Comment 3 raal 2026-01-16 17:33:04 UTC
(In reply to Gabor Kelemen (Collabora) from comment #0)
> 
> 1. Open attachment 204666 [details]
> 2. Right click on the row header 1 (checkec until 10, all the same), select
> Row Height...
> -> Row height is 0.53 cm, the Standard Value box is unchecked

Hello, tested with Version: 26.8.0.0.alpha0+ (X86_64) and the Standard Value box is checked