[Libreoffice-bugs] [Bug 116601] New: Pivot chart can't be time based

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116601

            Bug ID: 116601
           Summary: Pivot chart can't be time based
           Product: LibreOffice
           Version: 5.4.6.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: philippe at hemmel.fr

Created attachment 140849
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140849&action=edit
example spreadsheet

## Steps to reproduce

* create a table with 2 columns. The first column contains dates, its header is
called "date""
* create a pivot table with the "date" column as row field, the second column
as a column field
* create a pivot chart based on the pivot table, chart type "Line"

See the example document : web_error.ods

## Actual behaviour

* With a chart type Line, it's impossible to specify that the chart is time
based (the X axis)
* With a chart type XY, the X axis shows numbers and not dates, and the numbers
are related to the line number of each values in the pivot table

See the  sheet called "Table dynamique_php_error_1"

## Expected behaviour

The behavior must be the same as a normal chart based on a normal table (not a
pivot table) containing the same values (see sheet3 in the attached document)

* With a chart type Line, I should be able to specify that the chart is time
based (the X axis). 
        * the check box "time based" is in the second step of the chart wizard,
"Data range", which is inactive for a pivot chart
* With a chart type XY, the X axis should show dates and should be time based

It's a kind of a regression, because before the pivot chart function, I was
able to create a normal chart based on a pivot table that could have the
expected behaviour. Obviously the chart was not linked to the pivot table, but
it was easy to adapt.
It's more complicated now, as I have to copy all the data in another sheet to
create the right chart.

## Desktop configuration

**Operating system:** Linux 4.13 (Kubuntu 17.10 Artful 64 bits)

Plasma 5.12.3 (kubuntu-ppa/backports)

**LibreOffice version:** 

Version: 5.4.6.2
Build ID: 1:5.4.6~rc2-0ubuntu0.17.10.1
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: kde4; 
Locale: fr-FR (fr_FR.UTF-8); Calc: single

Coming from http://ppa.launchpad.net/libreoffice/libreoffice-5-4/ubuntu

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180324/d921af46/attachment.html>