-
Bug
-
Resolution: Fixed
-
Normal
-
3.9.1
-
None
-
Security Level: Jimmy
-
Sprint 8
steps to reproduce
- load the attached file
- copy A1 and paste to B1 with a hot key or context menu
current result
zss doesn't paste the value even A1 is unlocked.
debug info
- A1:C2 are all unlocked cells
- users can copy unlocked cells in Excel
- all action classes that extend AbstractCellDataStyleAction will be blocked in a protected sheet
- These actions are block by disabled UI: CellBorderAction, CellStyleAction, FontStyleAction, MergeCellAction, PasteCellAction, PasteSpecialCellAction, SortCellAction, ToggleMergeCellAction, UnmergeCellAction
- These actions are blocked at server side: ClearCellAction
Excel 2011 spec about copy-paste in a protected sheet:
In a protected sheet,
- users can copy among unlocked cells
- users copy a locked cell and paste it an unlocked one.
- it doesn't copy the "locked" status
- if there is a locked cell in the affected target range while copying, don't paste cells
- cut an unlocked cell, the cell should keep unlocked
- without sheet protection, cut an unlocked cell, the cell restores to the default value, locked is true
- unlocked cell can be "Clear Format", "Clear All", or "Clear Contents"
- "Clear Formats" resets locked status to true
workaround
- Override ZSS classes with the attached java files
https://github.com/zkoss/zkspreadsheet/tree/zss-1310 and test cases
- relates to
-
ZSS-1320 Auto-fill can fill unlocked cells within a protected sheet
-
- Closed
-