Summary: | FILEOPEN chart-in-writer drops date values | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Lionel Elie Mamane <lionel> |
Component: | Chart | Assignee: | 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) |
Created attachment 84951 [details]
reproduction example (without date-scale)
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.
Who usually handles chart XML integration into Writer ? Alex 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.
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.