User Story

I want to freeze both columns and rows that allow the frozen separators to be positioned at the midpoint of merged cells.

Acceptance Criteria:

As a user, I can freeze both columns and rows, and the frozen separators should be independently adjustable to align with the middle of merged cells.

For example:

1. If I choose to freeze the first 3 columns and there is a merged cell in the range of A2:A5, the frozen area should be divided such that the left and right portions of the merged cell align with the frozen columns.
2. If I choose to freeze the first 3 rows and there is a merged cell in the range of B2:E2, the frozen area should be divided such that the upper and lower portions of the merged cell align with the frozen rows.

Details

Steps to Reproduce

1. import keikai-691.xlsx

Current Result

I6 is shifted to G6
D6:H6 is a merged cell

Expected Result

no unexpected shifting cells at row 6

Verify Use case

after fixing this bug, please verify it with a more complicated use case since the testing file is a simplified one

Steps to Reproduce

1. run 16234.zul 16234-3.xlsx
2. click the "reproduce" button to freeze

Expected result

no unexpected shifting cells