Ask Your Question
1

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: 4.2.3.3 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
1

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

jumbo444 gravatar image

Hi,

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

Comments

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

Stats

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

Seen: 229 times

Last updated: Jun 24 '14