Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-38174

Export to Excel or Word Is Generating HTML Instead

XMLWordPrintable

      If I export a filter to Excel or to Word the resulting download has an .xls or a .doc file extension, but in both cases the file contains HTML. Have I misconfigured something (content types?), or is the "Export Excel/Doc" function mistakenly hooked up to "Export HTML" instead?

      I just want to export the contents of the filter. CSV would be fine too (and more portable).

      Steps to repro:
      1. From the Issues > Search For Issues page, obtain a list of issues.
      2. Choose Export > Word or Export > Excel.
      3. A file "Atlassian JIRA.xls" or "Atlassian JIRA.doc" will be downloaded.
      4. The file will open in Pages or Numbers but will only show the raw HTML.
      5. From terminal run "file Atlassian\ JIRA.xls" and observe that it reports "HTML Document Text".
      6. Rename the file to "Atlassian JIRA.html" and open it in a browser.
      7. Observe that it renders as a web page.

      Expected behaviour: file should be in Excel or Word format.

      (Jira 6.3 EAP, Chrome, OS X.)

            [JRASERVER-38174] Export to Excel or Word Is Generating HTML Instead

            Ron Winacott added a comment -

            After removing the patch from Windows 7 Pro "Security Update for Microsoft Excel 2010 (KB3115322) 32-Bit Edition" I can now open the exported ".xls" files from JIRA. These files are really html file that use the MS code in execl to translate in to the BIFF xls file format.
            I have not dug in to the patch to find out why MS has stopped this feature.

            Ron Winacott added a comment - After removing the patch from Windows 7 Pro "Security Update for Microsoft Excel 2010 (KB3115322) 32-Bit Edition" I can now open the exported ".xls" files from JIRA. These files are really html file that use the MS code in execl to translate in to the BIFF xls file format. I have not dug in to the patch to find out why MS has stopped this feature.

            Zack Hansen added a comment -

            Then what do i do with that if it can not be used in excel?

            Zack Hansen added a comment - Then what do i do with that if it can not be used in excel?

            Ron Winacott added a comment -

            Thank you Zack for the update. We are seeing the same thing with Windows 7 Pro, Office 2010 trying to open a xls file generated out of JIRA 5.0.4 (Yes it is old!)

            The Execl window is blank with no rows or columns displayed. If I rename the file from .xls to .html I can open it in the browser as a table type display.

            Ron Winacott added a comment - Thank you Zack for the update. We are seeing the same thing with Windows 7 Pro, Office 2010 trying to open a xls file generated out of JIRA 5.0.4 (Yes it is old!) The Execl window is blank with no rows or columns displayed. If I rename the file from .xls to .html I can open it in the browser as a table type display.

            Zack Hansen added a comment -

            This no longer works as of the latest Windows Patch - file now is blank upon export.

            Zack Hansen added a comment - This no longer works as of the latest Windows Patch - file now is blank upon export.

            Midori added a comment -

            Better Excel Plugin is an improved Excel exporter add-on for JIRA.

            One of the major differences compared to the built-in export feature is that the add-on exports actual Excel spreadsheet files in the XLSX format, the native file format of Excel and pretty much all spreadsheet tools.
            For other differences, see this comparison.

            Midori added a comment - Better Excel Plugin is an improved Excel exporter add-on for JIRA. One of the major differences compared to the built-in export feature is that the add-on exports actual Excel spreadsheet files in the XLSX format , the native file format of Excel and pretty much all spreadsheet tools. For other differences, see this comparison .

            Oswaldo Hernandez (Inactive) added a comment -

            We do realise that this implementation has problems for certain office suites, and that problem is currently being tracked at JRA-32352

            Please watch/vote on that issue instead for updates in its progress / bring attention to this problem.

            Regards,

            Oswaldo Hernández.
            JIRA Bugmaster.
            [Atlassian].

            Oswaldo Hernandez (Inactive) added a comment - We do realise that this implementation has problems for certain office suites, and that problem is currently being tracked at JRA-32352 Please watch/vote on that issue instead for updates in its progress / bring attention to this problem. Regards, Oswaldo Hernández. JIRA Bugmaster. [Atlassian] .

            Oswaldo Hernandez (Inactive) added a comment -

            Hi michael.iles,

            This is the mechanism currently used by the "Excel/Word" export it produces a html file, renames it to the .doc / .xls extension so that MS Office's html engine looks after rendering the file.

            Regards,

            Oswaldo Hernández.
            JIRA Bugmaster.
            [Atlassian].

            Oswaldo Hernandez (Inactive) added a comment - Hi michael.iles , This is the mechanism currently used by the "Excel/Word" export it produces a html file, renames it to the .doc / .xls extension so that MS Office's html engine looks after rendering the file. Regards, Oswaldo Hernández. JIRA Bugmaster. [Atlassian] .

              Unassigned Unassigned
              michael.iles Michael Iles
              Affected customers:
              0 This affects my team
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: