Enhancements OWC 11 vs. OWC 10

[hglamy]

Hello,

I just received the Office 2003 Beta and tested
the OWC 11 spreadsheet control.

So far, I could not discover any noticeable
changes or improvements as compared to OWC 10.

Does anybody have other experiences or knows
more about it ?

Kind regards,

H.G. Lamy

 

[Dan Ricker]

Security and stability. If we did nothing else, a lot of
time was taken this release to ensure that this set of
Active X controls was secure. OWC10 was fairly solid but
we went back and took a closer look at anything that could
be used as an exploit and if there was any doubt we closed
the hole. In doing so we also did a lot of work to make
sure that the code we have is stable and robust -- why add
new features when you can make the existing one more
stable?

Better support for .NET programming. 2003 includes
primary Interop assemblies in the box for all of your
programming needs be it VB.Net or C#. OWC is still COM
based but these Office "blessed" IA should make for an
easier time when programming (VS.Net 2003 is recommended
for the best experience).

Better support for JScript. JScript Arrays are better
handled in Chart and Pivot and should now put it on par
with VBScript support as seen in OWC10.

More ways to connect to data in Spreadsheet, Chart, and
PivotTable List. All components can now connect to
Microsoft Business Solutions data sources along with using
a data provider service to connect to Windows SharePoint
Services (WSS) lists or SQL data sources.

Office PivotTable List
Analysis Server 2000 SP3 client bits (PTS) ship in the box
for greater security and stability.
Better support for keyboard navigation and usability,
especially in IE. Tip: Use Shift+Control+f to add a
calculated total.
Richer event processing.

Office Chart
Programmable scroll view. Great for zooming in on a
specific aspect of a chart and BI analysis. See the
ChScrollView object.
Programmable custom formatting to allow for user defined
data markers in bar and column charts. See the
ChChartDraw.OverrideDefaultElementFormatting method.
Programmable chart selection to allow for multiple
selection.

Office Spreadsheet
Better data binding support. In addition to the more data
sources that all the controls can use you can now data
bind the spreadsheet to XML files and SOAP web services.
Excel style data validation.
Web Part interface connections. Using the WSS web part
framework you can connect the spreadsheet to other web
parts. The interfaces include , IFilterConsumer,
IParametersOutProvider, IParametersOutConsumer,
IRowProvider, and IRowConsumer.

 

[hglamy]

Thank you Dan, for the comprehensive answer !

What about the Licence / EULA ?
That seemed rather restrictive in the past.
(maybe a reason why the components have
rarely been seen in public).

Can you use OWCs on a web site in the future
without breaking the rules ?

Regards,

H.G. Lamy

 

[Alvin Bruney]

ah but did microsoft spend money where it really mattered? providing
documentation, code samples, object modules, code snippets so that we
wouldn't have to go figure it out by ourselves. i'm sure M$ notices the
constant gripes about documentation.

 

[Dan Ricker]

''' *******
OM - There is a VBA Help file. Just like any other activeX
control I want to learn about, I place the control in an
environment suitable for learning such as VB6 or and
Office VBA project. I then get "F1" access to the controls
help documentation if it is there.

''' ********
Extra Samples in the OWC XP Toolpack:
http://www.microsoft.com/downloads/details.aspx?
FamilyId=BEB5D477-2100-4586-A13C-50E56F101720


''' ********
More Samples and Information:
http://search.office.microsoft.com/result.aspx?qu=Web%
20Components


Thx
Dan

 

[Avi Perez]

Any improvements in printing? ...or added image formats like SVG?

Charts in particular do not print well unless they have perfectly horizontal
or vertical lines!!!!

 

[SandyG]

I'm using OWC10 and creating graphs at the server and exporting them
to GIFS for my users on our intranet site. My only problem is I want
to draw some lines on the chart after it is rendered. It seems that
rendering events aren't recognized at the server side like they are
on the client. Do you know if this is true? If so, have they added
it to OWC11?



Sandy





Originally posted by Dan Ricker

Security and stability. If we did nothing else, a lot of

time was taken this release to ensure that this set of

Active X controls was secure. OWC10 was fairly solid but

we went back and took a closer look at anything that could

be used as an exploit and if there was any doubt we closed

the hole. In doing so we also did a lot of work to make

sure that the code we have is stable and robust -- why add

new features when you can make the existing one more


Better support for .NET programming. 2003 includes

primary Interop assemblies in the box for all of your

programming needs be it VB.Net or C#. OWC is still COM

based but these Office "blessed" IA should make for an

easier time when programming (VS.Net 2003 is recommended

for the best experience).

Better support for JScript. JScript Arrays are better

handled in Chart and Pivot and should now put it on par

with VBScript support as seen in OWC10.

More ways to connect to data in Spreadsheet, Chart, and

PivotTable List. All components can now connect to

Microsoft Business Solutions data sources along with using

a data provider service to connect to Windows SharePoint

Services (WSS) lists or SQL data sources.

Office PivotTable List

Analysis Server 2000 SP3 client bits (PTS) ship in the box

for greater security and stability.

Better support for keyboard navigation and usability,

especially in IE. Tip: Use Shift+Control+f to add a

calculated total.

Richer event processing.

Office Chart

Programmable scroll view. Great for zooming in on a

specific aspect of a chart and BI analysis. See the

ChScrollView object.

Programmable custom formatting to allow for user defined

data markers in bar and column charts. See the

ChChartDraw.OverrideDefaultElementFormatting method.

Programmable chart selection to allow for multiple


Office Spreadsheet

Better data binding support. In addition to the more data

sources that all the controls can use you can now data

bind the spreadsheet to XML files and SOAP web services.

Excel style data validation.

Web Part interface connections. Using the WSS web part

framework you can connect the spreadsheet to other web

parts. The interfaces include , IFilterConsumer,

IParametersOutProvider, IParametersOutConsumer,