Bug 67307

Summary:	Y error bars settings not loaded properly
Product:	LibreOffice	Reporter:	faber
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	medium	CC:	jbfaure, markus.mohrhard
Version:	4.1.0.4 release
Hardware:	Other
OS:	All
Whiteboard:
i915 platform:		i915 features:
Attachments:	File with 'cell range' y errors in a chart

Description faber 2013-07-25 15:00:04 UTC

I have a series of graphs that use Y error bars which are fed from cell values, for positive and negative range separately.

When I load a ODS file containing such Y error bars, the settings are modified to "Same value for both" and both cell ranges are set to the same value (the cells for the positive range).

Once manually corrected, the settings stay put as long as the document is opened.

In the stored file the attributes seem to be set correctly:

<style:chart-properties [..] chart:error-category="cell-range" chart:error-upper-range="Zugfestigkeit.B30:Zugfestigkeit.M30" chart:error-lower-range="Zugfestigkeit.B29:Zugfestigkeit.M29" [..]

So this error seems to occur when loading a file containing such Y error bars.

Comment 1 ign_christian 2013-07-26 03:20:34 UTC

Perhaps related to Bug 60083

Comment 2 faber 2013-07-26 05:16:02 UTC

Yes, the whole error bar topic seems to have a funny smell. Sorry for my wrong title, btw.: s/sav/load

I have also noticed that sometimes the error bars disappear completely while working in the sheet, but I was not able to create a reproducible sequence of steps (yet).

Comment 3 Jean-Baptiste Faure 2013-09-07 10:56:40 UTC

Updated summary due to comment #2.

Please, could you attach an example file ?
Did you experienced the same problem with LO 4.0.x or is it new in 4.1.0 ?

Best regards. JBF

Comment 4 faber 2013-09-10 04:58:57 UTC

It occured in all 4.x versions I have tested so far (currently 4.1.1.2). 

The attached file is a very basic chart with y error bars. In the Object 1/content.xml we can see:

chart:error-upper-range="Sheet1.B4:Sheet1.K4" 
chart:error-lower-range="Sheet1.B5:Sheet1.K5"

But when loaded, we can see that "Same value for both" is checked and only the positive range is displayed in both text fields.

Comment 5 faber 2013-09-10 04:59:59 UTC

Created attachment 85529 [details]
File with 'cell range' y errors in a chart

Stored with different ranges for positive and negative values.

Comment 6 Jean-Baptiste Faure 2013-09-11 04:59:28 UTC

I reproduce the problem with the attachment with both LO 4.0.5 and LO 4.1.x. If I modify the Y error bars to have positive and negative range separately and save the modified file with LO 4.0.5, then it opens fine and the change is preserved.
Looking at the Object 1/content.xml, one can see that data for error bars are not stored in the same way. If I read correctly, there is 2 boolean values chart:error-upper-indicator and chart:error-lower-indicator that are not in the bugdoc.

Hi Markus, please, could you have a look? I am not sure, but this behavior seems to be linked in some way to your improvements on error bars.

Comment 7 Jean-Baptiste Faure 2013-11-09 18:55:37 UTC

Forgot to set the status to NEW.
I still reproduce the problem with LO 4.1.4.0.0+ under Ubuntu 13.10 x86-64


Best regards. JBF

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.