Skip to main content
dhananjayk3480
dhananjayk3480
February 14, 2024
Solved

Export Data Store Entity to Excel -Negative number quoted.

  • February 14, 2024
  • 17 replies
  • 0 views

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?


Best answer by dhananjayk3480

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.

17 replies

dhananjayk3480
dhananjayk3480Author
February 14, 2024

Just correcting, not quotes its apostrophe.

dhananjayk3480
dhananjayk3480Author
February 14, 2024

[mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05]  Any leads?

stefanhelzle0001
stefanhelzle0001
February 14, 2024

Not sure ... could it be that this is just some Excel display "magic"?

dhananjayk3480
dhananjayk3480Author
February 14, 2024

Yeah, it seems, it is excel behavior. I found below info on web. Not sure what would be hack here.

dhananjayk3480
dhananjayk3480AuthorAnswer
February 21, 2024

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.

    N
    navanathw4998
    April 24, 2024

    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. 

    dhananjayk3480
    dhananjayk3480Author
    April 24, 2024

    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.

    dhananjayk3480
    dhananjayk3480Author
    June 26, 2025

    Hey Folks
    Just adding the exact scenario

    When we use Export to Excel in record grid then we can do this manipulation. [emoticon:599cc6d89e2145289084ee73d7cb364b]
    When we use Export Data Store Entity to Excel Smart Service then this is not going to work. [emoticon:0e14ed90a91841f38d073b5240560352]

    Terms & ConditionsAccessibility statement