ALV Report

[Former Member]

Hi Expert,

I am getting small boxes in the output of alv report, when I download this report in spreadsheet,These boxes are coming as # in excel,

even in debuger value is coming as # but in alv output it is coming as box.

Plese suggest how to remove these boxes from alv report.

Cheers

Akash

[roberto_vacca2]

Hi.

Probably you have to make some changes to your field-catalog structure.. for example changing numbers... usually numbers or any non-unicode chars are converted in "#" chars..

Try to show your field-catalog structure...

Hope to help, bye!

[Former Member]

Try to make longer the outputlen in the feildcat

[Former Member]

Hello,

After Execution when report executed in ALV format in SAP... in menu poartion extremely upper side of the screen on left.: Go to List -

---

> Export to -

---

> Spreadsheets. I will ask you to save. Save it on the desktop in the xml format.... As soon as you press the save button it will automatically open that file into the excel format.... now again save that file in save as format and select all that data in that file with ctrl+A and go towards lefte side of the shee and right click on it .. it will open a menu... now go to format cell and select the text portion in that and save it,. The data will display as you want to require it to be display. No zeros before any digits will be gone and also #s also not to be displyed.

Regards,

Akg

[Former Member]

Hi All,

Those boxes are because of TAb space,

How can I capture and remove those tab spaces in program.

Cheers

[kamesh_g]

spread sheet is tab separated only . i guess your characters not because of tabs .

1 . are you passing any special characters to alv out put field .

2. check all values are in SY-langu.

Edited by: KAMESH G on Jun 23, 2011 2:30 PM

[Former Member]

this was because off tab space.