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
Let me elaborate. Correct me If I am wring at any place.
After 9-digit Appian display digits as exponent with same data type as rule input.
Now I can use text/fixed function to display it full but it does convert the data type to text which I don't want because of excel behavior.
And when you say "change it", change to what? What is the "correct" way of displaying a number? - it means, I am expecting if Appian would have display number as is format not with exponent
To make any number human readable, a computer needs to transform it into a text representation.
In Appian UI, we can use Appian default behaviour, or use the text() function for custom formatting.
Excel is known for trying/failing to be clever. When Appian exports data, it does so, exactly as defined in the database. Then Excel applies its cleverness and does weird stuff. Then you try to outsmart Excel and even more weird stuff happens. I apologize for my annoyed tone.
https://trumpexcel.com/scientific-notation-excel/
No problem, I got your point and I think we both are on same page. It's just I was trying to skip any manual intervention on excel.
Thanks!!
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.