Calculation formula/values collection access

[Michel T Dallaire]

Hi,

inside the CalcQuick, it would be a good feature to add access to the formula collection so we can iterate through out all the formulas and values we added. We can even be able to clear them all or manipulate them with other kind of code.

I can access values but I cannot iterate trhough them. Or maybe it''s just me to new for the feature! ;-)

[Administrator]

We purposely hid access to the ''good stuff'' in CalcQuick to keep things simple.

But if you derive the class, there are protected members that you would then have access to, including this.Engine.FormulaInfoTable, this.RowsToKeyMap and this.KeyToRowMap which would allow you access to almost everything.

[Michel T Dallaire]

Tried it also.

it works! :-)

thank you.