Print Page - Form feed

Title: Form feed
Post by: Andy on October 06, 2013, 03:04:51 AM

Hi,

Sorry, I can't find this answer in the forum - I'm sure there's a simple answer to it.

I'm sending some output to a file "Printfile" and excel opens the file to view the output.

WRITE Printfile,"something"

If I wanted to insert a page break after the above line what do I use?

WRITE Printfile, ??

Thanks,
Andy.

Title: Re: Form feed
Post by: Brian on October 06, 2013, 09:18:02 AM

I think it is 0xC

Brian

Title: Re: Form feed
Post by: Andy on October 07, 2013, 11:38:10 PM

Thanks Brian,

That looks right according to the Internet, but now I have to find a way to send it to the file.

At the moment it's just displaying the value in Excel rather than forcing a page break.

tried:
WRITE Printfile," 0xC" and WRITE Printfile, 0xC ?

Thanks,
Andy.

Title: Re: Form feed
Post by: Brian on October 09, 2013, 01:37:20 PM

Andy, try:

WRITE PrintFile,"\x0C"

Brian

Title: Re: Form feed
Post by: Andy on October 10, 2013, 12:46:13 AM

Thanks Brian for all your help.

It seems it cannot be done (in excel), so I think I will have to do it the old way i.e. count the number of lines being printed to the page.

Anyway,
thanks again,

Andy.

Title: Re: Form feed
Post by: billhsln on October 10, 2013, 04:50:28 AM

Check out the 'Conditional Page Breaks' section.

www.technosamrat.com/tips-tricks/some-useful-tips-for-excel-conditionally-formatting-rows-page-breaks-more/

This might do what you are looking for.

Bill

Title: Re: Form feed
Post by: Andy on October 18, 2013, 12:45:06 AM

Sorry for the late reply,

Thanks, yes will have a look at it.

Thanks again,
Andy.

IonicWind Software

IWBasic => General Questions => Topic started by: Andy on October 06, 2013, 03:04:51 AM