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+unsubscr...@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