Issue 98939 - Allow formulas to use multiple style() on cell results
Summary: Allow formulas to use multiple style() on cell results
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.0.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-02-06 00:11 UTC by risner
Modified: 2013-04-05 13:43 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.0
Developer Difficulty: ---

Attachments
Styles and Formatting window (13.67 KB, image/jpeg)
2013-04-05 13:38 UTC, Edwin Sharp 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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...