Bug 58759 - FORMATTING: Excluding attributes from custom cell styles
Summary: FORMATTING: Excluding attributes from custom cell styles
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 108076 (view as bug list)
Depends on:
Blocks: Calc-Styles
  Show dependency treegraph
Reported: 2012-12-25 18:46 UTC by Marmel
Modified: 2022-02-17 13:54 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Selective Style Attributes in Excel (3.90 KB, image/png)
2012-12-25 18:46 UTC, Marmel
Selective Style Attributes in Excel - Proper Attachment (3.90 KB, image/png)
2012-12-25 18:57 UTC, Marmel
ms (38.92 KB, application/pdf)
2018-04-05 14:55 UTC, martha Simons
ms (38.92 KB, application/pdf)
2018-04-05 14:57 UTC, martha Simons
ms (38.08 KB, application/pdf)
2018-04-05 14:58 UTC, martha Simons

Note You need to log in before you can comment on or make changes to this bug.
Description Marmel 2012-12-25 18:46:06 UTC
Created attachment 72114 [details]
Selective Style Attributes in Excel

When I create a new cell style in Calc it applies every attribute (font, font effect, border, etc.) to the cell.

Nearly all styles I will use need to exclude at least one or several of these attributes.

For example:

1) I need a style to set the number style, font, font effect, and background to all cells in a column. I do not want the style to modify the various borders found in the column.
2) I need a style with font, font effect, background and it will be appied to several columns and rows containing various different types of numbers (decimal places, currency, etc). I do not want the style to modify the attributes of the numbers.

How do I create a style to only modify certain/intended attributes?

I created a thread on the LibreOffice forum from which I determined that this feature is missing from the current (3.5.7 & 3.6.4) LibreOffice releases:

In Excel, when you create a custom style, there are checkboxes for each of the attributes you want to include in the style.

I've attached a screenshot of this feature in Excel. I need this same functionality (feature parity) in LibreOffice.
Comment 1 Marmel 2012-12-25 18:55:57 UTC
Comment on attachment 72114 [details]
Selective Style Attributes in Excel

Comment 2 Marmel 2012-12-25 18:57:08 UTC
Created attachment 72115 [details]
Selective Style Attributes in Excel - Proper Attachment
Comment 3 Joel Madero 2014-05-05 04:56:40 UTC
Thank you for reporting this enhancement request! I can confirm that this is a valid enhancement request on:
Version: Build ID: 84862db95a5e22b9ef89baa2a8a5deeffefbdef6
Date:   Thu Apr 24 21:43:16 2014 +0300
Platform: Ubuntu Linux 14.04 x64
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 
As I've been able to confirm the enhancement request I am marking as:

New (confirmed)
high - sounds like this would be really useful for quite a few people

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 
LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link:

There are also other ways to get involved including with marketing, UX, documentation, and of course developing -  http://www.libreoffice.org/get-help/mailing-lists/. 

Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material
Comment 4 Marmel 2015-01-11 00:15:42 UTC
Thank you for confirming this enhancement request.

Has any progress been made on this?
Comment 5 Joel Madero 2015-01-11 00:49:13 UTC
No - and to be honest, enhancement requests sometimes never get implemented. Confirming it simply said that it was a valid enhancement. A volunteer has to choose to take on the enhancement - or you can submit a patch or pay a third party to have it completed.

With thousands of bugs and thousands of enhancement requests, or volunteer developers are stretched quite thin.

Thanks for your understanding and patience. If you're ever interested in helping out (in a non technical way) feel free to jump into our chat :) We always appreciate the help.

Comment 6 Buovjaga 2017-06-04 13:10:53 UTC
*** Bug 108076 has been marked as a duplicate of this bug. ***
Comment 7 Kevin 2017-06-05 08:02:51 UTC
I think calling this an enhancement request is insulting to users. It's a completely worthless feature if you can't apply a subset of font attributes and it violates what everyone in the world thinks of as "styles". See 108076 for more examples and arguments as to why this is not only a bug, but one which tarnishes the reputation of this whole project. You engineers in your ivory towers need to sit down and do a full day's work on menial formatting tasks to realize just how appallingly bad the user interface is. And yes, it's still better than Excel.
Comment 8 martha Simons 2018-04-05 14:55:26 UTC
Created attachment 141137 [details]
Comment 9 martha Simons 2018-04-05 14:57:09 UTC
Created attachment 141139 [details]
Comment 10 martha Simons 2018-04-05 14:58:23 UTC
Created attachment 141140 [details]
Comment 11 Xisco Faulí 2019-11-29 13:27:01 UTC
Changing priority back to 'medium' since the number of duplicates is lower than 5
Comment 12 Marmel 2022-02-17 13:54:55 UTC
Now in the year 2022 it appears this is still a limitation of Calc.

Is there a workaround or some functionality I'm missing?

Seems this would fall under "basic feature parity with Excel".