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
Showing results for 
Search instead for 
Did you mean: 

Alv Grid download to xl sheet: Column position mismatching

Former Member
0 Kudos

Hi All,

As we know that while downloading the alv grid report data into xl sheet the date cloumn and might some other column positon get shifted to extreme right.

My problem is with five columns in my grid report that got shifted to extreme right while downloading to the xl sheet. They have the data type CURR and DEC. As both the types are basically packed.

I tried to convert one of them into character, but had short dumpfor this conversion.I

Please suggest me to resolve this issue. I shall be greatful to the valuable answer.

Note: My internal table fields order and fields order in fieldcatalog are same.

Thnaks in advance.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Answer is to convert it to CHAR .

Conversion error could you post..

Might be the size was not enough to accomodate the DEC/CURR value .

Or the field was not able to recognise the negative/positive signs .

Other option is to play with excel and manually convert all fields to Text by formatting the column in excel.

2 REPLIES 2

Former Member
0 Kudos

Answer is to convert it to CHAR .

Conversion error could you post..

Might be the size was not enough to accomodate the DEC/CURR value .

Or the field was not able to recognise the negative/positive signs .

Other option is to play with excel and manually convert all fields to Text by formatting the column in excel.

0 Kudos

make it left justified while bulding fieldcatalog