Creating a pivot table (PT) to a spreadsheet adds 6 cell styles for each PT category. Pivot Table Cell Styles: -Pivot Table Categories -Pivot Table Corner -Pivot Table Field -Pivot Table Result -Pivot Table Value -Pivot Table Title To format a PT with persistent formatting (immune to PT refresh/update), user must use the added cell style. However, number format of these cell styles cannot be formatted in the cell style itself, but must be formatted in the data source. This property must be highlighted. Sources: https://bugs.documentfoundation.org/show_bug.cgi?id=61840#c8 https://books.libreoffice.org/en/CG72/CG7208-PivotTables.html#toc32 Suggestion: Add the page to the /scalc/guide/ folder as in https://help.libreoffice.org/master/en-US/text/scalc/guide/datapilot.html?&DbPAR=CALC&System=UNIX
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/4e1b00e5d940b647b550b3314985ebb775be2543 tdf#149218 Add pivot table formatting help page
Olivier Hallot committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/help/commit/0b426bb3f2919aa34e8064de4b265a45cc6954cc tdf#149218 Add pivot table formatting help page