Dinesh Varadharajan wrote:
I am developing a addon with few custom formualas. I need to access the
spreadsheet document from inside the component. How to I get the
reference of the current document.
Example,
I am creating a sum3d implementation and if the user gives sum3d(A1), I
need to get value of A1 from all the sheets and perform the addition.
How do I get the reference of spreadsheet model from within the component.
If an add-in function has a parameter of type "XPropertySet", it will
receive an XPropertySet interface to the formula's document in that
parameter, so you can queryInterface for other interfaces of the document.
But if you read values from the document, there will be no dependency
from those values to your formula, so if the values are changed, your
formula won't be recalculated. Generally it's better to pass all values
as function parameters, so the dependencies work.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
