Apache OpenOffice (AOO) Bugzilla – Issue 83161
"Undo" incorrectly changes row height
Last modified: 2017-05-20 11:11:28 UTC
Steps to reproduce: * Fill spreadsheet with random data, at least two columns * Select all (by clicking the top-left corner header) * Change font & font size to "Verdana", "8pt" * Now select second column (by clicking column header) * Select "Insert" => "Columns" * Select "Edit" => "Undo" EXPECTED BEHAVIOUR: The spreadsheet returns to exactly the state it was before inserting columns ACTUAL BEHAVIOUR: Row height in entire spreadsheet is increased visibly. If, after undoing, you insert the column a second time, the line height goes back to normal. It also goes back to normal if you select all and change font & font size again. Both workarounds are unacceptable for such a frequently needed function as "Undo".
Confirm on Linux
Confirming using 2.3m235 on WinXP - as described. timwi, helen thanks.
Hi Niklas, please have a look at this one. Frank
I replicated the bug with OpenOffice.org 2.3 on a PC with Window XP Media Center Edition 2002 Service Pack 2 with processor speed of 1.58Ghz and 1Gb of RAM. Procedure to Reproduce: 1. Open a new "OpenOffice.org Calc" spreadsheet file 2. Select all the cells by clicking the unlabeled box left of column A and top of row 1. All the cells should appear black. 3. Change the font size to 8 <Format -> Cells -> Font> There should be a noticeable shrinkage in the height of each row. 4. Select the entire Column A by clicking on the box labelled "A" and insert a new column <Insert -> Columns> The first column of cells should appear black. 5. Undo the insertion <Edit -> Undo> There should be a noticeable enlargement in the height of each row. Observations: - The row height seems to go back to the default row height after the undo (Font: 10, or, Row Height: 0.18") - The resizing of the row heights seem to be associated to only the latest Undo of the column insertion (I performed a follow-up test in which after the column insertion I tried to add data to it and do a whole bunch of modifications to it, including inserting another column, and then kept Undo'ing, and the row height changed upon the undo of the last column insertion) Another possible workaround for the bug is as follows: 1. After step 3. in "Procedure to Reproduce", check the row height <Format -> Rows -> Height> 2. After step 5. in "Procedure to Reproduce", select all cells, change the row height back to the value you checked in step 1. The failure will appear independent of the following conditions: - the way the steps were executed (e.g. whether you use "Ctrl-A" to select all, "Ctrl-Z" to undo, Right clicking on a column to insert column) - whether the font is changed to something else or not since the font stays the same - whether data has been added or not (although it helps to notice the failure more easily) - which column is selected when you do "insert columns" - whether other actions have been done prior to the set of actions in "procedure to reproduce" - if the font size was changed to one that is lower than 10 The failure does not appear under the following conditions: - if the font size was changed to one that is greater than 10 - if a row was inserted instead of a column - if the row height was changed in step 3 of "Procedure to Reproduce" rather than font size - if other changes were made to an entire column (e.g. Bold, Align)
Reset assigne to the default "issues@openoffice.apache.org".