Bug 128693

Summary: PIVOTTABLE: With numbers as source of a PT column, when active repeat item labels, repeated values are text not numbers.
Product: LibreOffice Reporter: m_a_riosv <miguelangelrv>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal CC: oliver.brinzing, p.horta
Priority: medium    
Version: 6.4.0.0.alpha1+   
Hardware: All   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 103381    
Attachments: Sample file for pivot table repeat item labels

Description m_a_riosv 2019-11-10 04:37:44 UTC 
Description:
When in a pivot table column the option for repeat labels is on, and origin values are numbers, repeated values are text, only the first one is number.


Steps to Reproduce:
1. Open attached file
2. Update pivot table, right-click on it.
3. Take a look to the formula testing if the values are numbers.



Actual Results:
Only the first value is number, repeated are text.


Expected Results:
First and repeated values being numbers.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Really an issue when you want to use that value in other formulas.
Comment 1 m_a_riosv 2019-11-10 04:38:32 UTC 
Created attachment 155670 [details]
Sample file for pivot table repeat item labels
Comment 2 Mike Kaganski 2019-11-10 12:40:47 UTC 
Repro with Version: 6.3.3.2 (x64)
Build ID: a64200df03143b798afd1ec74a12ab50359878ed
CPU threads: 12; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

Additional info (to show what is happening):

4. Right-click on the PT, Properties...
5. Double-click "number" in Row Fields
6. Options...
7. Uncheck "[] Repeat Item Labels", confirm  everything, see how the TP layout changed.
Comment 3 m_a_riosv 2019-11-10 16:27:36 UTC 
About the layout, I can't see a misbehavior unchecking the option, I get the same layout than creating a new pt without the option.
Comment 4 m_a_riosv 2020-08-17 11:21:14 UTC 
*** Bug 135827 has been marked as a duplicate of this bug. ***
Comment 5 Paulo Horta 2020-08-17 13:28:25 UTC 
I opened a bug report for dates. I guess it's the same issue.
Comment 6 Paulo Horta 2020-08-26 07:49:08 UTC 
Just installed LibreOffice 7.0.0.3 and the issue is still present
Comment 7 m_a_riosv 2020-12-28 08:12:06 UTC 

*** This bug has been marked as a duplicate of bug 113002 ***