Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-531

cannot parse three double quote

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Later Later
    • 5.12.0
    • 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.

            DevChu DevChu
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: