Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-1270

Conditional formatting cannot accept empty string formula

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Later
    • 3.9.1
    • 3.9.0
    • None
    • Security Level: Jimmy
    • None
    • Sprint 6

    Description

      Steps to reproduce

      1. load the attached file

      current result

      org.zkoss.zss.model.InvalidFormulaException: string format is not correct
      	at org.zkoss.zss.model.impl.ConditionalFormattingRuleImpl.parseFormula(ConditionalFormattingRuleImpl.java:821)
      	at org.zkoss.zss.model.impl.ConditionalFormattingRuleImpl.setEscapedFormulas(ConditionalFormattingRuleImpl.java:843)
      	at org.zkoss.zss.model.impl.ConditionalFormattingRuleImpl.setFormula1(ConditionalFormattingRuleImpl.java:717)
      	at org.zkoss.zss.range.impl.imexp.ExcelXlsxImporter.prepareFormulas(ExcelXlsxImporter.java:989)
      	at org.zkoss.zss.range.impl.imexp.ExcelXlsxImporter.prepareConditonalFormattingRuleImpl(ExcelXlsxImporter.java:876)
      	at org.zkoss.zss.range.impl.imexp.ExcelXlsxImporter.prepareConditionalFormattingImpl(ExcelXlsxImporter.java:847)
      	at org.zkoss.zss.range.impl.imexp.ExcelXlsxImporter.importConditionalFormatting(ExcelXlsxImporter.java:829)
      	at org.zkoss.zss.range.impl.imexp.AbstractExcelImporter.importSheet(AbstractExcelImporter.java:397)
      	at org.zkoss.zss.range.impl.imexp.AbstractExcelImporter.imports(AbstractExcelImporter.java:154)
      	at org.zkoss.zss.range.impl.imexp.ExcelImportAdapter.imports(ExcelImportAdapter.java:46)
      	at org.zkoss.zss.range.impl.imexp.AbstractImporter.imports(AbstractImporter.java:54)
      	at org.zkoss.zss.ui.Spreadsheet.getSBook(Spreadsheet.java:653)
      

      debug info

      • root cause is =""

      workaround

      Attachments

        1. blankCell.png
          blankCell.png
          30 kB
        2. emptyStringFormula.png
          emptyStringFormula.png
          33 kB
        3. t3691-emptyString.xlsx
          15 kB

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: