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: http://en.libreofficeforum.org/node/4954 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 on attachment 72114 [details] Selective Style Attributes in Excel deleted
Created attachment 72115 [details] Selective Style Attributes in Excel - Proper Attachment
Thank you for reporting this enhancement request! I can confirm that this is a valid enhancement request on: Version: 4.3.0.0.alpha0+ 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) Enhancement 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: https://wiki.documentfoundation.org/QA/BugTriage 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
Thank you for confirming this enhancement request. Has any progress been made on this?
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. http://webchat.freenode.net/?channels=libreoffice-qa
*** Bug 108076 has been marked as a duplicate of this bug. ***
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.
Created attachment 141137 [details] ms
Created attachment 141139 [details] ms
Created attachment 141140 [details] ms
Changing priority back to 'medium' since the number of duplicates is lower than 5
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".