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

Formula that refer to a NameRange does not update contents correctly

    Details

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

      Description

      SBook book = SBooks.createBook("book1");
      book.getBookSeries().setAutoFormulaCacheClean(true);
      SSheet sheet1 = book.createSheet("SheetX");

      SName name = book.createName("FOO");
      name.setRefersToFormula("SheetX!A1:B2");

      // test insert/delete cells
      sheet1.getCell("A1").setValue(1);
      sheet1.getCell("B1").setValue(2);
      sheet1.getCell("A2").setValue(3);
      sheet1.getCell("B2").setValue(4);

      Assert.assertEquals("SheetX!A1:B2", name.getRefersToFormula());
      Assert.assertEquals(10D, sheet1.getCell("D2").getValue());

      // insert B1:B1
      sheet1.insertCell(0, 1, 0, 1, true);
      Assert.assertEquals("SheetX!A1:B2", name.getRefersToFormula());
      Assert.assertEquals(8D, sheet1.getCell("D2").getValue());

        Activity

        Show
        henrichen henrichen added a comment - 3.5 https://github.com/zkoss/zkspreadsheet/commit/c5469cf05a98c51b7924625b95bb8bb877d30d57
        Hide
        henrichen henrichen added a comment -

        Fixed.

        Show
        henrichen henrichen added a comment - Fixed.

          People

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

            Dates

            • Created:
              Updated:
              Resolved: