how to insert JEXL expressions to the cell with data validation?

[kuoho]

i’m using jxls 2.14 . When creating an excel template, if a cell has a data validation, how can I put expression text in the cell.
if i want to put ${item.category} in the cell,

Or are there other methods to achieve this? Currently, the only thing I can think of is to remove the data validation, wait until the data is completely filled, and then use POI or areaListener to add the data validation again. But it seems a bit troublesome.Because I have a lot to validation

[kuoho]

I have solved it,first closing the error box of the cell so that expressions text can be put in, and then call transformer to open the error box

try (InputStream is = Files.newInputStream(Paths.get("src/test/resources/templates/excel/valid_template.xlsx"));
             OutputStream os = Files.newOutputStream(Paths.get("target/valid_template_output.xlsx"))) {
            Context context = new Context(data);
            PoiTransformer transformer = PoiTransformer.createTransformer(is, os);
            Sheet sheet = transformer.getWorkbook().getSheetAt(0);
            List<? extends DataValidation> dataValidations = sheet.getDataValidations();
            for (DataValidation dataValidation : dataValidations) {
                dataValidation.setShowErrorBox(true);
            }
            JxlsHelper.getInstance().processTemplate(context, transformer);
        }