FlexSheet Formula Custom Column Key

FlexSheet Formula Custom Column Key

Posted by: oskarputraa on 16 September 2019, 5:35 am EST

• 

  oskarputraa

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 16 September 2019, 5:35 am EST - Updated 3 October 2022, 7:24 pm EST

  Hi,

  I was trying to get value from other cell using formula function. When I use standard column name (‘E’,‘F’,‘G’, etc) it return correct value, but when I use custom header name (‘AA’), it return wrong value.

  I post the sample below
  
  

  Could you help me with that ? Thanks

  Oskar Putra

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 17 September 2019, 1:41 am EST

  Hi Oskar,

  We are sorry but this behavior is not possible because we are just changing the innerHTML of the column Headers cells. This does not affect the actual column headers and you will still need to use the original alphabets in the formulas.

  Regards,
  
  Ashwin