Ask Your Question

How do I keep Calc from defaulting to % every time I refresh the data in a pivot table? [closed]

asked 2014-05-24 21:10:17 +0200

pgoings gravatar image

updated 2015-09-03 03:55:08 +0200

Alex Kemp gravatar image

When the data is refreshed on the pivot table it always defaults to %.

Calc Version: Build ID: 420m0(Build:3)

Ubuntu 14.04 Linux Kernel 3.13.0-24

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-26 09:23:33.059232

1 Answer

Sort by » oldest newest most voted

answered 2014-05-24 21:41:04 +0200

jumbo444 gravatar image


Format of cells in pivot table are managed through style. So modify the styles of the cells will prevent reset of format when refreshing.

edit flag offensive delete link more


Hi, How do I save the style? I can change the style but when I refresh it still goes back to percents.

pgoings gravatar imagepgoings ( 2014-06-01 16:28:50 +0200 )edit

Question Tools

1 follower


Asked: 2014-05-24 21:10:17 +0200

Seen: 257 times

Last updated: Jun 24 '14