Is there a way to change and keep a formatting style in calc.? [closed]

asked 2014-06-02 02:40:18 +0200

pgoings gravatar image

updated 2015-09-05 15:05:17 +0200

Alex Kemp gravatar image

Hi, Everytime I refresh my data the formatting defaults to percents that make no sense. If I click the % twice it goes back to a plain number. I have tried a custom format but the problem persists. Do I have to rebuild the pivor chart? I read about making it a template, but haven't figured that out yet. I need help. Thanks in advance.

LibreOffice calc Ubuntu 12.04 LTS

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by bencomp
close date 2014-06-24 00:02:21.879190


Please explain in details you do when "refresh my data". Where do you click % twice? How did you create and apply a customer format?

ROSt52 gravatar imageROSt52 ( 2014-06-02 05:45:53 +0200 )edit

I add data, then refresh the pivot table. The pivot table changes from general numbers, centered, and no borders to %, right aligned and heavy black borders. The toolbar % key changes it to two decmal places, then general numbers. If I highlight then select Format, Styles and Formatting, and choose a custom format I can get what I want, but I have to do this everytime I refresh. Thanks for your help.

pgoings gravatar imagepgoings ( 2014-06-04 15:00:40 +0200 )edit

Please update your previous question if you have more detailed information about the question:

bencomp gravatar imagebencomp ( 2014-06-24 00:03:34 +0200 )edit