Ask Your Question

Calc - pivot table looses its column and row formats on refresh

asked 2019-06-12 13:36:35 +0100

artofit gravatar image

updated 2020-08-05 01:04:09 +0100

Alex Kemp gravatar image

Hi, I have a pivot table. I format the columns, such as

  1. aligning the header row in top-center with certain width
  2. add a conditional formation on a column (Format>Conditional>Conditions...)
  3. put some number formating such as with 2 decimals

Then, when I refresh the pivot table, I loose both these formatting.

How to refresh the pivot table content, but not change the formatting of the cells


P.S: Is it a bug? Using LO 6.1

edit retag flag offensive close merge delete


It has been always this way and afaik there is no way to prevent from this to happen on refresh (and I would not consider this as a bug). If you need pivot data in "nice looking" formatted tables, you may take a look at function GETPIVOTDATA

Opaque gravatar imageOpaque ( 2019-06-12 13:46:28 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-06-12 16:21:13 +0100

m.a.riosv gravatar image

I think the only thing that you can do, it's edit the styles of every part of the pivot table, but then it applies to all pivot tables in the spreadsheet.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-12 13:36:35 +0100

Seen: 402 times

Last updated: Jun 12 '19