Issue 83161

Summary:	"Undo" incorrectly changes row height
Product:	Calc	Reporter:	timwi <timwi>
Component:	editing	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	helenrussian, issues, kpalagin
Version:	OOo 2.3
Target Milestone:	---
Hardware:	PC
OS:	Windows Vista
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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
thanks.

Comment 3 frank 2007-12-10 12:11:55 UTC

Hi Niklas,

please have a look at this one.

Frank

Comment 4 ngjeremy 2008-02-05 03:49:59 UTC

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)

Comment 5 Marcus 2017-05-20 11:11:28 UTC

Reset assigne to the default "issues@openoffice.apache.org".