topic Re: Data Type Declaration - issue while downloading into excel in Application Development and Automation Discussions

Data Type Declaration - issue while downloading into excel

former_member225134 — Wed, 08 Mar 2017 09:37:53 GMT

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,

Re: Data Type Declaration - issue while downloading into excel

RaymondGiuseppi — Wed, 08 Mar 2017 12:46:26 GMT

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

Re: Data Type Declaration - issue while downloading into excel

Former Member — Wed, 08 Mar 2017 12:56:00 GMT

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

Re: Data Type Declaration - issue while downloading into excel

Sandra_Rossi — Wed, 08 Mar 2017 19:49:23 GMT

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