<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Pivot chart can't be time based"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116601">116601</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Pivot chart can't be time based
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Chart
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>philippe@hemmel.fr
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=140849" name="attach_140849" title="example spreadsheet">attachment 140849</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=140849&action=edit" title="example spreadsheet">[details]</a></span>
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 <a href="http://ppa.launchpad.net/libreoffice/libreoffice-5-4/ubuntu">http://ppa.launchpad.net/libreoffice/libreoffice-5-4/ubuntu</a></pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>