TAdvSpreadGrid

Being designed as a TAdvStringGrid addon, TAdvSpreadGrid comprises a set of VCL components for developers building applications for both 32- and 64-bit architectures.

To be more specific as to the functionality it brings about, it should be mentioned that it ensures support for spreadsheet function calculations within the aforementioned TAdvStringGrid.

The addon thus introduces an approachable interface for editing formulas and allows you to import and export native XLS files. Aside from that, support for auto recalculation is provided at both single-cell and full level.

Needless to say, it is able to display both your formula and the corresponding results, and saving them should raise no difficulty either. What’s more, turning to formula-aware copy and paste should translate to an improved workflow, and referencing cells from other TAdvSpreadGrid components is possible as well.

Hints can pop up when editing formulas, and you can select between one of the available name modes for your cells, namely A1 and RxCy style.

Developers might also be interested in the fact that enhancing the addon’s functionality with custom features is allowed, which means they can make changes even to the math library infrastructure in case the default mathematical functions and scientific constants are not enough.