Re: OWC11 Excel PrintArea

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 worksheet of a workbook: File -> Page
Setup -> Sheet -> Print Area
There is also, Rows to repeat at top and columns to repeat at left.

These settings can be saved in a spreadsheet 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 spreadsheet 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 spreadsheet 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
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: Enable/Disable Toolbar button
    ... Changing the state of a toolbar button effectively makes the global template ... and I can slip the 'proper' functionality in under one of them. ... the WindowSelectionChange event won't fire. ... Private Sub Document_Open ...
    (microsoft.public.word.vba.general)
  • Re: Enable/Disable Toolbar button
    ... On dirtying the template: ... and I can slip the 'proper' functionality in under one of them. ... You may have several buttons with the same .ID and .Tag ... Private Sub Document_Open ...
    (microsoft.public.word.vba.general)
  • Re: Visio 2003 Template Problem
    ... used to open up with a "drawing" that I could use and manipulate. ... Do you have any idea how I can get the drawing functionality back instead of ... the only purpose of a template but they can just provide a blank ... Now I did a 3rd install and damn the same blank template. ...
    (microsoft.public.visio.general)
  • RE: macro problems
    ... Templates in the Startup folder load when Word starts and typically provide additional functionality to Word. ... Many third parties utilize a global template in order to integrate their application in Word. ... if the macros are disabled then you aren't getting the additional functionality anyway. ...
    (microsoft.public.office.misc)
  • Re: outside of print area
    ... time of printing I get an error saying the print is outside the print area ... I don't have problems printing any other document type. ... which are determined by styles in the Normal.dot template. ...
    (microsoft.public.word.application.errors)