AndrewC

I noticed that I had to recompile the NextSuite library as the BPL's I had were dated 16/12/2009.

This was the cause of my problems. I wrongly assumed the Install program updated the libraries.

The sheet component is now usable for me now. Thanks for the help.

The only small issue remaining is the case where a formula does not calculate if one of the cells is empty. Currently I have to put a 0 (zero) in the cell for the formula to work correctly.

Andrew

1. Thanks.

2. It comes up as a simple Message type box with my application name as the Title and the strings listed above as the message and just an OK button.

I know it is not my code doing this. I don't have the text CELL in my code anywhere and CELL("D3")+CELL("D4") and CELL("A7")+AA6 is more likely your debug code.

Do you use CELL("D3") type references in your code anywhere ? This message seems comes up when I populate me grid. I gets hundreds of the messages. Then it also occurs
when I edit a cell manually and press enter and then I get 10 - 20 more messages. Each time I modify a cell I have to close 20 or so message boxes.

My code only populates the cells with values and formulas. I have no event handlers in place to process cell changes or updates. I will have to see what the Debugger says when I get back to my Dev PC.

I have downloaded the new version and the formulas are now working much better than before.

I have two small problems.

1. I have a formula A4 = A1+A2=A3. If A1= 1 and A2 = 2 and A3 is an empty value then the formula does not calculate. If I put a 0 (zero) in A3 then the formula calculates.

2. I am getting hundreds of ShowMessage message boxes with CELL("D3")+CELL("D4") and CELL("A7")+AA6 and AB&+AB6 which is very annoying and makes my sheet unusable in my app.

Other than that it looks good. The formulas show with a small triangle and are updated automatically when I change a cell. Not far to go to being very usabale for me.