Export Data Store Entity to Excel -Negative number quoted.

Certified Lead Developer

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

Parents Reply
  • 0
    Certified Lead Developer
    in reply to Stefan Helzle

    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

Children