Problem with headline in excel

[Former Member]

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.

[Former Member]

Hi,

Did u tried with the

seltext_s

seltext_m

seltext_l

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

or

try with increasing the field length of that material.

Regards,

venkatesh

[Former Member]

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

[Former Member]

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