Bug 140806

Summary:	FORMATTING: Pivot table style number format is ignored when source number format is set
Product:	LibreOffice	Reporter:	esl <edleijten>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	79045_79045, edleijten, m22n42019, regeirs.forum
Priority:	medium
Version:	7.1.1.2 release
Hardware:	x86 (IA32)
OS:	Windows (All)
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=64440
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	103381
Attachments:	Simple pivot table to demonstrate bug

Description esl 2021-03-04 22:07:45 UTC

Description:
Modifying the number of decimals in the style of a pivot table is working correctly as long as the source data is not formatted. When the number of decimals in the source data is set, the pivot table is ignoring the decimals set in the style and shows the same number of decimals as the source data.

Steps to Reproduce:
1. Create pivot table from data without number formatting
2. Define number formatting in style
3. Set number of decimals in source data
4. Refresh pivot table

Actual Results:
Style number formatting is ignored

Expected Results:
Number formatting applied as per style


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Not sure which version this first occurred in. I've seen it in 6.x several versions, perhaps earlier, though didn't report it back then as I wasn't sure I didn't make a mistake.

Also it seems to be a re-occurrance of bug #64440

Comment 1 esl 2021-03-04 22:08:53 UTC

Created attachment 170218 [details]
Simple pivot table to demonstrate bug

Comment 2 Mx 2021-04-03 20:14:47 UTC

Comment on attachment 170218 [details]
Simple pivot table to demonstrate bug

The results in the dynamic table were entered by hand and not calculated by the table

Comment 3 esl 2021-04-03 20:44:27 UTC

I think you misunderstand the example.

The table in F9:G37 was added to show that the pivot table style number formatting is applied correctly in those cells, irrespective of source formatting in C9:C37.

However in the pivot table on tab "Pivot Table_Sheet1_1", the number formatting in the styles is only applied as long as the source does not have a defined number of decimals.

Comment 4 Roman Kuznetsov 2022-09-20 17:02:24 UTC

repro in

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