Skip to main content
dhananjayk3480
Inspiring
Feb 14, 2024 11:41 AM UTC
Solved

Export Data Store Entity to Excel -Negative number quoted.

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?


dhananjayk3480
Inspiring
Feb 21, 2024 2:03 PM UTC

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
Inspiring
Feb 14, 2024 11:46 AM UTC

Just correcting, not quotes its apostrophe.

dhananjayk3480
Inspiring
Feb 14, 2024 1:24 PM UTC

[mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05]  Any leads?

stefanhelzle0001
Brainy
Feb 14, 2024 1:34 PM UTC

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

dhananjayk3480
Inspiring
Feb 14, 2024 1:37 PM UTC

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

dhananjayk3480
dhananjayk3480AuthorAnswer
Inspiring
Feb 21, 2024 2:03 PM UTC

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.

New Participant
Apr 24, 2024 11:05 AM UTC

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
Inspiring
Apr 24, 2024 2:53 PM UTC

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
Inspiring
Jun 26, 2025 9:37 AM UTC

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]