David Novo

Hello,

Do you have an esitmated timeline of when this will be a completed product?

Hello,

I am really looking forward to this component. I have tried the other spreadsheet components for Delphi and they are all kind of crappy.

I do have a few suggestions that I hope would be included:

1. The first thing I tried was to make a formula with a circular reference. This HAS to work for a spreadsheet component. in A1 I typed "=B1" and in B1 I typed "=A1". There was no error. If you need help devising an algorithm for this, please let me know as we have experience with it. Entering a formula with a circular reference should generate an error, just like excel.

2. Allow the users to plug in/define their own forumulas. I imagine something like

TNextSheetFomula = function (aCellList:TCellList): string

NextSheet.RegisterNewFormula('Kurtosis',kurtosisFunction)

The cellList will be a list of cells that are typed in the formula. So if the user types "=Kurtosis(a1..b2)" you would expand that into all the selected cells and pass it to the function. Then we would have to retrieve the values.

(of course, it can be made much more elegant to handle different data types etc, but that is the idea). You could then even register your functions as such and we all use the same infrastructure.

3. I would suggest creating a series of TAction descendents designed to work with the grid for all the basic functionality (font, cell formatting etc). TRichview does that quite nicely so you can build a basic editor with basically zero work.

4: optional: ability to reference other sheets. If I type in the forumua

=Sum(sheet2:A1..A100) then you call an OnNeedExternalSheet method passing me the text "sheet 2". Its up to me to find sheet 2 and return it to you. That way I can easily make multi-sheet spreadsheets very flexibly. (note, the syntax to the left may not be the exact excel syntax)