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

Excel Export Is Broken With Office 2010 or 2013 / LibreOffice / Numbers

XMLWordPrintable

      NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.

      We have reports from customers that Excel 2010/2013 does not accept the exported file from JIRA anymore. This needs to be verified and corrected.

      Excel export cannot be opened on LibreOffice either. And, apparently, on Google Docs as well. Apple's Numbers is also reported to be affected.

        1. excel-export.png
          excel-export.png
          40 kB
        2. JIRA Export Error.png
          JIRA Export Error.png
          23 kB
        3. ORC 1.1.1 (VEIC JIRA).xls
          9 kB

            [JRASERVER-32352] Excel Export Is Broken With Office 2010 or 2013 / LibreOffice / Numbers

            Oleksandr Chalyi added a comment -

            We are facing this issue in v. 7.6.9

            Oleksandr Chalyi added a comment - We are facing this issue in v. 7.6.9

            John Smith added a comment -

            Hi,

            we are using Jira Project Management Software (v7.3.6#73017-sha1:51437cf), and we still have this issue.

            No export to HTML.

            Exporting to CSV or XLS still has the date mixup...

            eg.:

            Created Updated
            10/Oct/17 2:38 PM 25/May/18 1:36 PM
            19/Oct/17 11:18 AM 20.04.2018 12:43
            19/Oct/17 3:31 PM 10.04.2018 12:53
            24/Oct/17 3:05 PM 25/May/18 1:41 PM
            25/Oct/17 7:55 AM 21/Mar/18 9:51 AM
            08.11.2017 14:34 10.04.2018 14:36
            31.01.2018 09:36 10.04.2018 13:33
            02.02.2018 18:57 26.02.2018 12:25
            14.02.2018 15:15 27/Mar/18 2:02 PM
            20.02.2018 13:16 24/May/18 2:44 PM
            09/Mar/18 10:52 AM 15/May/18 11:40 AM
            14/Mar/18 3:13 PM 25/May/18 11:16 AM

             

            please help....

            John Smith added a comment - Hi, we are using Jira  Project Management Software  (v7.3.6#73017-sha1:51437cf), and we still have this issue. No export to HTML. Exporting to CSV or XLS still has the date mixup... eg.: Created Updated 10/Oct/17 2:38 PM 25/May/18 1:36 PM 19/Oct/17 11:18 AM 20.04.2018 12:43 19/Oct/17 3:31 PM 10.04.2018 12:53 24/Oct/17 3:05 PM 25/May/18 1:41 PM 25/Oct/17 7:55 AM 21/Mar/18 9:51 AM 08.11.2017 14:34 10.04.2018 14:36 31.01.2018 09:36 10.04.2018 13:33 02.02.2018 18:57 26.02.2018 12:25 14.02.2018 15:15 27/Mar/18 2:02 PM 20.02.2018 13:16 24/May/18 2:44 PM 09/Mar/18 10:52 AM 15/May/18 11:40 AM 14/Mar/18 3:13 PM 25/May/18 11:16 AM   please help....

            Ignat (Inactive) added a comment - - edited

            Hi scmsupp,

            CSV export is available in JIRA Software 7.2.0. See all features in the release notes.

            Cheers,
            Ignat.

            Ignat (Inactive) added a comment - - edited Hi scmsupp , CSV export is available in JIRA Software 7.2.0. See all features in the  release notes . Cheers, Ignat.

            JIRA Plus at Volvo Cars Corporation added a comment -

            We use JIRA 7.0.10 but there´s no Export to Excel (HTML) just an Export to Excel option. Also there is neither Export to CSV or Export to HTML options either. In what version of JIRA are these available?

            JIRA Plus at Volvo Cars Corporation added a comment - We use JIRA 7.0.10 but there´s no Export to Excel (HTML) just an Export to Excel option. Also there is neither Export to CSV or Export to HTML options either. In what version of JIRA are these available?

            Kathleen Mullen added a comment -

            I don't think this helps those of us still using JIRA 6.4.x. Will we be getting this support?

            Kathleen Mullen added a comment - I don't think this helps those of us still using JIRA 6.4.x. Will we be getting this support?

            Dario B added a comment -

            Hello,

            Just to add some more context:

            • The export to Excel (HTML) functionality has always been exporting an html file having .xls extension.
            • Now that this functionality has been renamed to Export to HTML, in order to have it working as before, you just have to rename the exported file and change the file extension from .html to .xls.

            I hope this helps

            Cheers,
            Dario

            Dario B added a comment - Hello, Just to add some more context: The export to Excel (HTML) functionality has always been exporting an html file having .xls extension. Now that this functionality has been renamed to Export to HTML , in order to have it working as before, you just have to rename the exported file and change the file extension from .html to .xls. I hope this helps Cheers, Dario

            Kerrod Williams (Inactive) added a comment - - edited

            Hi all,

            Thank you to everyone who has given the time to watch, vote and comment on this issue. We have recently changed how JIRA exports data from the issue navigation screen.

            JIRA no longer supports exporting an Excel file, which renders this bug obsolete. Instead, we now export the HTML report (an identical export, without a .xls suffix) which when opened by Excel, should provide an equivalent result. We recommend migrating to the CSV export for any long term usage of this feature.

            I understand this is an extra step for many of you and could be seen as an inconvenience. However, we believe this is a more consistent solution than maintaining interoperability between multiple Excel-like products.

            Thank you for your understanding and patience.

            Kerrod Williams
            JIRA Product Management

            Kerrod Williams (Inactive) added a comment - - edited Hi all, Thank you to everyone who has given the time to watch, vote and comment on this issue. We have recently changed how JIRA exports data from the issue navigation screen. JIRA no longer supports exporting an Excel file, which renders this bug obsolete. Instead, we now export the HTML report (an identical export, without a .xls suffix) which when opened by Excel, should provide an equivalent result. We recommend migrating to the CSV export for any long term usage of this feature. I understand this is an extra step for many of you and could be seen as an inconvenience. However, we believe this is a more consistent solution than maintaining interoperability between multiple Excel-like products. Thank you for your understanding and patience. Kerrod Williams JIRA Product Management

            Claire Concowich added a comment -

            Mirroring current concerns, the export is bad. The output is a .csv without any formatting. In addition the selected columns of the export do not match in the export. The logo, exported timestamp etc are all lost. The export was one of key drivers to choose JIRA..

            Claire Concowich added a comment - Mirroring current concerns, the export is bad. The output is a .csv without any formatting. In addition the selected columns of the export do not match in the export. The logo, exported timestamp etc are all lost. The export was one of key drivers to choose JIRA..

            Joe Torres (Admin) added a comment -

            Hello

            I did an export as HTML, copy and pasted to an excel file. The formatting and hyperlinks appeared. It's an extra step but better than CSV.

            Joe

            Joe Torres (Admin) added a comment - Hello I did an export as HTML, copy and pasted to an excel file. The formatting and hyperlinks appeared. It's an extra step but better than CSV. Joe

            Ron Winacott added a comment -

            The export function was always HTML format leaving it up to the excel application to convert the tables (in HTML) to rows/columns.

            And to your question in comment, the short answer is no!

            Ron Winacott added a comment - The export function was always HTML format leaving it up to the excel application to convert the tables (in HTML) to rows/columns. And to your question in comment, the short answer is no!

              Unassigned Unassigned
              rpillai RenjithA
              Affected customers:
              85 This affects my team
              Watchers:
              83 Start watching this issue

                Created:
                Updated:
                Resolved: