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

Formula that contains Name doesn't update

    Details

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

      Description

      	@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
      		
      	}
      

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: