06-22-2011 3:30 PM
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
06-22-2011 6:06 PM
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!
06-22-2011 8:23 PM
06-23-2011 6:43 AM
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
06-23-2011 12:22 PM
Hi All,
Those boxes are because of TAb space,
How can I capture and remove those tab spaces in program.
Cheers
06-23-2011 1:30 PM
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
08-09-2011 5:40 PM