Apache OpenOffice (AOO) Bugzilla – Issue 51663
Character styles for spreadsheet cells
Last modified: 2013-08-07 15:12:27 UTC
Writer stylist allows us to manage paragraph, character, frame, page and numbering styles. Calc, the spreadsheet component, only allows us to manage cell and page styles. The formatting subcomponent of the spreadsheet component should allow us to manage character styles. It would allow us to apply character styles to the text of a cell. Actually the only solution to stylize the text is to use the object bar features : bold, italic, underline... I can understand why we can't manage paragraph or page styles, but character styles should be available. We can bold or italic a text so there should be strong and emphasize character styles, like in Writer. Also note that copying a formatted text from a text document and pastying it into a spreadsheet cell conserves the styles but it doesn't create a "hidden" character style, as it's not supported by Calc. The character style is transformed into a "bunch" of styles, it only mimics the word processor character styles. Note : I think such a feature could be quickly implemented by reusing the character styles features from the word processor stylist. Most character styles should be available in a spreadsheet document like there are in a text document : Default, Emphasis, Strong Emphasis... These are the most common styles writers use I guess.
You might also be interested by the « Character styles for spreadsheet cells » topic technical notes : <http://www.oooforum.org/forum/viewtopic.phtml?t=15341>. We mention what XML if generated when copying from Writer and pastying to Calc for example.
I'd like to agree. If an "integrated suite" is to mean anything at all, then the same facilities must exist through all the components. In fact, I am really surprised about this.
one for the requirements team
I'm not sure, it that's the right place, but I'd like to add the wish: allow charater-styles within functions, so that things like that would be possible: =CONCATENATE(A1&T(STYLE("red"));A2&(T(STYLE("black"))) greetings, Claudia
any progress?