search

google-code-export / zkspreadsheet

Automatically exported from code.google.com/p/zkspreadsheet
0 stars 1 forks source link

Formula cells not always updated #290

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Create new spreadsheet on ZK Spreadsheet 2.0.0 Live Demo.
2. Insert the following formula in cell G2 
=IF(OR(ISBLANK(C2),ISBLANK(F2)),"Check 
Input",IF(AND(NOT(ISBLANK(C2)),NOT(ISBLANK(D2))),F2/D2,F2/C2))

3. Insert numerical values in cell C2, F2 and D2
4. Change the numerical values in cell C2, F2 and D2

What is the expected output? What do you see instead?
Cell G2 containing the formula should always be updated when any of the 
referenced cells C2, F2 or D2 is updated
Cell G2 is only updated sometimes.

What version of the product are you using? On what operating system?
ZK Spreadsheet 2.0.0 Live Demo, Google Chrome 8.0.552.237,
IE 7.0.6001.1800, Win Vista

Please provide any additional information below.

Original issue reported on code.google.com by ojer...@gmail.com on 21 Jan 2011 at 2:53

GoogleCodeExporter commented 9 years ago 
Change D2 does not trigger G2 to change

Original comment by chenhe...@gmail.com on 22 Mar 2011 at 11:23

GoogleCodeExporter commented 9 years ago 
Fixed since Mar. 25, 2011.

Original comment by chenhe...@gmail.com on 25 Mar 2011 at 2:46