Invalid formula using custom names columns

Invalid formula using custom names columns

Posted by: grazielleconceicao on 7 June 2022, 12:00 pm EST

• 

  grazielleconceicao

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 June 2022, 12:00 pm EST - Updated 3 October 2022, 9:14 am EST

  I’m using columns names custom and trying using formula in my sheet, but get error “Invalid formula”. My project this ReactJS.

  How make to use formula with columns name custom?

  Below is the image of the column names:
  
  

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 8 June 2022, 3:28 am EST

  Hi,

  This is by design even if we change the header text the Column name is not changed it is still A,B,C etc. if you want to refer to the particular column range using the custom name you need to register that name in NameManager. We are sorry for the inconvenience.

  API:
  
  customName: https://www.grapecity.com/spreadjs/demos/features/calculation/add-custom-name#demo_source_name

  regards,
  
  Avinash