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

Exported file is corrupt after deleting a sheet

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2.6.0
    • Freshly, 2.6.0
    • None
    • Security Level: Jimmy
    • None

      Steps to reproduce

      1. load attached lastSheetActive.xlsx file with 2.6.0.FL.20140722-Eval (you can use activeTab.zul)
      2. delete 2nd sheet
      3. export it
      4. open it with Excel 2007

      Actual Result:

      Excel shows a popup said that the file has unreadable content, but it can be recovered by Excel.

      Expected Result:

      no error message shows.

      Workaround

      reset active sheet before exporting

      Book book = spreadsheet.getBook();
      book.setActiveSheet(book.getSheetIndex(spreadsheet.getSelectedSheet()));
      

        1. activeTab.zul
          0.6 kB
        2. ActiveTabComposer.java
          1 kB
        3. excelError.png
          excelError.png
          5 kB
        4. lastSheetActive.xlsx
          17 kB

            Jenkins Jenkins
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: