Functions referring to a local range name calculating as #NAME? errors

Functions referring to a local range name calculating as #NAME? errors

Posted by: dean.kinnear on 28 October 2025, 11:07 am EST

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy

  Posted 28 October 2025, 11:07 am EST - Updated 28 October 2025, 11:16 am EST

  SORTTEST.zip

  

  1329×764 117 KB

  It appears that VALUETOTEXT is not supported. Please add.

  Thanks,
  
  Dean

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 29 October 2025, 3:35 am EST

  Hi,

  Currently, SpreadJS does not support the VALUETOTEXT function. I’ve escalated this to the development team to check if it can be supported or if there’s any possible workaround. The internal tracking ID for this request is SJS-32043. I’ll update you as soon as I receive any information.

  Regards,
  
  Priyam

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 30 October 2025, 8:08 am EST

  Hi,

  The dev team mentioned that the VALUETOTEXT function is currently in the product backlog, and there’s no ETA for its implementation. The internal tracking ID is SJS-32052.

  As a workaround, you can create a custom function to achieve the same result.

  We’ve attached a demo sample and a GIF showing how you can load an Excel file containing the VALUETOTEXT function.

  Sample, gif and excel file: Sample.zip

  You can also refer to the following demo to learn more about creating custom functions: https://developer.mescius.com/spreadjs/demos/features/calculation/custom-functions/purejs

  Regards,
  
  Priyam