Hi team,
there are problems reading values of cell with formulas that refer to other cells with formulas: some values after calculateFormula don’t assume a correct value but a previous value, maybe the value calculated after the file is saved, seems it not refresh.
I attach a project with the file Excel used to do the calculation, putting a break point to the line 603 is possible to verify that
m_currentSheet.calculateFormula("=D348*1",calcOpt);
is different by
m_currentSheet.calculateFormula("=D309-D322+C348-C669",calcOpt);
The correct value is the sencond result.
Best regards.
Hi,
Thanks for your posting and using Aspose.Cells.
Please provide us the simplest code. Remove all the extra and unnecessary code relating to your business logic which could replicate your current issue easily.
Please also download and try the latest version: Aspose.Cells for Java v16.10.2 and see if it makes any difference in resolving this issue.
We have tried to open your xls file in Microsoft Excel 2013 and found, it is corrupt. I have attached two screenshots for your reference. Please note, if you will load corrupt xls file, Aspose.Cells will yield unpredictable and unexpected results. So it is not an issue of Aspose.Cells. You should use intact file. Thanks for your understanding and have a good day.
Hi,
I have semplified the code removing all extra codes.
The problem is at rows 602 and 603 of the class Macro_Rating_RE: the two lines should return the same values after calculateFormula, but the first value of row 602 if the value saved in the file XLS while the value of line 603 is the correct one after setting of the previous lines of code.
I am using 16.10.2 version.
Best regards
Hi,
Thanks for your posting and using Aspose.Cells.
Are you talking about these lines? Because at line 602 or 603, I found these lines.
m_book.calculateFormula(calcOpt); // NON PRESENTE IN MACRO
//m_book.save(“c:/temp/out4.xls”);
m_currentSheet.calculateFormula("=D348*1",calcOpt);
m_currentSheet.getCells().get(347,3).getFloatValue();
m_currentSheet.calculateFormula(m_currentSheet.getCells().get(347,3).getFormula(),calcOpt);
However, your code is still unusable and complicated. I need a simpler code just like this code. Please check its source excel file and the console output for your reference. Please provide a similar simple code so that we could easily find the calculation error in your workbook or worksheet.
Java
Workbook wb = new Workbook(dirPath + “sample.xlsx”);
Worksheet ws = wb.getWorksheets().get(0);
Cell a1 = ws.getCells().get(“A1”);
Cell b1 = ws.getCells().get(“B1”);
a1.putValue(25);
System.out.println("Value of B1 before Calculation: " + b1.getStringValue());
//Perform calculation
wb.calculateFormula();
System.out.println("Value of B1 after Calculation: " + b1.getStringValue());
Console Output
Value of B1 before Calculation: 100
Value of B1 after Calculation: 125
Hi,
I removed not useful code to the previous project but I cannot semplify more because is necessary to set to 0 many areas of the workbook Xls.
I attach new release of the project, note that the problems is that value1 and value2 in the function Simulazione() are different,
double value1 = m_currentSheet.getCells().get(347,3).getFloatValue();
double value2 = (double) m_currentSheet.calculateFormula(m_currentSheet.getCells().get(347,3).getFormula(),calcOpt);
Best regards
Hi,
Thanks for your posting and using Aspose.Cells.
I tried to run your files in the Eclipse project but there are some compilation errors. I have attached the Eclipse project for your reference. Please download it and remove the compilation errors and re-submit it so that we could get some runnable project.
Please also see the attached screenshots showing the error inside your code which must be fixed in order to run it and replicate the error. Thanks for your patience and cooperation in this regard. Have a good day.
Hi,
sorry, I removed to many lines of code.
In the attached file I have modified only the Macro_Rating_RE.java class, now is correct.
Best regards
Hi,
Thanks for your posting and using Aspose.Cells.
I am now able to run your project files and found that it generates console output and does not save any output excel file anywhere. I am not able to understand the console output it is generating.
Will you please elaborate what the console output means? Is it correct or has any error? And if it has errors, where are the errors and how can we verify it via Microsoft Excel. Thanks for your patience and cooperation. Have a good day.
Console Output
Aspose.Cells for Java v16.10.3
Clear variablesSetRangeDouble:Waterfall 2 10 0.0
SetRangeDouble:Waterfall 2 308 0.0
SetRangeDouble:Waterfall 2 430 0.0
SetRangeDouble:Waterfall 2 11 0.0
SetRangeDouble:Waterfall 2 309 0.0
SetRangeDouble:Waterfall 2 431 0.0
SetRangeDouble:Waterfall 2 12 0.0
SetRangeDouble:Waterfall 2 310 0.0
SetRangeDouble:Waterfall 2 432 0.0
SetRangeDouble:Waterfall 2 13 0.0
SetRangeDouble:Waterfall 2 311 0.0
SetRangeDouble:Waterfall 2 433 0.0
SetRangeDouble:Waterfall 2 14 0.0
SetRangeDouble:Waterfall 2 312 0.0
SetRangeDouble:Waterfall 2 434 0.0
SetRangeDouble:Waterfall 2 15 0.0
SetRangeDouble:Waterfall 2 313 0.0
SetRangeDouble:Waterfall 2 435 0.0
SetRangeDouble:Waterfall 2 16 0.0
SetRangeDouble:Waterfall 2 314 0.0
SetRangeDouble:Waterfall 2 436 0.0
SetRangeDouble:Waterfall 2 17 0.0
SetRangeDouble:Waterfall 2 315 0.0
SetRangeDouble:Waterfall 2 437 0.0
SetRangeDouble:Waterfall 2 18 0.0
SetRangeDouble:Waterfall 2 316 0.0
SetRangeDouble:Waterfall 2 438 0.0
SetRangeDouble:Waterfall 2 19 0.0
SetRangeDouble:Waterfall 2 317 0.0
SetRangeDouble:Waterfall 2 439 0.0
SetRangeDouble:Waterfall 2 527 0.0
SetRangeDouble:Waterfall 2 535 0.0
SetRangeDouble:Waterfall 2 543 0.0
SetRangeDouble:Waterfall 2 551 0.0
SetRangeDouble:Waterfall 2 559 0.0
SetRangeDouble:Waterfall 2 528 0.0
SetRangeDouble:Waterfall 2 536 0.0
SetRangeDouble:Waterfall 2 544 0.0
SetRangeDouble:Waterfall 2 552 0.0
SetRangeDouble:Waterfall 2 560 0.0
SetRangeDouble:Waterfall 2 529 0.0
SetRangeDouble:Waterfall 2 537 0.0
SetRangeDouble:Waterfall 2 545 0.0
SetRangeDouble:Waterfall 2 553 0.0
SetRangeDouble:Waterfall 2 561 0.0
SetRangeDouble:Waterfall 2 530 0.0
SetRangeDouble:Waterfall 2 538 0.0
SetRangeDouble:Waterfall 2 546 0.0
SetRangeDouble:Waterfall 2 554 0.0
SetRangeDouble:Waterfall 2 562 0.0
SetRangeDouble:Waterfall 2 531 0.0
SetRangeDouble:Waterfall 2 539 0.0
SetRangeDouble:Waterfall 2 547 0.0
SetRangeDouble:Waterfall 2 555 0.0
SetRangeDouble:Waterfall 2 563 0.0
SetRangeDouble:Waterfall 3 10 0.0
SetRangeDouble:Waterfall 3 308 0.0
SetRangeDouble:Waterfall 3 430 0.0
SetRangeDouble:Waterfall 3 11 0.0
SetRangeDouble:Waterfall 3 309 0.0
SetRangeDouble:Waterfall 3 431 0.0
SetRangeDouble:Waterfall 3 12 0.0
SetRangeDouble:Waterfall 3 310 0.0
SetRangeDouble:Waterfall 3 432 0.0
SetRangeDouble:Waterfall 3 13 0.0
SetRangeDouble:Waterfall 3 311 0.0
SetRangeDouble:Waterfall 3 433 0.0
SetRangeDouble:Waterfall 3 14 0.0
SetRangeDouble:Waterfall 3 312 0.0
SetRangeDouble:Waterfall 3 434 0.0
SetRangeDouble:Waterfall 3 15 0.0
SetRangeDouble:Waterfall 3 313 0.0
SetRangeDouble:Waterfall 3 435 0.0
SetRangeDouble:Waterfall 3 16 0.0
SetRangeDouble:Waterfall 3 314 0.0
SetRangeDouble:Waterfall 3 436 0.0
SetRangeDouble:Waterfall 3 17 0.0
SetRangeDouble:Waterfall 3 315 0.0
SetRangeDouble:Waterfall 3 437 0.0
SetRangeDouble:Waterfall 3 18 0.0
SetRangeDouble:Waterfall 3 316 0.0
SetRangeDouble:Waterfall 3 438 0.0
SetRangeDouble:Waterfall 3 19 0.0
SetRangeDouble:Waterfall 3 317 0.0
SetRangeDouble:Waterfall 3 439 0.0
SetRangeDouble:Waterfall 3 527 0.0
SetRangeDouble:Waterfall 3 535 0.0
SetRangeDouble:Waterfall 3 543 0.0
SetRangeDouble:Waterfall 3 551 0.0
SetRangeDouble:Waterfall 3 559 0.0
SetRangeDouble:Waterfall 3 528 0.0
SetRangeDouble:Waterfall 3 536 0.0
SetRangeDouble:Waterfall 3 544 0.0
SetRangeDouble:Waterfall 3 552 0.0
SetRangeDouble:Waterfall 3 560 0.0
SetRangeDouble:Waterfall 3 529 0.0
SetRangeDouble:Waterfall 3 537 0.0
SetRangeDouble:Waterfall 3 545 0.0
SetRangeDouble:Waterfall 3 553 0.0
SetRangeDouble:Waterfall 3 561 0.0
SetRangeDouble:Waterfall 3 530 0.0
SetRangeDouble:Waterfall 3 538 0.0
SetRangeDouble:Waterfall 3 546 0.0
SetRangeDouble:Waterfall 3 554 0.0
SetRangeDouble:Waterfall 3 562 0.0
SetRangeDouble:Waterfall 3 531 0.0
SetRangeDouble:Waterfall 3 539 0.0
SetRangeDouble:Waterfall 3 547 0.0
SetRangeDouble:Waterfall 3 555 0.0
SetRangeDouble:Waterfall 3 563 0.0
SetRangeDouble:Waterfall 4 10 0.0
SetRangeDouble:Waterfall 4 308 0.0
SetRangeDouble:Waterfall 4 430 0.0
SetRangeDouble:Waterfall 4 11 0.0
SetRangeDouble:Waterfall 4 309 0.0
SetRangeDouble:Waterfall 4 431 0.0
SetRangeDouble:Waterfall 4 12 0.0
SetRangeDouble:Waterfall 4 310 0.0
SetRangeDouble:Waterfall 4 432 0.0
SetRangeDouble:Waterfall 4 13 0.0
SetRangeDouble:Waterfall 4 311 0.0
SetRangeDouble:Waterfall 4 433 0.0
SetRangeDouble:Waterfall 4 14 0.0
SetRangeDouble:Waterfall 4 312 0.0
SetRangeDouble:Waterfall 4 434 0.0
SetRangeDouble:Waterfall 4 15 0.0
SetRangeDouble:Waterfall 4 313 0.0
SetRangeDouble:Waterfall 4 435 0.0
SetRangeDouble:Waterfall 4 16 0.0
SetRangeDouble:Waterfall 4 314 0.0
SetRangeDouble:Waterfall 4 436 0.0
SetRangeDouble:Waterfall 4 17 0.0
SetRangeDouble:Waterfall 4 315 0.0
SetRangeDouble:Waterfall 4 437 0.0
SetRangeDouble:Waterfall 4 18 0.0
SetRangeDouble:Waterfall 4 316 0.0
SetRangeDouble:Waterfall 4 438 0.0
SetRangeDouble:Waterfall 4 19 0.0
SetRangeDouble:Waterfall 4 317 0.0
SetRangeDouble:Waterfall 4 439 0.0
SetRangeDouble:Waterfall 4 527 0.0
SetRangeDouble:Waterfall 4 535 0.0
SetRangeDouble:Waterfall 4 543 0.0
SetRangeDouble:Waterfall 4 551 0.0
SetRangeDouble:Waterfall 4 559 0.0
SetRangeDouble:Waterfall 4 528 0.0
SetRangeDouble:Waterfall 4 536 0.0
SetRangeDouble:Waterfall 4 544 0.0
SetRangeDouble:Waterfall 4 552 0.0
SetRangeDouble:Waterfall 4 560 0.0
SetRangeDouble:Waterfall 4 529 0.0
SetRangeDouble:Waterfall 4 537 0.0
SetRangeDouble:Waterfall 4 545 0.0
SetRangeDouble:Waterfall 4 553 0.0
SetRangeDouble:Waterfall 4 561 0.0
SetRangeDouble:Waterfall 4 530 0.0
SetRangeDouble:Waterfall 4 538 0.0
SetRangeDouble:Waterfall 4 546 0.0
SetRangeDouble:Waterfall 4 554 0.0
SetRangeDouble:Waterfall 4 562 0.0
SetRangeDouble:Waterfall 4 531 0.0
SetRangeDouble:Waterfall 4 539 0.0
SetRangeDouble:Waterfall 4 547 0.0
SetRangeDouble:Waterfall 4 555 0.0
SetRangeDouble:Waterfall 4 563 0.0
SetRangeDouble:Waterfall 5 10 0.0
SetRangeDouble:Waterfall 5 308 0.0
SetRangeDouble:Waterfall 5 430 0.0
SetRangeDouble:Waterfall 5 11 0.0
SetRangeDouble:Waterfall 5 309 0.0
SetRangeDouble:Waterfall 5 431 0.0
SetRangeDouble:Waterfall 5 12 0.0
SetRangeDouble:Waterfall 5 310 0.0
SetRangeDouble:Waterfall 5 432 0.0
SetRangeDouble:Waterfall 5 13 0.0
SetRangeDouble:Waterfall 5 311 0.0
SetRangeDouble:Waterfall 5 433 0.0
SetRangeDouble:Waterfall 5 14 0.0
SetRangeDouble:Waterfall 5 312 0.0
SetRangeDouble:Waterfall 5 434 0.0
SetRangeDouble:Waterfall 5 15 0.0
SetRangeDouble:Waterfall 5 313 0.0
SetRangeDouble:Waterfall 5 435 0.0
SetRangeDouble:Waterfall 5 16 0.0
SetRangeDouble:Waterfall 5 314 0.0
SetRangeDouble:Waterfall 5 436 0.0
SetRangeDouble:Waterfall 5 17 0.0
SetRangeDouble:Waterfall 5 315 0.0
SetRangeDouble:Waterfall 5 437 0.0
SetRangeDouble:Waterfall 5 18 0.0
SetRangeDouble:Waterfall 5 316 0.0
SetRangeDouble:Waterfall 5 438 0.0
SetRangeDouble:Waterfall 5 19 0.0
SetRangeDouble:Waterfall 5 317 0.0
SetRangeDouble:Waterfall 5 439 0.0
SetRangeDouble:Waterfall 5 527 0.0
SetRangeDouble:Waterfall 5 535 0.0
SetRangeDouble:Waterfall 5 543 0.0
SetRangeDouble:Waterfall 5 551 0.0
SetRangeDouble:Waterfall 5 559 0.0
SetRangeDouble:Waterfall 5 528 0.0
SetRangeDouble:Waterfall 5 536 0.0
SetRangeDouble:Waterfall 5 544 0.0
SetRangeDouble:Waterfall 5 552 0.0
SetRangeDouble:Waterfall 5 560 0.0
SetRangeDouble:Waterfall 5 529 0.0
SetRangeDouble:Waterfall 5 537 0.0
SetRangeDouble:Waterfall 5 545 0.0
SetRangeDouble:Waterfall 5 553 0.0
SetRangeDouble:Waterfall 5 561 0.0
SetRangeDouble:Waterfall 5 530 0.0
SetRangeDouble:Waterfall 5 538 0.0
SetRangeDouble:Waterfall 5 546 0.0
SetRangeDouble:Waterfall 5 554 0.0
SetRangeDouble:Waterfall 5 562 0.0
SetRangeDouble:Waterfall 5 531 0.0
SetRangeDouble:Waterfall 5 539 0.0
SetRangeDouble:Waterfall 5 547 0.0
SetRangeDouble:Waterfall 5 555 0.0
SetRangeDouble:Waterfall 5 563 0.0
SetRangeDouble:Waterfall 6 10 0.0
SetRangeDouble:Waterfall 6 308 0.0
SetRangeDouble:Waterfall 6 430 0.0
SetRangeDouble:Waterfall 6 11 0.0
SetRangeDouble:Waterfall 6 309 0.0
SetRangeDouble:Waterfall 6 431 0.0
SetRangeDouble:Waterfall 6 12 0.0
SetRangeDouble:Waterfall 6 310 0.0
SetRangeDouble:Waterfall 6 432 0.0
SetRangeDouble:Waterfall 6 13 0.0
SetRangeDouble:Waterfall 6 311 0.0
SetRangeDouble:Waterfall 6 433 0.0
SetRangeDouble:Waterfall 6 14 0.0
SetRangeDouble:Waterfall 6 312 0.0
SetRangeDouble:Waterfall 6 434 0.0
SetRangeDouble:Waterfall 6 15 0.0
SetRangeDouble:Waterfall 6 313 0.0
SetRangeDouble:Waterfall 6 435 0.0
SetRangeDouble:Waterfall 6 16 0.0
SetRangeDouble:Waterfall 6 314 0.0
SetRangeDouble:Waterfall 6 436 0.0
SetRangeDouble:Waterfall 6 17 0.0
SetRangeDouble:Waterfall 6 315 0.0
SetRangeDouble:Waterfall 6 437 0.0
SetRangeDouble:Waterfall 6 18 0.0
SetRangeDouble:Waterfall 6 316 0.0
SetRangeDouble:Waterfall 6 438 0.0
SetRangeDouble:Waterfall 6 19 0.0
SetRangeDouble:Waterfall 6 317 0.0
SetRangeDouble:Waterfall 6 439 0.0
SetRangeDouble:Waterfall 6 527 0.0
SetRangeDouble:Waterfall 6 535 0.0
SetRangeDouble:Waterfall 6 543 0.0
SetRangeDouble:Waterfall 6 551 0.0
SetRangeDouble:Waterfall 6 559 0.0
SetRangeDouble:Waterfall 6 528 0.0
SetRangeDouble:Waterfall 6 536 0.0
SetRangeDouble:Waterfall 6 544 0.0
SetRangeDouble:Waterfall 6 552 0.0
SetRangeDouble:Waterfall 6 560 0.0
SetRangeDouble:Waterfall 6 529 0.0
SetRangeDouble:Waterfall 6 537 0.0
SetRangeDouble:Waterfall 6 545 0.0
SetRangeDouble:Waterfall 6 553 0.0
SetRangeDouble:Waterfall 6 561 0.0
SetRangeDouble:Waterfall 6 530 0.0
SetRangeDouble:Waterfall 6 538 0.0
SetRangeDouble:Waterfall 6 546 0.0
SetRangeDouble:Waterfall 6 554 0.0
SetRangeDouble:Waterfall 6 562 0.0
SetRangeDouble:Waterfall 6 531 0.0
SetRangeDouble:Waterfall 6 539 0.0
SetRangeDouble:Waterfall 6 547 0.0
SetRangeDouble:Waterfall 6 555 0.0
SetRangeDouble:Waterfall 6 563 0.0
SetRangeDouble:Waterfall 7 10 0.0
SetRangeDouble:Waterfall 7 308 0.0
SetRangeDouble:Waterfall 7 430 0.0
SetRangeDouble:Waterfall 7 11 0.0
SetRangeDouble:Waterfall 7 309 0.0
SetRangeDouble:Waterfall 7 431 0.0
SetRangeDouble:Waterfall 7 12 0.0
SetRangeDouble:Waterfall 7 310 0.0
SetRangeDouble:Waterfall 7 432 0.0
SetRangeDouble:Waterfall 7 13 0.0
SetRangeDouble:Waterfall 7 311 0.0
SetRangeDouble:Waterfall 7 433 0.0
SetRangeDouble:Waterfall 7 14 0.0
SetRangeDouble:Waterfall 7 312 0.0
SetRangeDouble:Waterfall 7 434 0.0
SetRangeDouble:Waterfall 7 15 0.0
SetRangeDouble:Waterfall 7 313 0.0
SetRangeDouble:Waterfall 7 435 0.0
SetRangeDouble:Waterfall 7 16 0.0
SetRangeDouble:Waterfall 7 314 0.0
SetRangeDouble:Waterfall 7 436 0.0
SetRangeDouble:Waterfall 7 17 0.0
SetRangeDouble:Waterfall 7 315 0.0
SetRangeDouble:Waterfall 7 437 0.0
SetRangeDouble:Waterfall 7 18 0.0
SetRangeDouble:Waterfall 7 316 0.0
SetRangeDouble:Waterfall 7 438 0.0
SetRangeDouble:Waterfall 7 19 0.0
SetRangeDouble:Waterfall 7 317 0.0
SetRangeDouble:Waterfall 7 439 0.0
SetRangeDouble:Waterfall 7 527 0.0
SetRangeDouble:Waterfall 7 535 0.0
SetRangeDouble:Waterfall 7 543 0.0
SetRangeDouble:Waterfall 7 551 0.0
SetRangeDouble:Waterfall 7 559 0.0
SetRangeDouble:Waterfall 7 528 0.0
SetRangeDouble:Waterfall 7 536 0.0
SetRangeDouble:Waterfall 7 544 0.0
SetRangeDouble:Waterfall 7 552 0.0
SetRangeDouble:Waterfall 7 560 0.0
SetRangeDouble:Waterfall 7 529 0.0
SetRangeDouble:Waterfall 7 537 0.0
SetRangeDouble:Waterfall 7 545 0.0
SetRangeDouble:Waterfall 7 553 0.0
SetRangeDouble:Waterfall 7 561 0.0
SetRangeDouble:Waterfall 7 530 0.0
SetRangeDouble:Waterfall 7 538 0.0
SetRangeDouble:Waterfall 7 546 0.0
SetRangeDouble:Waterfall 7 554 0.0
SetRangeDouble:Waterfall 7 562 0.0
SetRangeDouble:Waterfall 7 531 0.0
SetRangeDouble:Waterfall 7 539 0.0
SetRangeDouble:Waterfall 7 547 0.0
SetRangeDouble:Waterfall 7 555 0.0
SetRangeDouble:Waterfall 7 563 0.0
SetRangeDouble:Waterfall 8 10 0.0
SetRangeDouble:Waterfall 8 308 0.0
SetRangeDouble:Waterfall 8 430 0.0
SetRangeDouble:Waterfall 8 11 0.0
SetRangeDouble:Waterfall 8 309 0.0
SetRangeDouble:Waterfall 8 431 0.0
SetRangeDouble:Waterfall 8 12 0.0
SetRangeDouble:Waterfall 8 310 0.0
SetRangeDouble:Waterfall 8 432 0.0
SetRangeDouble:Waterfall 8 13 0.0
SetRangeDouble:Waterfall 8 311 0.0
SetRangeDouble:Waterfall 8 433 0.0
SetRangeDouble:Waterfall 8 14 0.0
SetRangeDouble:Waterfall 8 312 0.0
SetRangeDouble:Waterfall 8 434 0.0
SetRangeDouble:Waterfall 8 15 0.0
SetRangeDouble:Waterfall 8 313 0.0
SetRangeDouble:Waterfall 8 435 0.0
SetRangeDouble:Waterfall 8 16 0.0
SetRangeDouble:Waterfall 8 314 0.0
SetRangeDouble:Waterfall 8 436 0.0
SetRangeDouble:Waterfall 8 17 0.0
SetRangeDouble:Waterfall 8 315 0.0
SetRangeDouble:Waterfall 8 437 0.0
SetRangeDouble:Waterfall 8 18 0.0
SetRangeDouble:Waterfall 8 316 0.0
SetRangeDouble:Waterfall 8 438 0.0
SetRangeDouble:Waterfall 8 19 0.0
SetRangeDouble:Waterfall 8 317 0.0
SetRangeDouble:Waterfall 8 439 0.0
SetRangeDouble:Waterfall 8 527 0.0
SetRangeDouble:Waterfall 8 535 0.0
SetRangeDouble:Waterfall 8 543 0.0
SetRangeDouble:Waterfall 8 551 0.0
SetRangeDouble:Waterfall 8 559 0.0
SetRangeDouble:Waterfall 8 528 0.0
SetRangeDouble:Waterfall 8 536 0.0
SetRangeDouble:Waterfall 8 544 0.0
SetRangeDouble:Waterfall 8 552 0.0
SetRangeDouble:Waterfall 8 560 0.0
SetRangeDouble:Waterfall 8 529 0.0
SetRangeDouble:Waterfall 8 537 0.0
SetRangeDouble:Waterfall 8 545 0.0
SetRangeDouble:Waterfall 8 553 0.0
SetRangeDouble:Waterfall 8 561 0.0
SetRangeDouble:Waterfall 8 530 0.0
SetRangeDouble:Waterfall 8 538 0.0
SetRangeDouble:Waterfall 8 546 0.0
SetRangeDouble:Waterfall 8 554 0.0
SetRangeDouble:Waterfall 8 562 0.0
SetRangeDouble:Waterfall 8 531 0.0
SetRangeDouble:Waterfall 8 539 0.0
SetRangeDouble:Waterfall 8 547 0.0
SetRangeDouble:Waterfall 8 555 0.0
SetRangeDouble:Waterfall 8 563 0.0
SetRangeDouble:Waterfall 9 10 0.0
SetRangeDouble:Waterfall 9 308 0.0
SetRangeDouble:Waterfall 9 430 0.0
SetRangeDouble:Waterfall 9 11 0.0
SetRangeDouble:Waterfall 9 309 0.0
SetRangeDouble:Waterfall 9 431 0.0
SetRangeDouble:Waterfall 9 12 0.0
SetRangeDouble:Waterfall 9 310 0.0
SetRangeDouble:Waterfall 9 432 0.0
SetRangeDouble:Waterfall 9 13 0.0
SetRangeDouble:Waterfall 9 311 0.0
SetRangeDouble:Waterfall 9 433 0.0
SetRangeDouble:Waterfall 9 14 0.0
SetRangeDouble:Waterfall 9 312 0.0
SetRangeDouble:Waterfall 9 434 0.0
SetRangeDouble:Waterfall 9 15 0.0
SetRangeDouble:Waterfall 9 313 0.0
SetRangeDouble:Waterfall 9 435 0.0
SetRangeDouble:Waterfall 9 16 0.0
SetRangeDouble:Waterfall 9 314 0.0
SetRangeDouble:Waterfall 9 436 0.0
SetRangeDouble:Waterfall 9 17 0.0
SetRangeDouble:Waterfall 9 315 0.0
SetRangeDouble:Waterfall 9 437 0.0
SetRangeDouble:Waterfall 9 18 0.0
SetRangeDouble:Waterfall 9 316 0.0
SetRangeDouble:Waterfall 9 438 0.0
SetRangeDouble:Waterfall 9 19 0.0
SetRangeDouble:Waterfall 9 317 0.0
SetRangeDouble:Waterfall 9 439 0.0
SetRangeDouble:Waterfall 9 527 0.0
SetRangeDouble:Waterfall 9 535 0.0
SetRangeDouble:Waterfall 9 543 0.0
SetRangeDouble:Waterfall 9 551 0.0
SetRangeDouble:Waterfall 9 559 0.0
SetRangeDouble:Waterfall 9 528 0.0
SetRangeDouble:Waterfall 9 536 0.0
SetRangeDouble:Waterfall 9 544 0.0
SetRangeDouble:Waterfall 9 552 0.0
SetRangeDouble:Waterfall 9 560 0.0
SetRangeDouble:Waterfall 9 529 0.0
SetRangeDouble:Waterfall 9 537 0.0
SetRangeDouble:Waterfall 9 545 0.0
SetRangeDouble:Waterfall 9 553 0.0
SetRangeDouble:Waterfall 9 561 0.0
SetRangeDouble:Waterfall 9 530 0.0
SetRangeDouble:Waterfall 9 538 0.0
SetRangeDouble:Waterfall 9 546 0.0
SetRangeDouble:Waterfall 9 554 0.0
SetRangeDouble:Waterfall 9 562 0.0
SetRangeDouble:Waterfall 9 531 0.0
SetRangeDouble:Waterfall 9 539 0.0
SetRangeDouble:Waterfall 9 547 0.0
SetRangeDouble:Waterfall 9 555 0.0
SetRangeDouble:Waterfall 9 563 0.0
SetRangeDouble:Waterfall 10 10 0.0
SetRangeDouble:Waterfall 10 308 0.0
SetRangeDouble:Waterfall 10 430 0.0
SetRangeDouble:Waterfall 10 11 0.0
SetRangeDouble:Waterfall 10 309 0.0
SetRangeDouble:Waterfall 10 431 0.0
SetRangeDouble:Waterfall 10 12 0.0
SetRangeDouble:Waterfall 10 310 0.0
SetRangeDouble:Waterfall 10 432 0.0
SetRangeDouble:Waterfall 10 13 0.0
SetRangeDouble:Waterfall 10 311 0.0
SetRangeDouble:Waterfall 10 433 0.0
SetRangeDouble:Waterfall 10 14 0.0
SetRangeDouble:Waterfall 10 312 0.0
SetRangeDouble:Waterfall 10 434 0.0
SetRangeDouble:Waterfall 10 15 0.0
SetRangeDouble:Waterfall 10 313 0.0
SetRangeDouble:Waterfall 10 435 0.0
SetRangeDouble:Waterfall 10 16 0.0
SetRangeDouble:Waterfall 10 314 0.0
SetRangeDouble:Waterfall 10 436 0.0
SetRangeDouble:Waterfall 10 17 0.0
SetRangeDouble:Waterfall 10 315 0.0
SetRangeDouble:Waterfall 10 437 0.0
SetRangeDouble:Waterfall 10 18 0.0
SetRangeDouble:Waterfall 10 316 0.0
SetRangeDouble:Waterfall 10 438 0.0
SetRangeDouble:Waterfall 10 19 0.0
SetRangeDouble:Waterfall 10 317 0.0
SetRangeDouble:Waterfall 10 439 0.0
SetRangeDouble:Waterfall 10 527 0.0
SetRangeDouble:Waterfall 10 535 0.0
SetRangeDouble:Waterfall 10 543 0.0
SetRangeDouble:Waterfall 10 551 0.0
SetRangeDouble:Waterfall 10 559 0.0
SetRangeDouble:Waterfall 10 528 0.0
SetRangeDouble:Waterfall 10 536 0.0
SetRangeDouble:Waterfall 10 544 0.0
SetRangeDouble:Waterfall 10 552 0.0
SetRangeDouble:Waterfall 10 560 0.0
SetRangeDouble:Waterfall 10 529 0.0
SetRangeDouble:Waterfall 10 537 0.0
SetRangeDouble:Waterfall 10 545 0.0
SetRangeDouble:Waterfall 10 553 0.0
SetRangeDouble:Waterfall 10 561 0.0
SetRangeDouble:Waterfall 10 530 0.0
SetRangeDouble:Waterfall 10 538 0.0
SetRangeDouble:Waterfall 10 546 0.0
SetRangeDouble:Waterfall 10 554 0.0
SetRangeDouble:Waterfall 10 562 0.0
SetRangeDouble:Waterfall 10 531 0.0
SetRangeDouble:Waterfall 10 539 0.0
SetRangeDouble:Waterfall 10 547 0.0
SetRangeDouble:Waterfall 10 555 0.0
SetRangeDouble:Waterfall 10 563 0.0
SetRangeDouble:Waterfall 11 10 0.0
SetRangeDouble:Waterfall 11 308 0.0
SetRangeDouble:Waterfall 11 430 0.0
SetRangeDouble:Waterfall 11 11 0.0
SetRangeDouble:Waterfall 11 309 0.0
SetRangeDouble:Waterfall 11 431 0.0
SetRangeDouble:Waterfall 11 12 0.0
SetRangeDouble:Waterfall 11 310 0.0
SetRangeDouble:Waterfall 11 432 0.0
SetRangeDouble:Waterfall 11 13 0.0
SetRangeDouble:Waterfall 11 311 0.0
SetRangeDouble:Waterfall 11 433 0.0
SetRangeDouble:Waterfall 11 14 0.0
SetRangeDouble:Waterfall 11 312 0.0
SetRangeDouble:Waterfall 11 434 0.0
SetRangeDouble:Waterfall 11 15 0.0
SetRangeDouble:Waterfall 11 313 0.0
SetRangeDouble:Waterfall 11 435 0.0
SetRangeDouble:Waterfall 11 16 0.0
SetRangeDouble:Waterfall 11 314 0.0
SetRangeDouble:Waterfall 11 436 0.0
SetRangeDouble:Waterfall 11 17 0.0
SetRangeDouble:Waterfall 11 315 0.0
SetRangeDouble:Waterfall 11 437 0.0
SetRangeDouble:Waterfall 11 18 0.0
SetRangeDouble:Waterfall 11 316 0.0
SetRangeDouble:Waterfall 11 438 0.0
SetRangeDouble:Waterfall 11 19 0.0
SetRangeDouble:Waterfall 11 317 0.0
SetRangeDouble:Waterfall 11 439 0.0
SetRangeDouble:Waterfall 11 527 0.0
SetRangeDouble:Waterfall 11 535 0.0
SetRangeDouble:Waterfall 11 543 0.0
SetRangeDouble:Waterfall 11 551 0.0
SetRangeDouble:Waterfall 11 559 0.0
SetRangeDouble:Waterfall 11 528 0.0
SetRangeDouble:Waterfall 11 536 0.0
SetRangeDouble:Waterfall 11 544 0.0
SetRangeDouble:Waterfall 11 552 0.0
SetRangeDouble:Waterfall 11 560 0.0
SetRangeDouble:Waterfall 11 529 0.0
SetRangeDouble:Waterfall 11 537 0.0
SetRangeDouble:Waterfall 11 545 0.0
SetRangeDouble:Waterfall 11 553 0.0
SetRangeDouble:Waterfall 11 561 0.0
SetRangeDouble:Waterfall 11 530 0.0
SetRangeDouble:Waterfall 11 538 0.0
SetRangeDouble:Waterfall 11 546 0.0
SetRangeDouble:Waterfall 11 554 0.0
SetRangeDouble:Waterfall 11 562 0.0
SetRangeDouble:Waterfall 11 531 0.0
SetRangeDouble:Waterfall 11 539 0.0
SetRangeDouble:Waterfall 11 547 0.0
SetRangeDouble:Waterfall 11 555 0.0
SetRangeDouble:Waterfall 11 563 0.0
SetRangeDouble:Waterfall 12 10 0.0
SetRangeDouble:Waterfall 12 308 0.0
SetRangeDouble:Waterfall 12 430 0.0
SetRangeDouble:Waterfall 12 11 0.0
SetRangeDouble:Waterfall 12 309 0.0
SetRangeDouble:Waterfall 12 431 0.0
SetRangeDouble:Waterfall 12 12 0.0
SetRangeDouble:Waterfall 12 310 0.0
SetRangeDouble:Waterfall 12 432 0.0
SetRangeDouble:Waterfall 12 13 0.0
SetRangeDouble:Waterfall 12 311 0.0
SetRangeDouble:Waterfall 12 433 0.0
SetRangeDouble:Waterfall 12 14 0.0
SetRangeDouble:Waterfall 12 312 0.0
SetRangeDouble:Waterfall 12 434 0.0
SetRangeDouble:Waterfall 12 15 0.0
SetRangeDouble:Waterfall 12 313 0.0
SetRangeDouble:Waterfall 12 435 0.0
SetRangeDouble:Waterfall 12 16 0.0
SetRangeDouble:Waterfall 12 314 0.0
SetRangeDouble:Waterfall 12 436 0.0
SetRangeDouble:Waterfall 12 17 0.0
SetRangeDouble:Waterfall 12 315 0.0
SetRangeDouble:Waterfall 12 437 0.0
SetRangeDouble:Waterfall 12 18 0.0
SetRangeDouble:Waterfall 12 316 0.0
SetRangeDouble:Waterfall 12 438 0.0
SetRangeDouble:Waterfall 12 19 0.0
SetRangeDouble:Waterfall 12 317 0.0
SetRangeDouble:Waterfall 12 439 0.0
SetRangeDouble:Waterfall 12 527 0.0
SetRangeDouble:Waterfall 12 535 0.0
SetRangeDouble:Waterfall 12 543 0.0
SetRangeDouble:Waterfall 12 551 0.0
SetRangeDouble:Waterfall 12 559 0.0
SetRangeDouble:Waterfall 12 528 0.0
SetRangeDouble:Waterfall 12 536 0.0
SetRangeDouble:Waterfall 12 544 0.0
SetRangeDouble:Waterfall 12 552 0.0
SetRangeDouble:Waterfall 12 560 0.0
SetRangeDouble:Waterfall 12 529 0.0
SetRangeDouble:Waterfall 12 537 0.0
SetRangeDouble:Waterfall 12 545 0.0
SetRangeDouble:Waterfall 12 553 0.0
SetRangeDouble:Waterfall 12 561 0.0
SetRangeDouble:Waterfall 12 530 0.0
SetRangeDouble:Waterfall 12 538 0.0
SetRangeDouble:Waterfall 12 546 0.0
SetRangeDouble:Waterfall 12 554 0.0
SetRangeDouble:Waterfall 12 562 0.0
SetRangeDouble:Waterfall 12 531 0.0
SetRangeDouble:Waterfall 12 539 0.0
SetRangeDouble:Waterfall 12 547 0.0
SetRangeDouble:Waterfall 12 555 0.0
SetRangeDouble:Waterfall 12 563 0.0
SetRangeDouble:Waterfall 13 10 0.0
SetRangeDouble:Waterfall 13 308 0.0
SetRangeDouble:Waterfall 13 430 0.0
SetRangeDouble:Waterfall 13 11 0.0
SetRangeDouble:Waterfall 13 309 0.0
SetRangeDouble:Waterfall 13 431 0.0
SetRangeDouble:Waterfall 13 12 0.0
SetRangeDouble:Waterfall 13 310 0.0
SetRangeDouble:Waterfall 13 432 0.0
SetRangeDouble:Waterfall 13 13 0.0
SetRangeDouble:Waterfall 13 311 0.0
SetRangeDouble:Waterfall 13 433 0.0
SetRangeDouble:Waterfall 13 14 0.0
SetRangeDouble:Waterfall 13 312 0.0
SetRangeDouble:Waterfall 13 434 0.0
SetRangeDouble:Waterfall 13 15 0.0
SetRangeDouble:Waterfall 13 313 0.0
SetRangeDouble:Waterfall 13 435 0.0
SetRangeDouble:Waterfall 13 16 0.0
SetRangeDouble:Waterfall 13 314 0.0
SetRangeDouble:Waterfall 13 436 0.0
SetRangeDouble:Waterfall 13 17 0.0
SetRangeDouble:Waterfall 13 315 0.0
SetRangeDouble:Waterfall 13 437 0.0
SetRangeDouble:Waterfall 13 18 0.0
SetRangeDouble:Waterfall 13 316 0.0
SetRangeDouble:Waterfall 13 438 0.0
SetRangeDouble:Waterfall 13 19 0.0
SetRangeDouble:Waterfall 13 317 0.0
SetRangeDouble:Waterfall 13 439 0.0
SetRangeDouble:Waterfall 13 527 0.0
SetRangeDouble:Waterfall 13 535 0.0
SetRangeDouble:Waterfall 13 543 0.0
SetRangeDouble:Waterfall 13 551 0.0
SetRangeDouble:Waterfall 13 559 0.0
SetRangeDouble:Waterfall 13 528 0.0
SetRangeDouble:Waterfall 13 536 0.0
SetRangeDouble:Waterfall 13 544 0.0
SetRangeDouble:Waterfall 13 552 0.0
SetRangeDouble:Waterfall 13 560 0.0
SetRangeDouble:Waterfall 13 529 0.0
SetRangeDouble:Waterfall 13 537 0.0
SetRangeDouble:Waterfall 13 545 0.0
SetRangeDouble:Waterfall 13 553 0.0
SetRangeDouble:Waterfall 13 561 0.0
SetRangeDouble:Waterfall 13 530 0.0
SetRangeDouble:Waterfall 13 538 0.0
SetRangeDouble:Waterfall 13 546 0.0
SetRangeDouble:Waterfall 13 554 0.0
SetRangeDouble:Waterfall 13 562 0.0
SetRangeDouble:Waterfall 13 531 0.0
SetRangeDouble:Waterfall 13 539 0.0
SetRangeDouble:Waterfall 13 547 0.0
SetRangeDouble:Waterfall 13 555 0.0
SetRangeDouble:Waterfall 13 563 0.0
SetRangeDouble:Waterfall 14 10 0.0
SetRangeDouble:Waterfall 14 308 0.0
SetRangeDouble:Waterfall 14 430 0.0
SetRangeDouble:Waterfall 14 11 0.0
SetRangeDouble:Waterfall 14 309 0.0
SetRangeDouble:Waterfall 14 431 0.0
SetRangeDouble:Waterfall 14 12 0.0
SetRangeDouble:Waterfall 14 310 0.0
SetRangeDouble:Waterfall 14 432 0.0
SetRangeDouble:Waterfall 14 13 0.0
SetRangeDouble:Waterfall 14 311 0.0
SetRangeDouble:Waterfall 14 433 0.0
SetRangeDouble:Waterfall 14 14 0.0
SetRangeDouble:Waterfall 14 312 0.0
SetRangeDouble:Waterfall 14 434 0.0
SetRangeDouble:Waterfall 14 15 0.0
SetRangeDouble:Waterfall 14 313 0.0
SetRangeDouble:Waterfall 14 435 0.0
SetRangeDouble:Waterfall 14 16 0.0
SetRangeDouble:Waterfall 14 314 0.0
SetRangeDouble:Waterfall 14 436 0.0
SetRangeDouble:Waterfall 14 17 0.0
SetRangeDouble:Waterfall 14 315 0.0
SetRangeDouble:Waterfall 14 437 0.0
SetRangeDouble:Waterfall 14 18 0.0
SetRangeDouble:Waterfall 14 316 0.0
SetRangeDouble:Waterfall 14 438 0.0
SetRangeDouble:Waterfall 14 19 0.0
SetRangeDouble:Waterfall 14 317 0.0
SetRangeDouble:Waterfall 14 439 0.0
SetRangeDouble:Waterfall 14 527 0.0
SetRangeDouble:Waterfall 14 535 0.0
SetRangeDouble:Waterfall 14 543 0.0
SetRangeDouble:Waterfall 14 551 0.0
SetRangeDouble:Waterfall 14 559 0.0
SetRangeDouble:Waterfall 14 528 0.0
SetRangeDouble:Waterfall 14 536 0.0
SetRangeDouble:Waterfall 14 544 0.0
SetRangeDouble:Waterfall 14 552 0.0
SetRangeDouble:Waterfall 14 560 0.0
SetRangeDouble:Waterfall 14 529 0.0
SetRangeDouble:Waterfall 14 537 0.0
SetRangeDouble:Waterfall 14 545 0.0
SetRangeDouble:Waterfall 14 553 0.0
SetRangeDouble:Waterfall 14 561 0.0
SetRangeDouble:Waterfall 14 530 0.0
SetRangeDouble:Waterfall 14 538 0.0
SetRangeDouble:Waterfall 14 546 0.0
SetRangeDouble:Waterfall 14 554 0.0
SetRangeDouble:Waterfall 14 562 0.0
SetRangeDouble:Waterfall 14 531 0.0
SetRangeDouble:Waterfall 14 539 0.0
SetRangeDouble:Waterfall 14 547 0.0
SetRangeDouble:Waterfall 14 555 0.0
SetRangeDouble:Waterfall 14 563 0.0
SetRangeDouble:Waterfall 15 10 0.0
SetRangeDouble:Waterfall 15 308 0.0
SetRangeDouble:Waterfall 15 430 0.0
SetRangeDouble:Waterfall 15 11 0.0
SetRangeDouble:Waterfall 15 309 0.0
SetRangeDouble:Waterfall 15 431 0.0
SetRangeDouble:Waterfall 15 12 0.0
SetRangeDouble:Waterfall 15 310 0.0
SetRangeDouble:Waterfall 15 432 0.0
SetRangeDouble:Waterfall 15 13 0.0
SetRangeDouble:Waterfall 15 311 0.0
SetRangeDouble:Waterfall 15 433 0.0
SetRangeDouble:Waterfall 15 14 0.0
SetRangeDouble:Waterfall 15 312 0.0
SetRangeDouble:Waterfall 15 434 0.0
SetRangeDouble:Waterfall 15 15 0.0
SetRangeDouble:Waterfall 15 313 0.0
SetRangeDouble:Waterfall 15 435 0.0
SetRangeDouble:Waterfall 15 16 0.0
SetRangeDouble:Waterfall 15 314 0.0
SetRangeDouble:Waterfall 15 436 0.0
SetRangeDouble:Waterfall 15 17 0.0
SetRangeDouble:Waterfall 15 315 0.0
SetRangeDouble:Waterfall 15 437 0.0
SetRangeDouble:Waterfall 15 18 0.0
SetRangeDouble:Waterfall 15 316 0.0
SetRangeDouble:Waterfall 15 438 0.0
SetRangeDouble:Waterfall 15 19 0.0
SetRangeDouble:Waterfall 15 317 0.0
SetRangeDouble:Waterfall 15 439 0.0
SetRangeDouble:Waterfall 15 527 0.0
SetRangeDouble:Waterfall 15 535 0.0
SetRangeDouble:Waterfall 15 543 0.0
SetRangeDouble:Waterfall 15 551 0.0
SetRangeDouble:Waterfall 15 559 0.0
SetRangeDouble:Waterfall 15 528 0.0
SetRangeDouble:Waterfall 15 536 0.0
SetRangeDouble:Waterfall 15 544 0.0
SetRangeDouble:Waterfall 15 552 0.0
SetRangeDouble:Waterfall 15 560 0.0
SetRangeDouble:Waterfall 15 529 0.0
SetRangeDouble:Waterfall 15 537 0.0
SetRangeDouble:Waterfall 15 545 0.0
SetRangeDouble:Waterfall 15 553 0.0
SetRangeDouble:Waterfall 15 561 0.0
SetRangeDouble:Waterfall 15 530 0.0
SetRangeDouble:Waterfall 15 538 0.0
SetRangeDouble:Waterfall 15 546 0.0
SetRangeDouble:Waterfall 15 554 0.0
SetRangeDouble:Waterfall 15 562 0.0
SetRangeDouble:Waterfall 15 531 0.0
SetRangeDouble:Waterfall 15 539 0.0
SetRangeDouble:Waterfall 15 547 0.0
SetRangeDouble:Waterfall 15 555 0.0
SetRangeDouble:Waterfall 15 563 0.0
SetRangeDouble:Waterfall 16 10 0.0
SetRangeDouble:Waterfall 16 308 0.0
SetRangeDouble:Waterfall 16 430 0.0
SetRangeDouble:Waterfall 16 11 0.0
SetRangeDouble:Waterfall 16 309 0.0
SetRangeDouble:Waterfall 16 431 0.0
SetRangeDouble:Waterfall 16 12 0.0
SetRangeDouble:Waterfall 16 310 0.0
SetRangeDouble:Waterfall 16 432 0.0
SetRangeDouble:Waterfall 16 13 0.0
SetRangeDouble:Waterfall 16 311 0.0
SetRangeDouble:Waterfall 16 433 0.0
SetRangeDouble:Waterfall 16 14 0.0
SetRangeDouble:Waterfall 16 312 0.0
SetRangeDouble:Waterfall 16 434 0.0
SetRangeDouble:Waterfall 16 15 0.0
SetRangeDouble:Waterfall 16 313 0.0
SetRangeDouble:Waterfall 16 435 0.0
SetRangeDouble:Waterfall 16 16 0.0
SetRangeDouble:Waterfall 16 314 0.0
SetRangeDouble:Waterfall 16 436 0.0
SetRangeDouble:Waterfall 16 17 0.0
SetRangeDouble:Waterfall 16 315 0.0
SetRangeDouble:Waterfall 16 437 0.0
SetRangeDouble:Waterfall 16 18 0.0
SetRangeDouble:Waterfall 16 316 0.0
SetRangeDouble:Waterfall 16 438 0.0
SetRangeDouble:Waterfall 16 19 0.0
SetRangeDouble:Waterfall 16 317 0.0
SetRangeDouble:Waterfall 16 439 0.0
SetRangeDouble:Waterfall 16 527 0.0
SetRangeDouble:Waterfall 16 535 0.0
SetRangeDouble:Waterfall 16 543 0.0
SetRangeDouble:Waterfall 16 551 0.0
SetRangeDouble:Waterfall 16 559 0.0
SetRangeDouble:Waterfall 16 528 0.0
SetRangeDouble:Waterfall 16 536 0.0
SetRangeDouble:Waterfall 16 544 0.0
SetRangeDouble:Waterfall 16 552 0.0
SetRangeDouble:Waterfall 16 560 0.0
SetRangeDouble:Waterfall 16 529 0.0
SetRangeDouble:Waterfall 16 537 0.0
SetRangeDouble:Waterfall 16 545 0.0
SetRangeDouble:Waterfall 16 553 0.0
SetRangeDouble:Waterfall 16 561 0.0
SetRangeDouble:Waterfall 16 530 0.0
SetRangeDouble:Waterfall 16 538 0.0
SetRangeDouble:Waterfall 16 546 0.0
SetRangeDouble:Waterfall 16 554 0.0
SetRangeDouble:Waterfall 16 562 0.0
SetRangeDouble:Waterfall 16 531 0.0
SetRangeDouble:Waterfall 16 539 0.0
SetRangeDouble:Waterfall 16 547 0.0
SetRangeDouble:Waterfall 16 555 0.0
SetRangeDouble:Waterfall 16 563 0.0
Hi,
the problem in the code is at the end of class Macro_Rating_Cre, if you put a break point and view the values of these two values
double value1 = m_currentSheet.getCells().get(347,3).getFloatValue();
double value2 = (double) m_currentSheet.calculateFormula(m_currentSheet.getCells().get(347,3).getFormula(),calcOpt);
that refer to the same cell, are different, the first -74.8 the second and correct value is 0.0.
I espect after the calculateFormula instruction that the value1 assume value 0.0.
What’s the reason of different values ?
Best regards
Hi,
Thanks for your clarifications and using Aspose.Cells.
I am able to observe the issue but it needs some more investigation because I need to inspect your code and see if it could be fixed or not or if the code could be shortened to few lines or whole project needs to be submitted. We will look into it further and create a ticket for it so that it could be fixed in the next releases. We will keep you updated in this thread.
Hi,
Thanks for your posting and using Aspose.Cells.
We were able to observe this issue as per your description and logged it in our database for a fix.
This issue has been logged as
- CELLSJAVA-42039 - CalculateFormula has issue to recalc cells with reference to cells with formulas
The following lines have issue as per your description
Macro_Rating_RE.java
book.calculateFormula(calcOpt);
m_currentSheet.calculateFormula("=D348*1",calcOpt);
double value1 = m_currentSheet.getCells().get(347,3).getFloatValue();
double value2 = (double) m_currentSheet.calculateFormula(m_currentSheet.getCells().get(347,3).getFormula(),calcOpt);
gmaglie:
Hi, the problem in the code is at the end of class Macro_Rating_Cre, if you put a break point and view the values of these two values double value1 = m_currentSheet.getCells().get(347,3).getFloatValue(); double value2 = (double) m_currentSheet.calculateFormula(m_currentSheet.getCells().get(347,3).getFormula(),calcOpt); that refer to the same cell, are different, the first -74.8 the second and correct value is 0.0. I espect after the calculateFormula instruction that the value1 assume value 0.0. What’s the reason of different values ? Best regards
Hi,
Thanks for using Aspose.Cells.
Please download and try the latest fix: Aspose.Cells for Java v16.10.6 and let us know your feedback.
Hi,
using version 16.10.6 I don’t have the issue.
Thank’s
Regards
Hi again,
Thank you for the confirmation. Please feel free to contact us back in case you need our further assistance with Aspose APIs.
The issues you have found earlier (filed as CELLSJAVA-42039) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.