Community
Application Development and Automation 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: 
Read only

Data Type Declaration - issue while downloading into excel

former_member225134
Participant

‎2017 Mar 08 9:37 AM

0 Likes
767

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
Read only

RaymondGiuseppi
Active Contributor

‎2017 Mar 08 12:46 PM

691

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

Read only

Sandra_Rossi
Active Contributor
In response to RaymondGiuseppi

‎2017 Mar 08 7:49 PM

0 Likes
691

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

Read only

Former Member

‎2017 Mar 08 12:56 PM

691

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!!