Today there are only cell and page styles in the Styles and Formatting sidebar in Calc available. Similar to the character style feature in Writer, it would be useful to have the same for the content/input in Calc cells to format a single character/word/digit in addition to a whole cell style. The character dialog and the Styles and Formatting appearance in Writer could be reused in Calc. I don't know if ODF supports such character styles anyway.
I doubt there is the ability with spreadsheets to have character styles or else we would have had it already and the same feature would already exist in Excel, which it doesnt. If someone disagrees, please reopen.
(In reply to Yousuf Philips (jay) from comment #1) > I doubt there is the ability with spreadsheets to have character styles or > else we would have had it already and the same feature would already exist > in Excel, which it doesnt. If someone disagrees, please reopen. If these are the only arguments against this feature then please reopen the bug. Because that aren't arguments. With that the most feature requests could be closed. MSO Excel is a good comparison when a feature is missing in LibO, but not for a completely new feature. LibO should be more than an Excel clone. To the technical worry: Table cells with their cell styles contain a text:p element which can have a text:span element if there is some manual formatting of the cell content (that is a fact today). I can't see any difference to Writer in this case, principally. Even it could be possible to have paragraph and character styles within a cell style! What cool things you could do with this ... @Regina, what's your thought regarding ODF spec?
Do you have a use case / scenario that describes the advantage of a character style? I mean who enters that much text into Calc that part of this text needs special formatting with styles?
I'm a heavy user of character styles. In Writer. In Impress I would appreciate to have them, for now and then. But in Calc.. I don't object, but the change that I'll use them is very low. And then looking at how other already _not_ use cell styles.. So, no objection, but I would put my money&time on many other features first. (Which is irrelevant in deciding to keep an issue open or not :p )
Use case see https://bugs.documentfoundation.org/attachment.cgi?id=133664 of bug 107965. Many single characters have a color or are bold. What should the user do if he need italics+green instead of bold+black? I also use spreadsheets in my company with thousands of rows where special formatting like character style in Writer would simplify workflow and maintainability. Not using cell styles in Calc isn't a good argument against this bug. Most people don't use styles in Writer but we have this wonderful feature for interested users.
It's pretty simple to make a character bold. Having a character styles would allow to change all bold chars into italic. To me the formatting in Calc is still cell based as the equivalent to character style. Otherwise you add many information into one cell, what I don't see in the Beatles example.
(In reply to Heiko Tietze from comment #6) > To me the formatting in Calc is > still cell based as the equivalent to character style. Otherwise you add > many information into one cell, what I don't see in the Beatles example. But the information is already there in the file. Using manual formatting is the same thing (in principle) but without a GUI and without maintainability for all content with the same style (e.g. bold). For me, cells are similar to paragraphs because there is (already available) the possibility to format a small part of the content of a cell.
OK, Thomas example convinced me. Simply New!
Well lets see what Regina says about the ODF spec and hear Eike's take on the plausibility of this enhancement. I would assume that if this feature was implemented, it wouldnt be interoperable with OOXML.
Eike: Any thoughts on this enhancements?
What moggi said on IRC: <moggi> well, the problem is that you could never use character styles in formula results which reduces the usefulness <moggi> IMHO if you need complex formatting use a writer table, if you need complex calculations use calc <jphilipz> being unable to use character styles in formula is a limitation of the file format? <moggi> of how spreadsheet formulas work <moggi> it is not only character styles, you can not use any character formatting in formula results <moggi> you can format a whole cell but not single characters <jphilipz> yep that would just limited character styles to just general formatted texts <moggi> in general ODF and OOXML are normally our smallest problems, we can extend both formats <moggi> of course we try to avoid extending the format and limit it to useful requests
Adding character styles would be a matter of adding them to the EditEngine (which is used to edit cells and for display as soon as in-cell formatting is involved). Which then could also be made available in Draw and Impress. I don't see a problem with ODF, in fact when writing ODF we create adhoc automatic styles for in-cell formatting. OOXML could work similar, but I don't know. However, making EditEngine support character styles on selections would be quite an effort. Moggi's comments about formulas of course hold, in-cell formatting, be it styles or hard formatting, will not be supported.
Thanks for your comments about this issue. I don't see a problem that styles can't be used in formula. That's already not possible with direct formatting. Character styles should not be more powerful than what's possible with direct character formatting today as far as I can see. Is there a use case to use formatting inside of formulae? The question for character styles in Calc is not because of the need of complex formatting but because of maintainability of the formatting of large bulk of data. That's not doable with Writer tables.
From a short irc conversation with moggi: <Me> But the point nobody answered: in XML level, character styles work now in text:span elements with styles that are defined like direct formatted character styles in Writer. All what needed is to use this existing feature and 1) make it visible to the user in the styles and formatting sidebar deck and 2) make it possible to reuse a defined character style name (T24 or whatever) in other cells. <moggi> ThomasLeno: in ODF that is not a problem, there is not much difference between hard formatting and styles, but implementing all the hard logic in calc is nearly impossible <moggi> that does not even go into the interop problems <Me> Ok, so it's an interop and in LibO an implementation problem. <moggi> yes
Bug 49343 is also effected by having no character styles in Calc cells.
Character styles in Calc are critically needed in my case. I am maintaining a large spreadsheet where I need to have within multiple cells parts of text which need to be formatted with a different format than the cell format (or the rest of the text in the cell). It is often that I need to change the format of all those text parts within those multiple cells, which is really a nightmare without character styles in Calc. I have done it multiple times and I need to do it again now, so I’ve started a new enhancement request post, but have seen that there already exists one. Please, if feasible, add that feature asap. Many thanks!