Forum Discussion

Allen's avatar
Allen
Icon for Community Manager rankCommunity Manager
May 27, 2020

Using formula highlighting

Hi all,   The I have been watching the exchanges in the excel boards and noticed no one ever seems to use the formula syntax highlighting we enabled a month ago.   I was wondering if there wa...
excel
Formulas and Functions
Allen's avatar
Allen
Icon for Community Manager rankCommunity Manager
May 29, 2020

SergeiBaklan 

 

Ok so there maybe something about discoverability, interesting. Thanks Sergei.

 

I will see what we can do about the font size.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 29, 2020

Allen , bit more about font size - it more or less normal (from my point of view) while replying, after reply is submitted code font becomes bigger. At least for Excel formulas language.

  • Allen's avatar
    Allen
    Icon for Community Manager rankCommunity Manager
    May 29, 2020

    SergeiBaklan 

    Interesting I just tested it, its the same size and weight as the text in a normal paragraph.

     

    Do you feel it should be smaller?

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 29, 2020

      Allen 

      Let me test here

      Excel:

      =TRIM(IFERROR(
     RIGHT(
       $H$3:INDEX($H$3:$H$100,COUNTA($H$3:$H$100)),
       LEN($H$3:INDEX($H$3:$H$100,COUNTA($H$3:$H$100))) -
       FIND("-",$H$3:INDEX($H$3:$H$100,COUNTA($H$3:$H$100)))),
 $H$3:INDEX($H$3:$H$100,COUNTA($H$3:$H$100))))

      Java

      =TRIM(IFERROR(
     RIGHT(
       $H$3:INDEX($H$3:$H$100,COUNTA($H$3:$H$100)),
       LEN($H$3:INDEX($H$3:$H$100,COUNTA($H$3:$H$100))) -
       FIND("-",$H$3:INDEX($H$3:$H$100,COUNTA($H$3:$H$100)))),
 $H$3:INDEX($H$3:$H$100,COUNTA($H$3:$H$100))))

       

      On the right that's in editor window, on the left Preview (or published) - IMHO, they are in different font size

       

       

Resources