Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Formatting problems when exporting into excel

  1. #1
    Join Date
    Mar 2012
    Posts
    10

    Post Formatting problems when exporting into excel

    Hi,

    I've got two formatting problems when I export a report into excel:

    1) If I have percentage values > than 100, e.g. 103,94 %, then Excel displays "######" in the exported file.
    But if I have values < than 100, e.g 27,34 %, then Excel displays 27,34 %
    I tested lots of formatting types in style->exel->Formatting-override, but I didn't get the right formating type

    2) If i have date fields I use following formatting: "dd.mm.yy" but actually I want to see the dates like this: "dd.mm.yyyy".
    But if I use that formatting type I just got "######" in excel

    Does anybody know what the right formatting is?

  2. #2
    Join Date
    Oct 2005
    Posts
    94

    Default

    Without seeing your report, I am not sure what exactly is happening. It is working for me without the using the default override. I'm using 3.9.0. I attached a working example.
    Attached Files Attached Files

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.