topic Problem with headline in excel in Application Development and Automation Discussions

Problem with headline in excel

Former Member — Sun, 08 Mar 2009 13:38:21 GMT

Hello experts,

I was created alv report , when i export this report to excel file , some of long headline that belong to alv report was to disappear from excel , meaning that was to appear only part of the each headline.

How can i to resolve this problem ?

Thanks for your help.

Avi.

Re: Problem with headline in excel

Former Member — Sun, 08 Mar 2009 14:15:30 GMT

Hi,

Did u tried with the

seltext_s

seltext_m

seltext_l

by giving all the values..............

try with increasing the field length of that material.

Regards,

venkatesh

Re: Problem with headline in excel

Former Member — Sun, 08 Mar 2009 14:22:38 GMT

I do this , when i translate the headline it is happen.

Re: Problem with headline in excel

Former Member — Mon, 09 Mar 2009 05:19:12 GMT

Hi Avi,

this problem is coming when you are creating your packing list.check this code

Creating the document to be sent

wa_doc_data-obj_name = text-043.

subject

wa_doc_data-obj_descr = p_subj.

i_contents-line = text-061.

APPEND i_contents.

i_contents-line = ' '.

APPEND i_contents.

i_contents-line = text-029.

APPEND i_contents.

DESCRIBE TABLE i_contents LINES v_tab_lines.

READ TABLE i_contents INDEX v_tab_lines.

IF sy-subrc EQ 0.

wa_doc_data-doc_size = ( v_tab_lines - 1 ) * 255 + STRLEN( i_contents ).

ENDIF.

Creating the entry for the compressed document

CLEAR i_packing_list-transf_bin.

i_packing_list-head_start = 1.

i_packing_list-head_num = 0.

i_packing_list-body_start = 1.

i_packing_list-body_num = v_tab_lines.

i_packing_list-doc_type = c_raw.

APPEND i_packing_list.

Thanks