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
Any leads?
Not sure ... could it be that this is just some Excel display "magic"?
Yeah, it seems, it is excel behavior. I found below info on web. Not sure what would be hack here.
Is it possible to have a View and have this particular field as VARCHAR using CONVERT and try? I haven't tried. Just guessing.
It is that way only, in DB view it is a varchar. The problem is the I am expecting bigger value like decimal(20,2) and we know in Appian after 9 digits it starts showing exponent. So, I have used some function and that is making the value as text.
Problem is the moment excel encounter a digit and if it is not in number/decimal data type, it does add apostrophe.Solution would be, we need a way to break down the exponent value by retaining the data type to decimal, which is not possible as of now.
See I am just using the value as coming from DB and I don't see apostrophe.