Problem in down loading Grid out to Excel

[Former Member]

Hi all ,

when i down load grid output into excel using list->export->localfile ->spread sheet,

Some columns headings are down loaded with medium texts and some with short texts (seltext_s) .The same is displayed in default output(with out dragging) . I found that fields with short texts are because of field data length is less than 10 char .customer is asking to medium or long texts in excel when down loaded..

1)Hence i expanded fileds and then down loaded , same short texts are down loaded to XL.

2)I incresed output length for those fields so as to take medium or long texts in default output of report(no need of dragging ) and then down loaded to excel .Still it is taking short texts only in XL .

Will there be any default settings to consider text to considered while down loading or do ineed to set explicitley .Please advise me ..

a bit urgent .

I constructed fieldcat as follows

ls_fieldcat-fieldname = c_cname.

ls_fieldcat-seltext_l = text-004.

ls_fieldcat-seltext_s = text-004.

ls_fieldcat-seltext_m = text-004.

ls_fieldcat-reptext_ddic = text-004.

MODIFY p_fieldcat FROM ls_fieldcat TRANSPORTING seltext_l seltext_m

seltext_s reptext_ddic WHERE fieldname = ls_fieldcat-fieldname.

Many Thanks

Dharma P

[Former Member]

Hello Dharma,

it is a bit wierd situation.

to have a try , could you change your data type as char which are downloaded as short text.

and as another question do you use layout-colwidth optimization as 'X' in your code

Best regards,

[Former Member]

Hi A. Caglar Ozkor,

Basically the parmeter layout-colwidth optimization is set to 'X'. I tried out to increase outputlength after setting it to ' ' , then down loaded to excel .In that case also it picked only short texts , Hence I thought there would be some settings to decide what text to be picked while down loading in to excel .

Guys , Any ideas to solve this problem ...

Dharma P

[Former Member]

Hi Adding to above ..

Why customer wants medium and long texts is , when he run the report in different languges , the length of short text some times is more than 10 char . but when it is passed to seltext_s it takes only 10 char , hence column headings are incomplete (Truncated) .

I hope basic problem is clear .... Anticipating a good idea to crack this

Dharma P

[Former Member]

Hi again Dharma,

in your fiedlcat please insert last line and have a try.

gf_flcat-seltext_l = 'Material Code'.

gf_flcat-ddictxt = 'L'.

hope this helps.

Caglar