Pivot table average over rides number format?


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

image description



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

image description

Tested using LibreOffice:

Version:; 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.

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