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)
Version:
(earliest affected)
4.1.0.4 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, filter:xlsx, regression
Depends on:
Blocks: XLSX
  Show dependency treegraph
 
Reported: 2021-02-12 15:42 UTC by M
Modified: 2024-05-15 03:15 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


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

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
https://git.libreoffice.org/core/commit/e1c281c6c1a2bd55d99e1af2023444c960cf02a3
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
Comment 4 QA Administrators 2024-05-15 03:15:50 UTC
Dear M,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug