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

Conditional formatting cannot accept empty string formula

XMLWordPrintable

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

      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

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

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

              Created:
              Updated:
              Resolved: