https://bugs.documentfoundation.org/show_bug.cgi?id=170875
--- Comment #4 from Thierry Menigoz <[email protected]> --- My point is not about the calculated values that are correct. It is about the display format of these values. In fact, as I found no way to handle display format of values in the pivot table itself (e.g. like in Excel) LibO help says that the display format in pivot table is to be handled through the format of the data. Therefore, in column G in sheet Feuille_1, as I do not want decimals to appear in the result of pivot table, I applied format for monetary value WITHOUT decimal. As you can see in attachment, this particular format is displayed in the totals per year ==> this is OK But, in the "grand total" column (column N in the Table_dynamique-feuille_1_1 worksheet) the values shown are not respecting this format (they look like the default number format). For test, I also applied a format displaying two decimals for the quantities (column D in sheet Feuille_1). This format is respected in the totals per year (== OK) but not in the "grand total" (colmun M in the Table_dynamique-feuille_1_1 worksheet) Here again, they look like the default number format. -- You are receiving this mail because: You are the assignee for the bug.
