Apache OpenOffice (AOO) Bugzilla – Issue 60212
Row height change inconsistently affects control
Last modified: 2017-05-20 11:13:38 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.
Created attachment 33025 [details] long lines and buttons in OO spreadsheet to demonstrate inconsistent formating
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.
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.
Created attachment 33089 [details] buttons and long text generated in content.xml, but do not align when in oo
Hi Niklas, seems to be your construction site. Frank
*** Issue 78967 has been marked as a duplicate of this issue. ***
Reset assigne to the default "issues@openoffice.apache.org".