https://bugs.documentfoundation.org/show_bug.cgi?id=146844
Bug ID: 146844
Summary: PIVOTTABLE Repeated pivot item labels are text, even
if original is number
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When a row field in a pivot table contains numeric data, and the "Repeat item
labels" option is on, the additional labels are text, not numbers. This affects
sorting and grouping negatively - items which used to contain the same data are
no longer equal.
Steps to Reproduce:
Open attached spreadsheet. Notice the behavior of the item labels as described
Actual Results:
Additional labels are text. ISTEXT(<label>) returns TRUE, ISNUMERIC(<label>)
returns FALSE
Expected Results:
Additional labels are same datatype as the first one. ISTEXT(<label>) returns
TRUE, ISNUMERIC(<label>) returns FALSE
Reproducible: Always
User Profile Reset: No
Additional Info:
N/A
--
You are receiving this mail because:
You are the assignee for the bug.
