Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Numberformats in Excel-Output

  1. #1

    Default Numberformats in Excel-Output

    I just created a report with the Report Designer. Everything looks fine in all output formats except XLS. In Excel I cannot see any of the numerical values. This is because for some reason the number format is set to ";;".
    The number format in the Report Designer is set as "#,##0.###", which works fine for me in a small test report.
    My report has 74 numerical values per Detail Band, I don't know if the amount has anything to do with it, though.



  2. #2

    Thumbs up Solved...

    Ok, my post came a bit too fast. Shortly afterwards I noticed the "Excel Format" field in the Report Designer. Everything works fine, now. Even though I don't understand, why my small test report worked, because there I had also left that field empty...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.