Formula that contains Name doesn't update

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 3.5.0
    • Affects Version/s: 3.5.0
    • Component/s: ZSS Range & Model
    • None

      	@Test 
      	public void test(){
      		SBook book = SBooks.createBook("book1");
      		book.getBookSeries().setAutoFormulaCacheClean(true);
      		SSheet sheet1 = book.createSheet("Sheet1");
      		
      		book.createName("Test").setRefersToFormula("A1:B2");
      		SRanges.range(sheet1,"A1").setValue(1);
      		SRanges.range(sheet1,"B1").setValue(2);
      		
      		SRanges.range(sheet1,"C3").setEditText("=SUM(Test)");
      		
      		Assert.assertEquals(3D, sheet1.getCell("C3").getValue());
      		
      		SRanges.range(sheet1,"B1").setValue(3);
      		Assert.assertEquals(4D, sheet1.getCell("C3").getValue()); //fail on this line
      		
      	}
      

            Assignee:
            dennis
            Reporter:
            dennis
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: