Bug 146844 - PIVOTTABLE Repeated pivot item labels are text, even if original is number
Summary: PIVOTTABLE Repeated pivot item labels are text, even if original is number
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency tree / graph
 
Reported: 2022-01-18 19:56 UTC by Nis Jørgensen
Modified: 2022-09-25 18:44 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Bug reproduction (9.74 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-01-18 19:57 UTC, Nis Jørgensen 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Nis Jørgensen 2022-01-18 19:56:00 UTC 
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
Comment 1 Nis Jørgensen 2022-01-18 19:57:24 UTC 
Created attachment 177640 [details]
Bug reproduction
Comment 2 Roman Kuznetsov 2022-09-20 17:20:06 UTC 
Interesting, I just updated the Pivot table in your example, Nis, and all values became numbers as it should be

I tried to create the Pivot table from scratch using your data and got all numbers in the Pivot table at once

I used current developer build for the checking:

Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: a3bbdfab809609bec3475613a918eda699fbdc29
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: threaded

Could you please retest your problem in latest LibreOffice 7.4.1?
Comment 3 Nis Jørgensen 2022-09-25 18:02:18 UTC 
Confirming that this is fixed in 7.4.1.2.

I am not certain of procedures around here, but I believe the status of this bug could be changed to RESOLVED.
Comment 4 Roman Kuznetsov 2022-09-25 18:16:57 UTC 
Nice, thanks. So closed as WFM (because we don't know what was the patch)