Hi ,
we are using Export Data Store Entity to Excel smart service and for all text values starting with special character like "-"(dash symbol) , then it automatically adds single inverted comma at the starting of text .
PFB , all these values are stored as text and for negative value we are facing issue as it is appending inverted comma in starting . Even after changing data type to integer while exporting it does not worked .
How to resolve this issue ?
Thanks
Discussion posts and replies are publicly visible
Hi,Were you able to resolve this issue? We are running into a similar issue. Negative numbers that are stored in database as text but when the smart service generates the excel document, they get a special character as you have highlighted in yellow.
Hi, at this moment we have not found a fix.
Thank you for responding. I also run into the same issue with Export Data Store Entity to CSV smart service as well. As a workaround, I wrapped the negative numbers with parenthesis when writing to the database table. The negative numbers show up like (-0.25) on the Excel/CSV with no leading special character such as single quote. This not an ideal solution but it works for us since the database table that we export is only used for generating the excel report and nothing else.
Dear Amir, thank you for the response as well. really hope in the future a complete export to excel module will be developed by Appian which wills solve this and other issues.
You can append space on both sides to overcome this issue. This way we can fix the issue.