Jump to content


Photo

Some suggestions


  • Please log in to reply
9 replies to this topic

#1 David Novo

David Novo
  • Members
  • 4 posts

Posted 10 June 2008 - 06:57 PM

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)

#2 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,212 posts
  • Gender:Male

Posted 10 June 2008 - 07:28 PM

Hello David,

Please read for answers:

1) This will be finished and error will be added inside cell.

2) I will see what I ma do. Adding new formulas is quite easy at the moment. I will post tutorial about it.

3) I am not sure about this question, can you please tell me more details.

4) This may be done in future, but it also require other work.

Best regards
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

#3 David Novo

David Novo
  • Members
  • 4 posts

Posted 11 June 2008 - 02:58 AM

Hello,

I am sure you are aware of Actions in Delphi, but if you are not, please let me know.

You can also create your own specific actions. If you create some actions that are specific for the NextSheet, that would be very useful. For instance

TNextSheetBoldSelectionAction
TNextSheetClearSelectionAction
TNextSheetChangeFontOnSelectionAction

Then, if people want to make editors, they just create the UI and hook up your actions to their UI and they are done.


QUOTE (Boki (Berg) @ Jun 10 2008, 11:28 AM) <{POST_SNAPBACK}>
3) I am not sure about this question, can you please tell me more details.
Best regards


#4 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,212 posts
  • Gender:Male

Posted 11 June 2008 - 11:34 AM

Hello David,

I will see what I may do, but as far I can see Actions are rarely used last years.

Best regards
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

#5 David Novo

David Novo
  • Members
  • 4 posts

Posted 12 June 2008 - 09:28 AM

Hello,

We use them all the time... But we can always make our own for what we need, so no big deal for us.

QUOTE (Boki (Berg) @ Jun 11 2008, 03:34 AM) <{POST_SNAPBACK}>
I will see what I may do, but as far I can see Actions are rarely used last years.


#6 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,212 posts
  • Gender:Male

Posted 12 June 2008 - 11:16 AM

Hello David,

I will see about adding them.

Best regards
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

#7 Atheling

Atheling
  • Members
  • 3 posts

Posted 22 February 2009 - 12:36 AM

QUOTE (Boki (Berg) @ Jun 10 2008, 06:28 PM) <{POST_SNAPBACK}>
Hello David,

Please read for answers:

1) This will be finished and error will be added inside cell.

2) I will see what I ma do. Adding new formulas is quite easy at the moment. I will post tutorial about it.

3) I am not sure about this question, can you please tell me more details.

4) This may be done in future, but it also require other work.

Best regards


Dear Boki

Which version of NxSheet was used for the compiled Demo? The circular reference problem (#1) exists in the demo.

Also, I was wondering whether it was possible to have the same behaviour as in Excel when typing a formula, i.e. when you click in an another cell, the cell reference, e.g. F4, is added to the formula.

Best wishes

Atheling

#8 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,212 posts
  • Gender:Male

Posted 23 February 2009 - 12:14 AM

Dear Atheling,

Circular-reference detection problem is not yet added.

I will need to think about it. If is not hard to add it (because I am working on some issues), it will added.

Best regads
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

#9 Atheling

Atheling
  • Members
  • 3 posts

Posted 27 February 2009 - 11:17 PM

QUOTE (Boki (Berg) @ Feb 22 2009, 11:14 PM) <{POST_SNAPBACK}>
Dear Atheling,

Circular-reference detection problem is not yet added.

I will need to think about it. If is not hard to add it (because I am working on some issues), it will added.

Best regads


Dear Boki

Thank you very much for your reply. I look forward to the next version. Other useful features would be:

1) Highlighting the row and column for the cell or range that is currently selected.

2) Once you are typing a formula, allow selection of cells in the formula by clicking other cells in the grid.

Now that the Profgrid component's development has been discontinued without support for D2009, I think you have an excellent opportunity to make Nextsheet the best spreadsheet component in town.

Best wishes

Atheling

#10 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,212 posts
  • Gender:Male

Posted 28 February 2009 - 04:00 PM

Hello Atheling,

I will now work on column/row highlighting.

Best regards
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users