https://bz.apache.org/bugzilla/show_bug.cgi?id=58641

--- Comment #5 from [email protected] ---
I've attached a proposal for a complete usermodel implementation. 
The proposal is inspired by DataValidation.

The proposal adds an interface named IgnoredError and corresponding new methods
in Sheet:


setters:

addIgnoredError(IgnoredError)
removeIgnoredError(IgnoredError)


getters:

List<? extends IgnoredError> getIgnoredErrors();




I've kept it simple. It is perfectly possible to have overlap in ignore error.

Suppose I add

  For types twoDigitTextYear,numberStoredAsText ignore in cells A1:A5.

and then in addition I add

  For type numberStoredAsText ignore in cell A1.


Now this is obviously redundant wrt to A1: I've told twice that I want
'numberStoredAsText' to be ignored for that cell. I've decided that this is
perfectly acceptable for the simple reason that it is also acceptable in OOXML.
This means implementers of the above shouldn't try to be clever about it and
try to collapse/reduce what has been requested *unless this is specifically
required by the format*.









   - formula
   - formulaRange
   - unlockedFormula
   - emptyCellReference

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to