Bug 140375 - Calc Copy/Paste not retaining Row Height in xlsx
Summary: Calc Copy/Paste not retaining Row Height in xlsx
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium minor
Assignee: Not Assigned
Keywords: bibisected, bisected, filter:xlsx, regression
Depends on:
Blocks: XLSX
  Show dependency treegraph
Reported: 2021-02-12 15:42 UTC by M
Modified: 2022-05-15 23:51 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

ODS file for testing (8.46 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-01-27 13:12 UTC, Buovjaga

Note You need to log in before you can comment on or make changes to this bug.
Description M 2021-02-12 15:42:29 UTC
Description: Trying to copy and paste a cell with in the same sheet. When the cell is pasted into a new row, that entire row height reduces size to match the 12pt text.

I did test this and confirmed that the adjustment varies according to different text sizes within the same .30" row.

FYI, This functions properly in ODF, just not xlsx.

1 Create New sheet
2 select all (Cont A) or top left corner above #1.
3 Change row size to .30" and text size to 12pt.
4 enter in some test text in a few random cells.
5 Save as xlsx and close (Key step)... I'm saving as 2007-365 xlsx file
6 Re open file.
7 Right click on a populated cell and copy.
8 paste into a cell in an "unused" row..(this doesn't happen in a populated row)

At this point the pasted row has reverted back an optimal row height. my new height is showing .21". 

I have only tested on a x64 intel Windows 10 machine.
Comment 1 LeroyG 2021-02-12 16:22:41 UTC
Related question: https://ask.libreoffice.org/en/question/287746/
Comment 2 Buovjaga 2022-01-27 13:11:02 UTC
Bibisected with Linux 41max repo to
use direct calls to set row height, fdo#61721

For bibisecting, I used an .ods file that I saved to .xlsx each time.
Comment 3 Buovjaga 2022-01-27 13:12:04 UTC
Created attachment 177833 [details]
ODS file for testing

Use this as a starter file