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

aditsu <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW

--- Comment #3 from aditsu <[email protected]> ---
Here's some test code in kotlin, using the attached spreadsheet:

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/numeric 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)
        val cell = sheet.getRow(0).getCell(0)
        println(dve.isValidCell(CellReference(cell)))
}

Result is false, although the cell is valid

-- 
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