-
Bug
-
Resolution: Fixed
-
Later
-
5.8.1
-
None
-
Security Level: Jimmy
-
None
-
None
Steps to Reproduce
1. import the attached file
Current Result
Caused by: io.keikai.model.InvalidFormulaException: Invalid '"'
at io.keikai.model.impl.ConditionalFormattingRuleImpl.parseFormula(ConditionalFormattingRuleImpl.java:786)
at io.keikai.model.impl.ConditionalFormattingRuleImpl.setEscapedFormulas(ConditionalFormattingRuleImpl.java:807)
at io.keikai.model.impl.ConditionalFormattingRuleImpl.setFormula1(ConditionalFormattingRuleImpl.java:681)
at io.keikai.importer.XlsxImporter.prepareFormulas(XlsxImporter.java:3227)
at io.keikai.importer.XlsxImporter.prepareConditonalFormattingRuleImpl(XlsxImporter.java:3134)
at io.keikai.importer.XlsxImporter.prepareConditionalFormattingImpl(XlsxImporter.java:3085)
at io.keikai.importer.XlsxImporter.importConditionalFormatting(XlsxImporter.java:3051)
at io.keikai.importer.XlsxImporter.imports(XlsxImporter.java:266)
Expected Result
no error
Debug Information
- a conditional formatting formula ="""error""" caused the error. But if I enter the same formula in a cell, no error happens. It looks like parser should accept 3 double quotes.