Pivot table average over rides number format?

[Gavgargan]

Hi

I have an issue with a pivot table. I have an average being calculated which works fine. However every time I refresh the pivot table it puts the number format to multiple decimal places. I can format the cells back to 2 decimal places (as desired) but it never sticks.

Am I missing something?

Small example

Thanks

[anon73440385]

Hello,

if you want the Pivot-Table to show a certain number of decimal places, you need to format the value column explicitly using the desired decimal places. Hence

• Select column value
• Right click -> Format Cells.. -> Tab: Numbers
• Use Format code 0.00
• Refresh your Pivot Table

Tested using LibreOffice:

Version: 7.0.1.2; Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US; Calc: threaded

Hope that helps.

[anon73440385]

In fact it seems to be sufficient if a single value within the range being formatted this way.