Issue in display of digits when the list view report is exported to excel, the column with more than or equal to 15 digits is shown with exponent characters before the digits.
Issue:
when the list view report is exported to excel, the column with more than or equal to 15 digits is shown with exponent characters before the digits.
E.G
372800000000003 is shown as !!372800000000003 when exported to Excel
Steps to reproduce:
1. Open List view reports that contains column value with more than or equal to 15 digits
2.Click on Export to Excel
***Updated by Moderator: Vidyaranjan. Removed user added #helpme and Ask the Expert tags. Apologies for confusion, shouldn't have been an end-user option***
Tetrasoft India Private Limited
IN
Hi Nivethar,
Can you please confirm the following:
Which version of PRPC are you using?
What is the behaviour if you use report definition instead?
tcs
IN
Hi Dames,
We are currently using PEGA 7,1,7 Version which is upgraded from 6,1 Version of PEGA. In both the versions, the reported issue exists,
We cannot use Report Definition since we need to use the columns to be compared with datetime fields on which only date values can be entered, time values not displayed in RD whereas in List View Date and Time Values are displayed.
Our Requirement is to have Date and Time values to be displayed as input filter. But it is not possible with RD(Select Values -> Calendar as Date Field instead of Date Time Field in Calendar of List View Reports)