Bug 132964 - Pivot table - Cells formatted as text and containing numeric values treated as different values
Summary: Pivot table - Cells formatted as text and containing numeric values treated a...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.6.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-05-11 19:26 UTC by Grobe
Modified: 2020-05-11 20:15 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
coloumn B in pivot table should be threated as one value (57.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-05-11 19:26 UTC, Grobe 		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 Grobe 2020-05-11 19:26:12 UTC 
Created attachment 160698 [details]
coloumn B in pivot table should be threated as one value
Comment 1 Grobe 2020-05-11 19:38:50 UTC 
Realized the headline was bad because after I uploaded I realized that one occurrence (cell E21 in Sheet1) was actually formatted as number.

Steps to reproduce:
* Open attachment.
* Sheet1, go to cell E21
* Format cell and select "Text".
* Change active sheet to Pivot Table_Sheet1_1
* Refresh the pivot table.

Expected result:
* Row 2 and row 3 should collapse and become one row.

Observed result:
* No change - Row 2 and row 3 continues to stay as if it was two different values.
Comment 2 m_a_riosv 2020-05-11 20:15:20 UTC 
Changing cell's format doesn't change cell's content, you need to edit E21 and reintroduce the value (add and delete a space to the end)to get it being text. Then pt works as you expect.