Issue 60212

Summary: Row height change inconsistently affects control
Product: Calc Reporter: rnhainsworth <richard>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues, lars_o_hansen
Version: OOo 2.0Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
long lines and buttons in OO spreadsheet to demonstrate inconsistent formating
buttons and long text generated in content.xml, but do not align when in oo none

Description rnhainsworth 2006-01-08 14:50:28 UTC
When I change the row height in a spread sheet that has controls (pushbuttons)
in it, the effect on the button is inconsistent, depending on whether the button
is in the same row or not.

Please see attached example file.

If the row height is changed for the first text line (buttons are embedded below
the row), all the buttons move done appropriately, retaining their positions
relative to original rows.

If the row height is changed for a row that includes a button, all the buttons
below retain their position relative to the button on the row.

But the spacing between buttons is not conserved, as can be seen if the row
height is changed on a row placed between two buttons.

The issue occurs for other controls, eg. spinners.

Changing the properties of the control, eg., to protect position, does not
appear to have any effect.

My application, from which this example is derived, has several hundred lines,
most of which have buttons to contol cell contents. (A spreadsheet is used as
the contents are also linked be formulas between cells). The spread sheet is
generated from a perl program.

But row labels are sometimes too long, and we want to use spreadsheet formatting
to adjust the row heights. But then the visual linkage between the buttons and
the rows is lost.
Comment 1 rnhainsworth 2006-01-08 14:52:33 UTC
Created attachment 33025 [details]
long lines and buttons in OO spreadsheet to demonstrate inconsistent formating
Comment 2 lars 2006-01-09 17:18:53 UTC
Ok, if a row contains a button, buttons below that row are not moved when the 
row height is changed, normally buttons below a row are moved when the rows 
height is changed, so confirmed on Windows XP Pro SP2 with OOo 2.0.1.
Comment 3 rnhainsworth 2006-01-10 19:35:47 UTC
The following issue may be related to this. I was trying to find a work around.
I generated an xml file (currently perl CPAN only has modules working on sxc
format, so I have been using that format) that is then zipped.

Buttons are attached linked to cells, but only giving the width and height
properties for the controls in the cell draw definitions. The reason for this is
that without OpenOffice, it is not possible to calculate the positions of the
buttons. When 'style:use-optimal-row-height="false"' is used for the row style,
the buttons are correctly aligned to each cell. 

When the wrap option is set for cell styles and the
'style:use-optimal-row-height="true"' is used for the row style. The controls
(buttons) become disaligned.

What seems to be happening is that when OpenOffice reads in the file, it first
assigns the row height, calculates the positions of the buttons. Then it wraps
the text when necessary and changes the row height. At this point the buttons
become disaligned with the spreadsheet.

A sample file is attached. The 'content.xml' file in the zip archive was edited
by hand to try to demonstrate the problem. 
Comment 4 rnhainsworth 2006-01-10 19:37:41 UTC
Created attachment 33089 [details]
buttons and long text generated in content.xml, but do not align when in oo
Comment 5 frank 2006-03-09 14:47:02 UTC
Hi Niklas,

seems to be your construction site.

Comment 6 frank 2007-07-31 14:31:30 UTC
*** Issue 78967 has been marked as a duplicate of this issue. ***
Comment 7 Marcus 2017-05-20 11:13:38 UTC
Reset assigne to the default "".