[Bug 70002] Validation with cell range only accepts a single-column range

[bugzilla]

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

--- Comment #1 from aditsu <adi...@yahoo.com> ---
Created attachment 40165
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=40165&action=edit
example spreadsheet

kotlin test code:

import org.apache.poi.ss.formula.DataValidationEvaluator
import org.apache.poi.ss.formula.WorkbookEvaluatorProvider
import org.apache.poi.ss.usermodel.WorkbookFactory
import org.apache.poi.ss.util.CellReference
import java.io.File

fun main() {
        val path = "/home/aditsu/Documents/range validation.xlsx"
        val wb = WorkbookFactory.create(File(path))
        val eval = wb.creationHelper.createFormulaEvaluator()
        val dve = DataValidationEvaluator(wb, eval as
WorkbookEvaluatorProvider)
        val sheet = wb.getSheetAt(0)
        for (row in 0..1) {
                val cell = sheet.getRow(row).getCell(0)
                println(cell.address.toString() + ": " +
dve.isValidCell(CellReference(cell)))
        }
}

result:
A1: true
A2: false

Both cells are supposed to be valid.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org