Apache OpenOffice (AOO) Bugzilla – Issue 105806
Alignment in Table Control column doesn't stick
Last modified: 2010-01-10 16:10:56 UTC
I have placed a Table Control on a subform with a Formatted Field type column in it. I can change the Alignment property for this column from Default to Center and it works fine when I turn design mode off and return to design mode. But, when I save the form design, close the form and re-open it in design mode the Alignment property has reverted to Default. I do not have this problem for stand-alone Formatted Fields on the main form. The settings I have chosen for the Formatted Field in the Table Control that I think might be relevant are: Enabled - Yes, Read-only - No, Formatting - 1234.57|Number Format|Category - Text|Format - @, Alignment - Center, Hide Selection - Yes I am connecting to MySQL 5.0.45-community-nt, Via ODBC 5.1. Thanks. John David Heinzmann
What did you use? MySQL-ODBC or the native mysql-connector
I believe I am using MySQL ODBC. Let's see... with OOo Base open, Edit|Database|Connection Type shows "MySQL (ODBC)". The Windows ODBC Data Source Administrator lists it as "MySQL ODBC 5.1 Driver".
checked w/ OO.o 3.1.1 and OOO320m_1, go-oo 3.0.1, emb HSQL, Linux Tested w/ text, currency, numeric, and combobox column types All columns in a table control loose custom setting to alignment property for column controls after save to the forms container -or- on load from the forms container.
OK - looks like it is the save to container step. Looked at an the content.xml for an embedded form and compared it that of a saved Writer file's content.xml with nothing but a table control. Both created w/OOO320m_1, in both cases I had one tabe control and changed the column "Description" to alignment 'center', saved and closed the files. In the writer file there is the an element "form:text-style-name=" added to the grid column entry for a column with the custom alignment setting. i.e. <form:column form:name="TextField1" form:control-implementation="ooo:TextField" form:label="Description" form:text-style-name="ctrl2"><form:text form:id="control5" form:data-field="Description" form:convert-empty-to-null="true"><form:properties><form:property form:property-name="DefaultControl" office:value-type="string" office:string-value="com.sun.star.form.control.TextField"/></form:properties></form:text></form:column> The text-style named is defined earlier in the file with the custom setting. i.e. <style:style style:name="ctrl2" style:family="paragraph"><style:paragraph-properties fo:text-align="center"/> In the embedded form this form:text-style is completely missing. i.e. <form:column form:name="Description" form:control-implementation="ooo:TextField" form:label="Description"><form:text form:id="control5" form:data-field="Description" form:convert-empty-to-null="true"><form:properties><form:property form:property-name="DefaultControl" office:value-type="string" office:string-value="com.sun.star.form.control.TextField"/><form:property form:property-name="Width" office:value-type="float" office:value="603"/></form:properties></form:text></form:column>
fixed in CWS dba33a find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33a
fs->msc: please verify in CWS dba33a
targeting to 3.3, since the fix is part of a CWS aiming for this release
verified in CWS dba33a find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33a
Checked using DEV300m_69 / Ubuntu Closing