topic Re: EXCEL FILE PRINT ISSUE in Application Development and Automation Discussions

EXCEL FILE PRINT ISSUE

arpit_rai — Fri, 09 May 2014 09:15:36 GMT

Hi All ,

I have a small issue with a ABAP Report which I think might be a simple issue only .In my case I have a CLASSICAL report the report has 16 Columns and 14 Rows , I download it to a EXCEL FILE the excel file also has all the data and then go for LANDSCAPE printing on A4 PAPER .Now the problem is this that though the page has sufficient space left at the right end corner but still the data is being printed on the next page ie the first page has 14 columns and second page has last two rows displayed in the left side corner .

I also noticed that the report gets printed till the 255 characters for the columns and more than 255 characters are being printed on the next page as remaining two columns .

I came to know about creating new Print formats for printing on A4 paper but I want to confirm whether it’s a kind of Programming issue or not .

Any suggestions are highly welcome .

Thanks & Regards ,

Arpit Kr. Rai

Re: EXCEL FILE PRINT ISSUE

NagaPrakashT — Fri, 09 May 2014 09:22:03 GMT

Hi Arpit,

By default the print specifications is defalut to 'X_65_80'. You can change it with other formats like X_65_255 and print again.

Regards,

Naga

Re: EXCEL FILE PRINT ISSUE

Former Member — Fri, 09 May 2014 09:29:25 GMT

Hi Arpit,

In abap you can manipulate the line number of chars. Then you can print it to a layout that could move last line characters to a second line. That's not your case, so your report is ok.

You're controlling the print layout of a list saved to a file in Excel. That is not at all related to the report, the size of the columns in excel and the margins of the page in Excel will determine how many columns will be printed in each page, and that can be manipulated in Excel only.

regards,

Edgar

Re: EXCEL FILE PRINT ISSUE

arpit_rai — Fri, 09 May 2014 09:30:56 GMT

Hi Naga ,

Thanks for the quick reply .So according to you its just the Printer Settings , nothing to do with ABAP ?

Thanks & Regards ,

Arpit

Re: EXCEL FILE PRINT ISSUE

arpit_rai — Fri, 09 May 2014 09:33:11 GMT

Hi Edgar ,

Okay , got it Thanks so much for the reply . Let us just test the reports print out after some manipulation then I will definitely post the outcome .

Thanks & Regards ,

Arpit