Excel view "loses" number/date formatting - excel ends up seeing numbers/dates as text (so wont work in formulas)

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Medium
    • 3.3.3
    • Affects Version/s: 3.2.3
    • Component/s: Navigation - Export
    • None
    • 3.02

      1) At some point in the page, one issue ends up spanning multiple excel rows... (merged cells)
      2) After that, all the numbers/dates are stored as text, rather than numbers (so they dont work in formulas)

      We are using Excel 2002.
      With Ppen Office, The spanning problem still seems to happen - but it seems to work ok anyway..

      If you log into jira as huline with our data, and go to this filter and export as excel, you will note 2 things:
      http://jira.london.echonet/secure/IssueNavigator.jspa?mode=hide&requestId=11786

              Assignee:
              Unassigned
              Reporter:
              Nick Minutello
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: