Issue 98939

Summary: Allow formulas to use multiple style() on cell results
Product: Calc Reporter: risner <risner>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOo 3.0.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.0.0
Developer Difficulty: ---
Attachments:
Description Flags
Styles and Formatting window none

Description risner 2009-02-06 00:11:26 UTC 
Define Bold in Format->Styles and Formatting as a bold font.

Leave Default as a regular font.

Place this in a cell:
="Hello"&T(STYLE("Default"))&"There"&T(STYLE("Bold"))

Notice the whole text ("HelloThere") is bold and not just "There" as expected.

There is another Bug Report that covered Styles in general and a user explicitly
requested this type of behaviour, namely bug id # 51663.  The comment posted by
claudiadzm on Thu Dec 13 06:17:27 +0000 2007 should have been in a separate bug
id, so I made this one.
Comment 1 Edwin Sharp 2013-04-05 13:38:17 UTC 
Created attachment 80499 [details]
Styles and Formatting window

"Bold" is not a style name - see attachment.
And even if it was, you already defined bold as default beforehand...
But changing bold to Heading in your equation affects both words which is wrong.
Comment 2 Edwin Sharp 2013-04-05 13:43:37 UTC 
Sorry for misunderstanding - thought you meant assign bold to default...