Ask Your Question

Can I simplify a style in Calc?

asked 2016-05-01 13:24:26 +0200

X9Tim gravatar image

updated 2016-05-01 13:32:47 +0200

I frequently use conditional formatting in spreadsheets to highlight significant data. For example the smallest number in a column.

The formatting I use is a Cell Style. I tend to create a few of them with simple names like BoldRed, DullGrey, BrightGreen, etc.

I recently noticed that every cell that was given DullGrey style had a green background and a thin border. I probably created the style quickly without thinking very hard...

When I go into CellStyle modify it shows the style as:

Name: DullGrey

Linked with: Default

Category: Custom Styles

Contains: Italic+RGB(102, 102, 153)+Centered horizontally+0+RGB(204, 255, 204), Not Transparent+Borders(Black, single, solid), Spacing 0.0cm

I want to simplify this so it just says:

Contains: Italic+RGB(102, 102, 153)

Every time I try to change anything it just adds more that I don't want to this list!!

My obvious work around was to create a new, simpler style. Then change the conditional formatting on the relevant cells to use the new style.

I could then probably delete the existing style or rename it...

Is there an easy way of removing formats from a style?

X9Tim LibreOffice ver on Ubuntu 14.04.4

edit retag flag offensive close merge delete

1 answer

Sort by » oldest newest most voted

answered 2016-05-01 17:14:06 +0200

m.a.riosv gravatar image

On every tab of the Styles dialog box, there is a standart button that you can use to recover default values for the tab.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-05-01 13:24:26 +0200

Seen: 40 times

Last updated: May 01 '16