Issue 51663

Summary: Character styles for spreadsheet cells
Product: Calc Reporter: goa103 <goa>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1.4   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---

Description goa103 2005-07-07 10:14:57 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.
Comment 1 goa103 2005-07-07 10:22:42 UTC
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.
Comment 2 bobharvey 2005-07-07 14:31:00 UTC
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.
Comment 3 frank 2005-07-18 14:19:40 UTC
one for the requirements team
Comment 4 claudiadzm 2007-12-13 06:17:27 UTC
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
Comment 5 bobharvey 2010-08-01 15:12:10 UTC
any progress?