Bold calculated column

Question

5.30K viewsJanuary 13, 2015

0

Anto Andrijanić2 January 13, 2015 0 Comments

Hello I’v made this formula and it is function good

IF[Befristet von]=””,””,“Befristet von: “&TEXT[Befristet von],”dd.mm.yyyy”))&” “&IF[Befristet bis]=””,””,“Befristet bis: “&TEXT[Befristet bis],”dd.mm.yyyy”))

I want to have BOLD letters this in calculated form

Why this formula is not function?

=IF[Befristet von]=””,””, “<DIV style=’font-weight:bold’>“Befristet von: “</DIV>”&TEXT[Befristet von],”dd.mm.yyyy”))&” “&IF[Befristet bis]=””,””,”Befristet bis: “&TEXT[Befristet bis],”dd.mm.yyyy”))


Thank you!

(Visited 192 times, 1 visits today)

Add a Comment

5 Answers

score 0 · Answer 1 · 2015-01-15T09:35:00+00:00

0

Anto Andrijanić2 Posted January 15, 2015 0 Comments

Thank you very much. Works perfect 🙂

(Visited 1 times, 1 visits today)

Add a Comment

score 0 · Answer 2 · 2015-01-14T11:01:00+00:00

1. Have you set the datatype to Number? Single-line-of-text will NOT output your Formula as HTML

2. When you inspect the HTML that is created you will see the style is formatted wrong because the single quotes you added make your style defintion one string.
Replace the single quotes with 2x a double qoute; this is the SharePoint escape notation to get one double quote in a SharePoint string.
(be carefull with copy pasting code from blogs; they might use the wrong ACSII notation for quote characters; when in doubt replace all quotes in a text-editor)

=IF[Befristet von]="","","<DIV style=""text-align:left;font-weight:bold"">Befristet von: </DIV>" &TEXT[Befristet von],"dd.mm.yyyy")) &" " &IF[Befristet bis]="","","Befristet bis: " &TEXT[Befristet bis],"dd.mm.yyyy"))

3. Because the datatype is number the DIV is right aligned; so I added the text-align:left
you might want to add a min-width as well to prevent wrapping…

4. This works in any View, NOT on the Edit/Display Forms, where the bare HTML will be shown. You can prevent Calculated Columns to show up on Forms by not adding them to the Lists ContentTypes; or use SharePoint Designer to hide the Calculated Column of a ContentType

(Visited 1 times, 1 visits today)