[Libreoffice-bugs] [Bug 113002] New: LibreOfficeCalc: Pivot Table recurring data field name will added a simple quotation marks before number

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 113002
           Summary: LibreOfficeCalc: Pivot Table recurring data field name
                    will added a simple quotation marks before number
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: camisso at hotmail.com

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.

-- 
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/20171008/0aa872f9/attachment.html>