Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Different output/format when export in xls vs xlsx
Migrateduser
<div>I am creating a report using crosstab, group per month with "MONTH(dtime)" in store procs (It only shows number of month). Then I use map properties to map my month 'data["mtime"] equal to 1, display value = January'.</div>
<div> </div>
<div>When I export in old version excel (xls), it shows my map month name (January, February,...) but in new version excel (xlsx), it can't read my map month (it shows month number 1,2,...)</div>
<div> </div>
<div>How do I make it so that even in xlsx, it will still show January, February,... using map.</div>
<div> </div>
<div>Another example: Format Number, Percent. In xlsx, it won't show the % only show the raw data (e.g: 0.5366), in xls, it will show 53.67%</div>
<div> </div>
<div>Anyone please help me, it's urgent.</div>
<div>Thank you very much.</div>
Find more posts tagged with
Comments
There are no comments yet