No mail for days?
> Date: Thu, 5 Jun 2008 16:08:38 -0400> To: [email protected]> From: [EMAIL > PROTECTED]> Subject: [RBASE-L] - Re: Print to XLS file> > At 03:58 PM > 6/5/2008, [EMAIL PROTECTED] wrote:> > >I have the following very simple code > :> >> >Print BOItemSales +> >OPTION XLS +> >|FILENAME .vfile +> > >|SHOW_CANCEL_DIALOG ON +> >|OPEN ON> >> >This creates an XLS file as > expected, but the spread sheet has 63 > >lines of data,> >then a new > sheet/tab, 63 lines of data, a new sheet/tab, etc., etc. The above> >creates > an xls file with 14 sheets(tabs) instead of 1 sheet/tab with all the> > >records.> >> >What do I need to change? I want the spread sheet to have all > the > >data on one sheet.> > Bob,> > That is the result of printing one sheet > (Tab) per page.> > Use the additional ONE_SHEET_PER_PAGE OFF option to > achieve your goal.> > Here's how:> > PRINT BOItemSales +> OPTION XLS +> > |FILENAME .vfile +> |ONE_SHEET_PER_PAGE OFF +> |SHOW_CANCEL_DIALOG ON +> > |OPEN ON> > That's all there is to it!> > For complete details, examples and > ready to recycle templates,> refer to R:Docs 7.6.> > Very Best R:egards,> > > Razzak.> > _________________________________________________________________ Die aktuelle Frühjahrsmode - Preise vergleichen bei MSN Shopping http://shopping.msn.de/category/damenbekleidung/bcatid66/forsale?text=category:damenbekleidung&edt=1&ptnrid=230
