Re: [libreoffice-users] LO Calc - style in formulae

Le jeudi 14 avril 2016 à 12:18 -0400, Henry Sikkema a écrit :
> I am wondering if it is possible in LO Calc to incorporate styles
> into
> formula:
>
> =if(*A1 is bold*, do this if true, do this if false)
>
> *Henry*
Hello,
I do not think you can get the formatting information about a cell.
However, if the cell you want to look at has been set to a style which
identifies its formatting via a formula, you can use the FORMULA()
function to extract that information. For instance:
Cell A1 contains 25
Cell A2 contains =A1*1.8+32+STYLE("STYLE_BOLD")
You can create a formula like:
=IF(NOT(ISERROR(FIND("STYLE_BOLD";FORMULA(A2))));"Bold";"Not bold")
to find out if the cell has been formatted as bold or not. Of course,
you will need to create and assign the styles to the various cells, but
you should be able achieve something with this method.
I hope this helps.
Rémy Gauthier.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted