I have a column in database view of type decimal (20,2) and it can take both negative and positive number. Now on downloading excel doc via out-of-the box feature (Export Data Store Entity to Excel), all the number are being quoted inside single quotes but not the positive ones.
Any way to get rid of this?
Discussion posts and replies are publicly visible
Just adding a solution here.
If we use fixed function, then excel shows apostrophe symbol on digits more than 9,2 for negative number.
If we use regexreplaceall() then it works, it does not show apostrophe symbol digits more than 9,2 for negative number.
However, in both the cases, selection sum is not happening.
Hi Dhananjay, Can you post some code snippet please I did used regexreplaceall() function initially then used substitute and text to handle null and customized decimal places but still excel is adding apoptozole in the beginning for negative values.
I don't have access to exact snippet due to security, but I just wrapped the value with regexreplace. Shortly I will do a mimic and post here.