INDIRECT function with custom formatter

INDIRECT function with custom formatter

Posted by: dana.eliyahu on 5 June 2023, 11:58 am EST

• 

  dana.eliyahu

  • Post Options:
  • Link
    Copy

  Posted 5 June 2023, 11:58 am EST - Updated 5 June 2023, 12:03 pm EST

  Hi, We are having an issue with using the indirect function when the referenced cell has a custom formatter.

  We have a custom formatter class that extends FormatterBase.
  
  The following cells marked in yellow have the custom formatter and the cell D2 contains the indirect function.
  
  

  After re-evaluation, the indirect cell returns a calc error:
  
  

  this is happening because we are getting an exception at your side:
  
  

  t in the image is representing the custom formatter class that extends the FormatterBase, which is an object and not a string so, when SpreadJS trying to use string functions such as replace/indexOf etc… it throws an exception.

  When trying to do the same thing with different functions than indirect it works.

  Can we have some guidance how to address this issue?

  Thanks.

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 6 June 2023, 2:42 am EST

  Hi Dana,

  I created a CustomFormatter that extends the FormatterBase Class and then recalculates the sheet using the recalcAll() method, however, I was unable to replicate the issue at my end.

  You could refer to the following sample that I have used for testing: https://jscodemine.grapecity.com/share/cIqJCOdGEEWwpLko_Ap8PA/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fpackage.json"%2C"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  Could you kindly share us a minimal working sample replicating the issue? Also, mention the steps to follow. You may also fork the above sample, make changes to it and share it with us replicating the issue.

  Regards,

  Ankit