Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

EXCEL FILE PRINT ISSUE

arpit_rai
Discoverer

‎2014 May 09 10:15 AM

0 Likes
1,227

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

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

Reply
4 REPLIES 4
Read only

NagaPrakashT
Contributor

‎2014 May 09 10:22 AM

0 Likes
1,078

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

Read only

arpit_rai
Discoverer
In response to NagaPrakashT

‎2014 May 09 10:30 AM

0 Likes
1,078

Hi Naga ,

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

Thanks & Regards ,

Arpit

Read only

Former Member

‎2014 May 09 10:29 AM

0 Likes
1,078

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

Read only

arpit_rai
Discoverer
In response to Former Member

‎2014 May 09 10:33 AM

0 Likes
1,078

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