OWC Spreadsheet Workbook/ worksheet options

[Stephen Farmer]

Is there a way to set the workbook / worksheet options that would not be
overwritten by the default OWC settings when it is loaded?

 

[Alvin Bruney [MVP - ASP.NET]]

This issue can occur when XML is used in a load. Simply call a routine after
the load to store the spreadsheet values.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc

 

[Stephen Farmer]

Actually, what I'm trying to accomplish is setting the print options so that
when a user exports the data to excel the print format option in the
original input xml are exported to Excel. I've had to capture the press of
the export button in the OWC and add the worksheet options to the OWC XML
then stream it out to the client. I was hopin for a solution that would
allow for setting the options in the OWC and keeping not having to perform
the export override.

Thanks for the input

This issue can occur when XML is used in a load. Simply call a routine
after the load to store the spreadsheet values.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc

Is there a way to set the workbook / worksheet options that would not be
overwritten by the default OWC settings when it is loaded?

 

[Andy Tischaefer [MSFT]]

No, there is definitely no way to do this in the OWC. Printing of OWC is
driven by the browser or containing application, which means that OWC itself
does not support or persist printing information like Excel does.

The way you are doing it is probably the smartest way to go about it, I
would stick with that.

- Andy Tischaefer
Test Lead, Microsoft Office

This posting is provided as is, and confers no rights.

Actually, what I'm trying to accomplish is setting the print options so
that when a user exports the data to excel the print format option in the
original input xml are exported to Excel. I've had to capture the press of
the export button in the OWC and add the worksheet options to the OWC XML
then stream it out to the client. I was hopin for a solution that would
allow for setting the options in the OWC and keeping not having to perform
the export override.

Thanks for the input

This issue can occur when XML is used in a load. Simply call a routine
after the load to store the spreadsheet values.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc

Is there a way to set the workbook / worksheet options that would not be
overwritten by the default OWC settings when it is loaded?