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: