Comment 0 for bug 646157

Revision history for this message
Ilja Sekler (ilja-sekler-) wrote : Calc loses row height value when modifying a cell

Binary package hint: openoffice.org

The version of Go-OO Calc as used in Ubuntu Maverick and Lucid forgets the initial non-default row height when modifying a cell within this row. It required that the spreadsheet was created by Microsoft Excel and saved in the binary .xls format, Excel spreadsheets created by OpenOffice.org doesn't trigger the bug.

A testcase: <http://www.exinfm.com/excel%20files/capbudg.xls>

STR:

1. Select the cell A1 in testcase spreadsheet (capbudg.xls).

2. Check the row height (Format / Row / Height). The displayed value is 0.35'' (0,88cm).

3. Modify e.g. the font or the background color in A1.

4. Check the row height again.

Actual Results: the row height has become 0.31'' (0,79cm). 'Undo' doesn't revert the changes of the row height.

Expected Results: the row height in Step 4 is the same as in Step 2.

This is a regression, didn't see this happen on Lucid with ubuntu-proposed at least before 2010-06-03. The bug doesn't exist in the vanilla OpenOffice.org 3.2.1 or 3.3.0beta1 by Sun/Oracle.

openoffice.org-calc 1:3.2.1-6ubuntu2

Microsoft TrueType core fonts are installed, if this matters.