Determine if range contains not supported functions

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

  • Posted 27 July 2021, 2:19 pm EST


    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?


  • Replied 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?
  • Replied 27 July 2021, 5:44 pm EST


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

    [Internal Tracking Id: DOCXLS-4604]
    Prabhat Sharma.
  • Marked as Answer

    Replied 28 July 2021, 8:38 pm EST


    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.

    Prabhat Sharma.
  • Replied 9 August 2021, 10:53 am EST

    Thank you for your information. It is good to see new functions to be supported.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels