Hi , all there is major problem in formula for fetching values after 9 th row
Suppose in A10 = 10 .
if I use formula in any cell =a10 then result = 0
it is working upto 9 th row . how I can solve that problem . so that it can fetch value of any cell number inserted
Formula problem
Started by rajesh, Jan 08 2010 02:05 PM
8 replies to this topic
#1
Posted 08 January 2010 - 02:05 PM
#2
Posted 08 January 2010 - 03:40 PM
Hello Rajesh,
This problem is fixed and this fix will be in next release.
Best regards
This problem is fixed and this fix will be in next release.
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.
--
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
Posted 09 January 2010 - 02:11 AM
Hello,
You may download latest update from Members Section wit this fix included.
I hope that this helps.
Best regards
You may download latest update from Members Section wit this fix included.
I hope that this helps.
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.
--
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.
#4
Posted 19 January 2010 - 06:29 AM
QUOTE (Boki (Berg) @ Jan 9 2010, 12:11 PM) <{POST_SNAPBACK}>
Hello,
You may download latest update from Members Section wit this fix included.
I hope that this helps.
Best regards
You may download latest update from Members Section wit this fix included.
I hope that this helps.
Best regards
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.
#5
Posted 19 January 2010 - 02:37 PM
Hello,
1) I will see about what can I do about this.
2) I haven't put any ShowMessage. Try to open NxSheet.pas and search for ShowMessage. Please tell me do you find some. Thank you.
Best regards
1) I will see about what can I do about this.
2) I haven't put any ShowMessage. Try to open NxSheet.pas and search for ShowMessage. Please tell me do you find some. Thank you.
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.
--
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.
#6
Posted 20 January 2010 - 04:44 AM
QUOTE (Boki (Berg) @ Jan 20 2010, 12:37 AM) <{POST_SNAPBACK}>
Hello,
1) I will see about what can I do about this.
2) I haven't put any ShowMessage. Try to open NxSheet.pas and search for ShowMessage. Please tell me do you find some. Thank you.
Best regards
1) I will see about what can I do about this.
2) I haven't put any ShowMessage. Try to open NxSheet.pas and search for ShowMessage. Please tell me do you find some. Thank you.
Best regards
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.
#7
Posted 20 January 2010 - 09:02 AM
Hello Andrew,
I do not receive any ShowMessage dialog. I only suggest that you open NxSheet.pas file and do one search for ShowMessage string. Please tell me do you find some.
While I have testeed, I have put this control dialogs, but after then I have remove them.
Best regards
I do not receive any ShowMessage dialog. I only suggest that you open NxSheet.pas file and do one search for ShowMessage string. Please tell me do you find some.
While I have testeed, I have put this control dialogs, but after then I have remove 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.
--
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.
#8
Posted 20 January 2010 - 03:46 PM
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
#9
Posted 22 January 2010 - 09:14 AM
Hello Andrew,
I will work to fix this remain "empty cell" problem.
Best regards
I will work to fix this remain "empty cell" problem.
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.
--
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