topic Problem in down loading Grid out to Excel in Application Development and Automation Discussions

Problem in down loading Grid out to Excel

Former Member — Wed, 22 Nov 2006 11:21:10 GMT

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

Re: Problem in down loading Grid out to Excel

Former Member — Wed, 22 Nov 2006 11:40:57 GMT

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,

Re: Problem in down loading Grid out to Excel

Former Member — Wed, 22 Nov 2006 12:14:03 GMT

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

Re: Problem in down loading Grid out to Excel

Former Member — Wed, 22 Nov 2006 12:22:21 GMT

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

Re: Problem in down loading Grid out to Excel

Former Member — Fri, 24 Nov 2006 07:06:54 GMT

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