Apache OpenOffice (AOO) Bugzilla – Issue 3865
Linear Regression line attributes (style/color/width) not saved
Last modified: 2013-02-24 21:22:21 UTC
After selecting data, object properties, statistics, linear regression and having the line appear in the chart I selected the regression line and altered is properties: Style from continuous to ultrafine Color from Bordeau to Black Width from .04 to .01 and click OK. If you save the spreadsheet, close the file then re-open the spreadsheet the referenced line attributes have reverted back to default. BTW the Version Found In is 641-D. I intend to attach the spreadsheet as soon as I determine how.
Created attachment 1323 [details] Spreadsheet and sample chart with linear regression data
I'll have a look at it, Peter
Hi Björn, this one's for you. Regards, Peter
The attributes are missing, because they are missing in the XML specification. Therefore we would have to change the file-format, which is not that easy. Currently, in XML, regression-cruves and mean values are enabled by setting properties at a series' auto-style. We would have to change this such that those become sub-elements of the series elements with their own auto-style properties. To not become incompatible to older binaries, we would have to store the information redundantly, i.e., as property as well as by providing a sub-element.
For a fix you need the following files: xml\xmloff\dtd\chart.mod,v1.31 xml\xmloff\dtd\chart.mod,v1.30 xml\xmloff\dtd\nmspace.mod,v1.5 xml\xmloff\dtd\office.mod,v1.46 xml\xmloff\inc\SchXMLImport.hxx,v1.19 xml\xmloff\inc\xmltoken.hxx,v1.32 xml\xmloff\source\chart\SchXMLExport.cxx,v1.66 xml\xmloff\source\chart\SchXMLExport.cxx,v1.65 xml\xmloff\source\chart\SchXMLImport.cxx,v1.27 xml\xmloff\source\chart\SchXMLPlotAreaContext.cxx,v1.28 xml\xmloff\source\chart\SchXMLPlotAreaContext.hxx,v1.15 xml\xmloff\source\core\xmltoken.cxx,v1.34
*** Issue 5086 has been marked as a duplicate of this issue. ***
*** Issue 8436 has been marked as a duplicate of this issue. ***
*** Issue 8555 has been marked as a duplicate of this issue. ***
closed