Apache OpenOffice (AOO) Bugzilla – Issue 114111
[SRB] ODF spreadsheet report: invalid style:column-width
Last modified: 2017-05-20 10:22:10 UTC
now i've generated a spreadsheet document (from the same file attached to issue 112652), and it has the boolean-value problem, the styles.xml root element problem, and this new one: upload:///Table1_fixed.ods/content.xml[2,2066]:Error:attribute "style:column-width" has a bad value: the value does not match the regular expression "([0-9]*[1-9][0-9]*(\.[0-9]*)?|0+\.[0-9]*[1-9][0-9]*|\.[0-9]*[1-9][0-9]*)((cm)|(mm)|(in)|(pt)|(pc)|(px))". <style:table-column-properties style:column-width="3.0E-4cm"/>
Created attachment 71400 [details] fix this problem
this problem is caused by using Double.toString() (implicitly via String concatenation), which apparently (if the number is sufficiently small/large) writes an exponent. using String.format("%f") does not seem to write an exponent. so this problem probably occurs in other places where lengths are written. this attribute has the type "positiveLength" in the schema. the XMLSchema-2 "double" type, OTOH, apparently may have an exponent. so it would be a good idea to review the code where other lengths could be written in an invalid way.
target 3.3 (as discussed)
Fixed in cws dba33h
Please verify. Thanks. - Execute the report as described in issue 112652 - Use the resulting odt and upload it on http://tools.services.openoffice.org/odfvalidator/ - Run test => upload:///Table1_fixed.ods/content.xml[2,2066]:Error:attribute "style:column-width" has a bad value: the value does not match the regular expression "([0-9]*[1-9][0-9]*(\.[0-9]*)?|0+\.[0-9]*[1-9][0-9]*|\.[0-9]*[1-9][0-9]*)((cm)|(mm)|(in)|(pt)|(pc)|(px))". should be fixed
verified in CWS dba33h 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%2Fdba33h