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

insert,delete whole column or row when overlap merge cell will cause unexpect result

XMLWordPrintable

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

      simple reproduce steps

      Issue 1:
      1. merge B2: D4
      2. insert/remove row at row 2 or 3
      3. nothing happen

      • if row 2 or 3 has non-blank cell, this will be correct.
      • row 1 won't happen this issue

      Issue 2:
      1. merge B2: D4
      2. insert/delete column C or D
      3. cells become chaos

      • if column C or D has non-blank cell, this will be correct.
      • column B won't happen this issue

      origin reproduce steps

      I found there are several situations.

      First, merge a cell (for example G7:I9)

      Situation A:
      1. select row 8 perform "insert rows" operation
      2. nothing happen
      above situation is the same when choose row 9, but choose row 7 will work.
      when choose column H, I will not work, but column G will work.

      Situation B:
      When choose column H, I then perform insert column the cell view will become chaos.

      Situation C:
      When choose column H, I then perform delete column the cell view will become chaos.

      another interesting about this issue is:
      When I apply a style(ex. font, background-color, border) on the merge cell then perform the operation in above situation will work fine.

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

              Created:
              Updated:
              Resolved: