Properties which are of integer or decimal type are getting stored as text in excel generated from pega. Even though they are of type number, they are getting treated as text and coming with a green triangle in excel. How to avoid this conversion to text?
@Pavan_kalyan Hi, how is the excel file being generated? Through the “export” link in a report? or using an excel template?
@Deivit , Using template.
@Pavan_kalyan So, are you using the {.property input} syntax? If so, then it also happened to me. The values were treated as text in the generated excel.
What I did was to create a hidden sheet in the excel were I put all of the properties I want to map, then in the main sheet I used a function like =INT or =ROUND to translate it to numbers.
