-
New Feature
-
Resolution: Fixed
-
Normal
-
3.9.1
-
None
-
Security Level: Jimmy
-
Sprint 8
Excel spec
*In a protected sheet
- auto-fill can fill unlocked cells within a protected sheet
- if auto-fill destination region contains at least 1 locked cell, it doesn't fill any cell and popup a warning message.
- a destination region excludes the selected source cells.
Select A1:B1 and drag to C1:D1, the destination is C1:D1.
related doc
Fill data automatically in worksheet cells
debug info
public abstract class AbstractCellHandler extends AbstractHandler { private static final long serialVersionUID = -1020093806000599051L; @Override public boolean isEnabled(Book book, Sheet sheet) { return book != null && sheet != null && ( !sheet.isProtected() || Ranges.range(sheet).getSheetProtection().isFormatCellsAllowed()); } }
The super class only enables a handler when format cell is allowed, but AutoFillHandler is not related to cell format.
- relates to
-
ZSS-1310 Can't perform some edit operations on unlocked cells in a protected sheet
- Closed