Objective Grid: Adding custom worksheet functions

Article ID: 331
Last updated: 07 Jun, 2018
Article ID: 331
Last updated: 07 Jun, 2018
Revision: 3
Views: 1737
Posted: 24 Jan, 2001
by Meltreger B.
Updated: 07 Jun, 2018
by Meltreger B.

Problem


How can I add custom worksheet functions?


Cause



Action


If you want to add your custom functions, you should subclass CGXWorksheetFunctions (or CGXDefaultWorksheetFunctions) and override LookupFunction(). See the class reference for the class CGXWorksheetFunctions for more details.

Please note that implementing your own custom worksheet functions is only recommended for advanced users. When implementing your own custom worksheet functions you will have to deal directly with the formula engine code. There is no documentation for the formula engine internal functions. Take a look at the existing worksheet functions (e.g. in srcenginefnmath.cpp) for examples how to implement worksheet functions.

This article was:   Helpful | Not helpful
Report an issue
Article ID: 331
Last updated: 07 Jun, 2018
Revision: 3
Views: 1737
Posted: 24 Jan, 2001 by Meltreger B.
Updated: 07 Jun, 2018 by Meltreger B.

Others in this category