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

Wrong evaluation result after insert/delete

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.5.0 RC
    • 3.5.0 RC
    • ZSS Range & Model
    • None

      fail on last verification

      		SBook book = SBooks.createBook("book1");
      		book.getBookSeries().setAutoFormulaCacheClean(true);
      		SSheet sheet1 = book.createSheet("Sheet1");
      		
      		sheet1.getCell("E4").setValue("=E4");
      		Assert.assertEquals("#N/A", sheet1.getCell("E4").getErrorValue().getErrorString());
      		
      		sheet1.getCell("E4").setValue("=A1");
      		
      		Assert.assertEquals(0D, sheet1.getCell("E4").getValue());
      		
      		SRanges.range(sheet1,"4").insert(InsertShift.DEFAULT, InsertCopyOrigin.FORMAT_NONE);
      		
      		sheet1.getCell("A1").setValue(20);
      		Assert.assertEquals("A1", sheet1.getCell("E5").getFormulaValue());
      		Assert.assertEquals(20D, sheet1.getCell("E5").getValue());
      		
      		
      		Assert.assertTrue(sheet1.getCell("E4").isNull());
      		
      		sheet1.getCell("E4").setValue("=E4");
      		Assert.assertEquals("#N/A", sheet1.getCell("E4").getErrorValue().getErrorString());
      

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

              Created:
              Updated:
              Resolved: