Jump to content


Photo

Formula problem


  • Please log in to reply
8 replies to this topic

#1 rajesh

rajesh
  • Members
  • 1 posts

Posted 08 January 2010 - 02:05 PM

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

#2 Boki (Berg)

Boki (Berg)

    Boki (Berg)

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

Posted 08 January 2010 - 03:40 PM

Hello Rajesh,

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.

#3 Boki (Berg)

Boki (Berg)

    Boki (Berg)

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

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
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.

#4 AndrewC

AndrewC
  • Members
  • 3 posts

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


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 Boki (Berg)

Boki (Berg)

    Boki (Berg)

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

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
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.

#6 AndrewC

AndrewC
  • Members
  • 3 posts

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. 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 Boki (Berg)

Boki (Berg)

    Boki (Berg)

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

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
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.

#8 AndrewC

AndrewC
  • Members
  • 3 posts

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 Boki (Berg)

Boki (Berg)

    Boki (Berg)

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

Posted 22 January 2010 - 09:14 AM

Hello Andrew,

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.




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users