Bug 128693 - PIVOTTABLE: With numbers as source of a PT column, when active repeat item labels, repeated values are text not numbers.
Summary: PIVOTTABLE: With numbers as source of a PT column, when active repeat item la...
Status: RESOLVED DUPLICATE of bug 113002
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.0.0.alpha1+
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency tree / graph
 
Reported: 2019-11-10 04:37 UTC by m_a_riosv
Modified: 2020-12-28 08:12 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Sample file for pivot table repeat item labels (11.13 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-11-10 04:38 UTC, m_a_riosv 		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 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 ***