Bug 68781 - FILEOPEN chart-in-writer drops date values
Summary: FILEOPEN chart-in-writer drops date values
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version: unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-08-31 07:24 UTC by Lionel Elie Mamane
Modified: 2014-12-18 04:43 UTC (History)
4 users (show)

See Also:
i915 platform:
i915 features:


Attachments
reproduction example (as generetad by Base Report Builder) (7.06 KB, application/vnd.oasis.opendocument.text)
2013-08-31 07:24 UTC, Lionel Elie Mamane
Details
reproduction example (without date-scale) (7.08 KB, application/vnd.oasis.opendocument.text)
2013-08-31 07:25 UTC, Lionel Elie Mamane
Details
reproduction example (without any date format) (6.99 KB, application/vnd.oasis.opendocument.text)
2013-08-31 07:31 UTC, Lionel Elie Mamane
Details

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.