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.