https://bz.apache.org/bugzilla/show_bug.cgi?id=70002
Bug ID: 70002
Summary: Validation with cell range only accepts a
single-column range
Product: POI
Version: unspecified
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
The poi version is 5.5.1 but it doesn't appear in the list of versions.
I'm having problems with data validation based on a cell range. It only seems
to work correctly when the range has a single column.
After some debugging, I suspect the bug is in
DataValidationEvaluator.getValidationValuesForConstraint, specifically these
lines:
if (eval instanceof TwoDEval) {
TwoDEval twod = (TwoDEval) eval;
for (int i=0; i < twod.getHeight(); i++) {
final ValueEval cellValue = twod.getValue(i, 0);
values.add(cellValue);
}
}
I noticed that LibreOffice Calc works with any range, but Excel only accepts a
single column OR ROW (!)
--
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]
