Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-5246

As a reporting user I want the Excel export to automatically map Java number and Date formats into the correct Excel syntax to avoid errors with Excel 2007

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Severity: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: Report Generation
    • Labels:
      None
    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      When using certain Number and Date Format masks (common case: Prefix or suffix text, like "#,### units"), the Excel format mask syntax and the Java syntax differ slightly. Excel 2007 contains very strict checks on the contents of these formats and will display warnings of corrupt files if such an invalid format is encountered.

      At the moment, the user has to be aware of this and has to set the "Excel-Format-override" style accordingly.

      By writing an automatic translator that converts Java formats into their equivalent Excel formats, we can make the Excel export easier to use.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            tmorgner Thomas Morgner
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated: