Bug 68781

Summary: FILEOPEN chart-in-writer drops date values
Product: LibreOffice Reporter: Lionel Elie Mamane <lionel>
Component: ChartAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: iplaw67, lionel, markus.mohrhard, robert
Version: unspecified   
Hardware: All   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=68663
https://bugs.freedesktop.org/show_bug.cgi?id=84882
https://bugs.freedesktop.org/show_bug.cgi?id=87012
Whiteboard:
i915 platform: i915 features:
Attachments: reproduction example (as generetad by Base Report Builder)
reproduction example (without date-scale)
reproduction example (without any date format)

Description Lionel Elie Mamane 2013-08-31 07:24:36 UTC
Created attachment 84950 [details]
reproduction example (as generetad by Base Report Builder)

Consider the attached document (created by Base Report Builder).

It contains a chart (and not much else). It uses internal data, that comes in <table:table table:name="local-table">. It contains two columns:

 - column A: categories (locations on X axis)
   values 5 20 25 40

 - column B: data series labelled 'Date'
   values 2013-01-12 2013-02-23 2013-03-02 2013-10-02

Now, open (in Writer) the data table of the chart. The "Date" data series is all blank; the values were purely and simply dropped.

On the other hand, the "Categories" column (series) is formatted as dates. I also don't understand why that is. The only date format in the chart object (content.xml) is  <number:date-style number:automatic-order="true" style:name="N10051">, which is used only in <style:style style:family="chart" style:name="ch5" >, which itself is used only on the *y* axis, while the categories are used for the *x* axis, and the format does not match anyway. I thought, maybe this is because of the <chartooo:date-scale/> tag on the x, but even if I remove it (see second attachment: "without date-scale"), they still get displayed as dates.
Comment 1 Lionel Elie Mamane 2013-08-31 07:25:49 UTC
Created attachment 84951 [details]
reproduction example (without date-scale)
Comment 2 Lionel Elie Mamane 2013-08-31 07:31:34 UTC
Created attachment 84952 [details]
reproduction example (without any date format)

Even without any hint of any date-related anything in the file (except the values in the *SECOND* column which have nothing to do with the categories!), the categories are still shown as dates.
Comment 3 Alex Thurgood 2013-09-02 15:08:43 UTC
Who usually handles chart XML integration into Writer ?

Alex
Comment 4 Lionel Elie Mamane 2014-07-23 06:29:00 UTC
Markus, since you are our Chart guy, what do you think about this one? Thanks in advance.

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.