Uploaded image for project: 'Xporter for Jira'
  1. Xporter for Jira
  2. XPORTER-813

When creating Excel charts with data from different sheets, the chart isn't being correctly displayed.

    XporterXMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • Release 4.2.1
    • 5.0.0
    • None
    • None
    • R5.0.0 Sprint 3

    • UNCOVERED

    Description

      When creating Excel charts with data from different sheets, the chart isn't being correctly displayed.

      If the data exported is in the same sheet the chart is displayed correctly.

      See attached examples:
      templates: sameSheet.xlsx; multiSheet.xlsx
      outputs: issues_sameSheet.xlsx; issues_multiSheet.xlsx

      Attachments

        1. 001.PNG
          001.PNG
          44 kB
        2. 002.PNG
          002.PNG
          90 kB
        3. 003.PNG
          003.PNG
          41 kB
        4. 004.PNG
          004.PNG
          20 kB
        5. 005.PNG
          005.PNG
          37 kB
        6. 006.PNG
          006.PNG
          33 kB
        7. issues_multiSheet.xlsx
          11 kB
        8. issues_singleSheet.xlsx
          10 kB
        9. multiSheet.xlsx
          14 kB
        10. multisheetchart.xlsx
          14 kB
        11. multiSheet with PivotTable.xlsx
          18 kB
        12. sameSheet.xlsx
          13 kB
        13. XPORTER-813_multiSheet_v2.xlsx
          14 kB
        14. Xporter-813v3.xlsx
          15 kB

        Activity

          People

            sdrg sdrg
            mfda mfda
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 3 days Original Estimate - 3 days
                3d
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 4 days, 3 hours, 30 minutes
                4d 3h 30m