Skip to Content
avatar image
Former Member

ALV report export error

When I am exporting the data from an ALV report to excel, date 17:07:2009 is displaying as "0.736446759" and 21:07:2009 as "0.903113426" in excel file.

If anybody has faced such problem, please help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 28, 2010 at 11:32 AM

    Hi,

    Just want to know the data type of these 2 fields in the internal table.

    If it is not char convert into char type field and then download.

    With Regards,

    Sumodh.P

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Char type is same for all the dates.But in report say out of 100 dates only 2 or 3 dates, it is showing wrong.Also if instead of excel if I export the data in some other format, Same dates are apperaing correct.

  • Jun 29, 2010 at 09:36 AM

    Read: Happy reporting with Excel III: There and back and especially two previous parts (about "printing" Excels/ output)

    /people/otto.gold/blog/2010/06/23/happy-reporting-with-excel-iii-there-and-back

    Otto

    Add comment
    10|10000 characters needed characters exceeded