Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Data Type Declaration - issue while downloading into excel

former_member225134
Participant

‎03-08-2017 9:37 AM

0 Kudos

Hi All,

Am using this field in report AUBFSTR-EKWRT curr 17..in alv report output

it is displayed as 249,999,999,999,999.75 . After that am downloading from alv report to

excel it is displaying as " 250,000,000,000,000.00"... Inside that program am writing

code for excel download and trigger in mail ,here am getting the value as 249,999,999,999,999.00 .

So what is the difference here it is downloading in different values..

How can i display the original value 249,999,999,999,999.75 in excel ...

Any suggestion please.

Regards,

3 REPLIES 3

raymond_giuseppi
Active Contributor

‎03-08-2017 12:46 PM

Those are limits of Excel usually Number precision is 15 digits for recent versions. Look at IEEE 754 and online documentation for your version)

Sandra_Rossi
Active Contributor
In response to raymond_giuseppi

‎03-08-2017 7:49 PM

0 Kudos

And also more general litterature about "maximum number of significant digits": https://en.wikipedia.org/wiki/Significant_figures

former_member391452
Explorer

‎03-08-2017 12:56 PM

Hi,

I think you are exceeding the numerical value that excel supports for a particular cell. If you delete some 9's from the number then you will see that the numbers are coming in proper format.

I have deleted some 9's from the number and tried with this number: 2499999999.75. The output was coming properly.

Hope it helps!!