Ask Your Question

Number format changes in Calc pivot tables [closed]

asked 2013-05-08 17:44:23 +0200

rwigle gravatar image

updated 2015-11-02 18:37:21 +0200

Alex Kemp gravatar image

In my pivot table, I set the numeric format on the whole sheet (containing the pivot table) to 2 decimal places. If I change the Page Field to another selection, the format in the pivot table reverts to general. Is there a way to overcome this?

I am using Calc (Ubuntu 12.04).

Thanks in advance.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-02 18:37:37.607832

2 Answers

Sort by » oldest newest most voted

answered 2013-06-16 22:41:49 +0200

m.a.riosv gravatar image

Theoretically, if you want change the format heritage from source data, you can change the styles for Pivot Table Menu/Format/Styles&Formatting the styles with the name beginning with Pivot Table.
But seems that it doesn't work actually. I have reporting a bug pending of confirmation, fdo#64440. I know that Kohei, a great developer, who usually solves the Pivot Table issues, is doing a deep work on the scalc core code, so maybe we need to be bit patients waiting for a solution.

edit flag offensive delete link more

answered 2013-06-16 21:16:38 +0200

adamf gravatar image

Same problem here.

edit flag offensive delete link more

Question Tools


Asked: 2013-05-08 17:44:23 +0200

Seen: 1,435 times

Last updated: Jun 16 '13