Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-655

Formula that contains Name doesn't update

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.5.0
    • 3.5.0
    • 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
      		
      	}
      

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

              Created:
              Updated:
              Resolved: