Issue 83161 - "Undo" incorrectly changes row height
Summary: "Undo" incorrectly changes row height
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.3
Hardware: PC Windows Vista
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-10-31 15:07 UTC by timwi
Modified: 2017-05-20 11:11 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description timwi 2007-10-31 15:07:18 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".
Comment 1 helenrussian 2007-11-10 20:47:49 UTC
Confirm on Linux
Comment 2 kpalagin 2007-12-10 09:33:46 UTC
Confirming using 2.3m235 on WinXP - as described.

timwi, helen
Comment 3 frank 2007-12-10 12:11:55 UTC
Hi Niklas,

please have a look at this one.

Comment 4 ngjeremy 2008-02-05 03:49:59 UTC
I replicated the bug with 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 " 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.

- 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
- 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)
Comment 5 Marcus 2017-05-20 11:11:28 UTC
Reset assigne to the default "".