Accessing cell properties from custom function

Accessing cell properties from custom function

Posted by: joni.dewinter on 28 July 2021, 10:21 am EST

• 

  joni.dewinter

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 July 2021, 10:21 am EST

  Our company has a use case where the display value (= text) of a dropdown cell should be accessible from a custom function.
  
  From the custom function, we can accept cell references (CalcReference) and retrieve the cell position and cell value.
  
  Is there any way to access more information about the cell reference?
  
  Ideally we should be able to access the display value and cell type.
  
  In fact all this information would be accessible through an FpSpread-instance, but we cannot find any way to that from a CalcReference.
  
  Thanks in advance.

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 30 July 2021, 3:37 am EST

  Hi Joni,

  We are sorry but we are unable to achieve the required functionality using the current public API hence we have escalated this is to the dev team. We will update you regarding this as get any information from the team. The internal ID for this issue will be SPNET-19200.

  Regards
  
  Avinash

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 11 October 2021, 11:26 pm EST

  Hi Joni,

  The Devs informed us that spread.Net doesn’t support that functionality. In custom function, You could only is able to get cell values. We are sorry for the inconvience.

  Regards
  
  Avinash

• 

  joni.dewinter

  • Post Options:
  • Link
    Copy

  Posted 12 October 2021, 2:38 am EST

  Hello Avinash

  No problem, we understand this would be quite a change in Spread.NET.
  
  For our use case, we work around this by providing static (session) access to the FpSpread-instance.

  Kind regards
  
  Joni