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

Automatically ignore duplicate merged region when importing

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Normal
    • Resolution: Done
    • Affects Version/s: 3.8.1
    • Fix Version/s: 3.8.2
    • Component/s: None
    • Security Level: Jimmy
    • Labels:
      None

      Description

      Steps to reproduce

      1. load attached file

      Actual result

      org.zkoss.zss.model.InvalidModelOpException: the region is overlapped A1:D1[0,0,0,3]:A1:D1[0,0,0,3]
      at org.zkoss.zss.model.impl.SheetImpl.addMergedRegion(SheetImpl.java:1588)
      at org.zkoss.zss.range.impl.imexp.AbstractExcelImporter.importMergedRegions(AbstractExcelImporter.java:397)
      at org.zkoss.zss.range.impl.imexp.AbstractExcelImporter.imports(AbstractExcelImporter.java:157)
      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:647)
      at org.zkoss.zss.ui.Spreadsheet.getSelectedSSheet(Spreadsheet.java:845)
      at org.zkoss.zss.ui.Spreadsheet.doInvalidate(Spreadsheet.java:4668)
      at org.zkoss.zss.ui.Spreadsheet.invalidate(Spreadsheet.java:4007)
      at org.zkoss.zss.ui.Spreadsheet.setSrc(Spreadsheet.java:885)

      workaround

      <spreadsheet 
        importer="${c:new('foo.PatchedImporterImpl')}"/>
      

        Issue Links

          Activity

          Hide
          henrichen henrichen added a comment -

          Done.

          Show
          henrichen henrichen added a comment - Done.

            People

            • Assignee:
              henrichen henrichen
              Reporter:
              hawk hawk
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: