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: 

Problem in Exporting report content to spreadsheet.

Former Member

‎2009 Sep 12 6:59 AM

0 Kudos
335

Hi,

When exporting report output to spreadsheet, the currency and quantity values are not getting exported properly.

For example : in report MB51 after getting the output, from menu-> list->export->spreadsheet->all available formats->Microsoft excel (in existing XXL Format)->table.

This is happening in Office 2007 only. And when i try to export the data to local file->spreadsheet, this problem is not there.

Do i need to do any settings in MS office excel or SAP GUI.

Plz suggest.

Thanks

Pradeep

2 REPLIES 2

rvinod1982
Contributor

‎2009 Sep 12 7:18 AM

0 Kudos
111

Hi Pradeep,

I am also using Office 2007. But when I export to spredsheet in XXL format the values are displayed properly.

You can try be enabling the Macros. Also check these snotes

972579 - XXL: In Office 2007 it's not possible to set range "DAT1"

1094693 - Blank/Empty Excel spreadsheet using Office 2007 and ALV

Regards,

Vinod

Former Member

‎2009 Sep 14 7:18 AM

0 Kudos
111

Hi Vinod,

I have gone thru the notes mentioned by you, but did not work for me.

: symbol is being displayed, for ex: 1090:96

As i have already mentioned that i am not getting the error when i export the data to local file->spreadsheet.

Thanks

pradeep