Determine if range contains not supported functions

Determine if range contains not supported functions

Posted by: yyoshimura on 27 July 2021, 2:19 pm EST

• 

  yyoshimura

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 July 2021, 2:19 pm EST

  Hi,

  We have got a workbook which contains some functions that are not supported by the library(JIS function, etc). If we get value of the range that contains the function, we found that the value is type of CalcError enum and with value ‘Name’. Is there any way to check whether a function is supported by library or not WITHOUT getting the range value and checking the value type?

  Thanks

  Regards

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 27 July 2021, 2:22 pm EST

  Correct the question here.

  Is there any way to know if a range contains any not supported functions or not WITHOUT getting the range value and checking the value type one by one?

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 27 July 2021, 5:44 pm EST

  Hello,

  We are discussing this issue with the developers and will let you know the updates soon.

  [Internal Tracking Id: DOCXLS-4604]
  
  Regards,
  
  Prabhat Sharma.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 28 July 2021, 8:38 pm EST

  Hello,

  As per the developers, we will now support the JIS function from v4.2 onwards.
  
  Also, there’s not a direct way to find all not supported formulas.
  
  While you can still use IRange.Find() to search all ‘#NAME’ cells.

  Regards,
  
  Prabhat Sharma.

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 9 August 2021, 10:53 am EST

  Thank you for your information. It is good to see new functions to be supported.