Re: OWC11 Excel PrintArea

> Somewhere between OWC loading the template and saving the output, the
> print area reduces to all rows for columns a - e, with g & h printing on
> sperate pages...

that's what i mean, owc does not let you control printing options. I don't
know of a way to force this behavior to occur. instead, the printing
functionality defaults to whatever the hosting container (a browser) wants
to print.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"Ben" <ben@xxxxxxxxxxxxx> wrote in message
news:3463a$429f70c3$d8445835$25935@xxxxxxxxxxx
>I guess I'm not understanding the 'pringing functionality is the
>reponsibility of the hosting container' part of your response.
>
> Excel defines a Print Area on each work*** of a workbook: File -> Page
> Setup -> *** -> Print Area
> There is also, Rows to repeat at top and columns to repeat at left.
>
> These settings can be saved in a spread*** and persist just fine.
>
> Now, in my template say I've defined the print area as being all rows for
> columns a - h. Somewhere between OWC loading the template and saving the
> output, the print area reduces to all rows for columns a - e, with g & h
> printing on sperate pages...
>
>
> Does that make my problem clearer?
>
>
> "Alvin Bruney [MVP - ASP.NET]" <www.lulu.com/owc> wrote in message
> news:efCmrejZFHA.580@xxxxxxxxxxxxxxxxxxxxxxx
>> yes it is.
>>
>> to answer your question, printing functionality is the responsibility of
>> the hosting container. the owc does not offer support for this type of
>> functionality. currently, microsoft has released an approach (available
>> in the toolpack) that provides substantial printing control from the owc.
>> you may want to examine that strategy to see if it fits your need.
>>
>> --
>> Regards,
>> Alvin Bruney - ASP.NET MVP
>>
>> [Shameless Author Plug]
>> The Microsoft Office Web Components Black Book with .NET
>> Now available @ www.lulu.com/owc, Amazon.com etc
>> "Ben" <ben@xxxxxxxxxxxxx> wrote in message
>> news:de1ea$429c7208$d8445835$13790@xxxxxxxxxxx
>>> Is this group covered by the MSDN support?
>>> "Ben" <ben@xxxxxxxxxxxxx> wrote in message
>>> news:8d956$4295dd87$d8445835$21624@xxxxxxxxxxx
>>>> Hi,
>>>>
>>>> I am writing an ASP.NET application that is using OWC11. I have a
>>>> template file that I convert to an excel.xml spread*** for use as a
>>>> template to OWC11. In my template I have set a print area that repeats
>>>> as a header for each page of data. When I load the template and add
>>>> data to the spread*** and save it to a .xls file via OWC11, the
>>>> printarea is off. The selected header is still correct and repeating,
>>>> but instead of the printarea spanning columns 1-7 as it was supposed
>>>> to, it spans 1-5 and then 6-7. I look at the object browser and see
>>>> that there is a PrintArea defined inside PageSetup for the
>>>> WorkSheetClass, but I can't seem to access it programmatically.
>>>>
>>>> Can anyone tell me how to tweak my template or programmatically access
>>>> the PrintArea via OWC11? (If possible)
>>>>
>>>> Thanks,
>>>> Ben
>>>>
>>>
>>>
>>
>>
>
>


.