<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 - LibreOfficeCalc: Pivot Table recurring data field name will added a simple quotation marks before number"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113002">113002</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>LibreOfficeCalc: Pivot Table recurring data field name will added a simple quotation marks before number
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>camisso@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>Hello,
e.g. for a given table:
Date Number
12.01.2008 1
15.01.2008 2
17.01.2008 1
28.01.2008 1
31.01.2008 17
14.02.2008 1
18.02.2008 1
28.02.2008 2
29.02.2008 1
09.03.2008 1
14.03.2008 1
31.03.2008 4
15.04.2008 1
17.04.2008 1
If I make a pivot table of this data, grouped by year and month, the year will
added a simple quotation marks before the number.
If I have already numbers, e.g. year, and I check at data field options
recurring names there will be a mismatch, the original numbers are numbers and
the recurring names are strings. No correct sorting is possible and Conditional
Formatting will work only for the numbers, not the recurring names.
Thank you in advance for your help.</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>