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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
