Accessing cell properties from custom function

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

  • Posted 28 July 2021, 1: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.
  • Replied 29 July 2021, 6:37 pm 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
  • Replied 11 October 2021, 2: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
  • Marked as Answer

    Replied 11 October 2021, 5:38 pm 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
Need extra support?

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

Learn More

Forum Channels