What’s New in Office 2010 for Developers?

1. OFC238 What’s New in Office 2010 for Developers? John R. Durant Senior Product Manager Microsoft Corporation

2. Session Objectives And Takeaways • Session Objective(s) • Learn how new features and tools tie together the Microsoft solution stack • Key Takeaways • Office is stable footing with investments in: • Server & Services Connectivity • Data-oriented development • Client Extensibility • Application Design

3. User and IT Demands User Needs • PC, Phone, & Browser experience • Broader use of line-of-business data • Reuse data & information IT Needs • Unlock IT investment Value • Do more with less • Adapt quickly to changing industry and business • Reduce developer complexity

4. Value-Driven Investments in 2010 • Evolved developer platform with new services and extensibility • Connected cloud and on-premises services to a common Office PC, phone and browser user experience • Developer tools for all skill-levels, from Access to VBA and Visual Studio

5. Office 2010 for developers • Server and Services connectivity • Line of business connectivity with BCS • Web Services & Standards-based interoperability • Integrate with hosted and on-premises SharePoint solutions • Evolved developer platform with new services and extensibility • Connected cloud and on-premises services to a common Office PC, phone and browser user experience • Developer tools for all skill-levels, from Access to VBA and Visual Studio • Data-oriented development • Open XML SDK • Word, Excel, Access, Project, Visio, InfoPath Services • Built on SharePoint Platform Services • Improved Office Development Experience • Fluent UI & Backstage Programmability • Easier management with Visual Studio 2010 & .NET 4.0 • Application Compatibility Program • Development tools for everyone • Simplified InfoPath design • Access applications published to Web • Access application usability/design improvements • Continued commitment to Visual Basic for Applications (VBA)

6. Software & Services Connectivity

7. Business Connectivity Services • Allows easy surfacing of external data into SharePoint list and Office client • On-line/Off-line aware • Read/Write data operations • Out-of-box connectivity to: • Word • Outlook • SharePoint Workspace • InfoPath • Customizable to work with other Office clients • Tooling in SharePoint Designer and Visual Studio 2010

8. External Content Types Describes the schema and data access capabilities of an external data source and its behavior within Office and SharePoint *formerly known as BDC Entity BCS External Content Type (ECT) External Data Source SharePoint (Thin) BCS

9. Business Connectivity Services Enhance SharePoint platform capabilities with out-of-box features, services and tools that streamline development of solutions with deep integration of External Data and Services.

10. Data-Oriented Development

11. Expanding on the Server • Multi-user co-authoring • Access Services • Word Services • Excel Services • InfoPath Services • Project Services • Visio Services

12. Access Services • Publish the application to SharePoint on premise or hosted • Throttled to allow logic to run in a hosted environment • Scalable • Secure (No signatures required)

13. Word Services • File | Save As on the server • Can read and write any format that desktop Word can read and write • Enables 100% fidelity server-side rendering • It is Word, so the output is the same – Right down to the last pixel • API for server-side automation • High-volume doc generation, conversion

14. Excel Services • New JavaScript Object Model • Capture user events • Ability to drive the UI • New REST API • Enables embedding of ranges and charts contained in a workbook on a web page • Changes in underlying workbook are automatically reflected when web page is (re-) loaded • Updated Web Services API • Adds support for edit mode, setting formulas • Ability to get charts

15. InfoPath and Forms Services • Create Forms for SharePoint Lists • Build modular, extensible, and portable SharePoint applications • More powerful Web browser forms • Connect forms with line-of-business information • Create forms with or without code

16. Improved Office Development Experience

17. Extensibility • Backstage view • Ribbon enhancements • Application programmability refinements • Application compatibility program

18. Backstage View • Shows you everything Office knows about your document • Shows you everything you can do with your document • Programmable like the Ribbon

19. Ribbon Customization • Add/Remove/Move Tabs • Add/Remove/Move Groups • Create custom groups with built-in or custom commands • “High-Density Layout” for custom groups • Save and load customizations from a file

20. Programmability Refinements • Outlook • OM consolidation continues • Navigation pane • PowerPoint • Media API • Excel • Sparklines • Slicers • Improved performance and scale (x64, multi-core) • New XLL SDK release • Asynchronous UDFs • Integration with High Performance Computing (HPC) clusters • OneNote • Enhanced import routine

21. Office 2010 Application CompatibilityServices, tools and guidance for Office 2010 migration • Tools • Visual Studio Code scanner, (VBA) Macro scanner, Office desktop add-in scanner, Office Migration Planning Manager updated • Guidance • Office deployment and migration guidance • Application Compatibility Analysis and Remediation Guide • Included in ORK and 2010 MDT • Programs • Office 2010 ISV Application Compatibility Visibility Program • DDPS Partner Services includes Office 2010Compatibility Competency • MCS – Deployment Optimization of Windows and Office (DOWO)

22. Development Tools for Everyone

23. Office 2010 Solution Design • Access application usability/design improvements • Access applications published to Web • Visual Studio 2010 • Open XML SDK • Simplified InfoPath design • Continued commitment to Visual Basic for Applications (VBA)

24. Access 2010 • Much easier to create small team applications • UI Macros (new!) complement Data Macros • Share information internal/external • Publish solution to SharePoint • Easier IT management • Expand your application’s reach

25. UI Macros • All about the UI • Respond to events on the form/controls • Drive application navigation • Can not touch data directly • Usable in a web context • For example, no Menu modification support • Translated to JavaScript

26. Visual Studio 2010 • All 2007 supported scenarios persist forward to 2010 • Improved C# experience • Improved deployment support in Office 2010 with Visual Studio 2010 • Package and deploy multiple add-ins • Platform solution building with SharePoint & Office

27. Deployment • Fewer pre-reqs to install • No need to deploy VSTOR for Office 2010 solutions • PIAs not required for .NET 4.0 solutions • Choose a target .NET Framework your users are most likely to have - 3.5 Full/Client or 4.0 Full/Client

28. Open XML SDK • Allows you to create and modify Open XML documents • SDK currently supports Office 2007 SP2 Open XML files • Based on .NET (C# and VB) • Compatible with LINQ • Provides a unified platform for solutions • Consistent client and server solutions • This SDK does NOT • Replace Office application Object Models • Perform layout + recalculation tasks • Perform file conversions to other formats, like PDF or XPS • The SDK will be released in two versions • Version 1: Part level manipulation • Version 2: Content level manipulation

29. Open XML SDK Tools • SDK provides the following tools • Open XML Diff • Class Explorer • Document Reflector • Open XML Diff • Compare differences in two Open XML files • Class Explorer • Allows developers to navigate Open XML standard as it relates to the SDK • Document Reflector • Automatically generates Open XML SDK code based on document

30. Open XML Power Tools • A set of 30+ cmdlets that create and modify Open XML documents • Removing comments, accepting tracked revisions, etc. • Supports the PowerShell piping architecture • Documents are piped from cmdlet to cmdlet as objects • Built on Open XML SDK • Available on CodePlex • http://www.codeplex.com

31. VSTO Power Tools • Open and edit Open XML documents directly in Visual Studio • http://www.microsoft.com/downloads/details.aspx?FamilyID=46B6BF86-E35D-4870-B214-4D7B72B02BF9

32. Killer Office 2010 Solution demo Key Advances

33. Summary • Paving the Road to Software & Services: • Server & Services Connectivity • Data-oriented development • Client Extensibility • Application Design • Join the “Office Developer Guild” community on Facebook-- Search for john.durant@microsoft.com Summary

34. Resources • Blogs • John Durant’s blog: http://blogs.msdn.com/johnrdurant • Brian Jones’ blog: http://blogs.msdn.com/brian_jones • Office Developer Guild • http://www.facebook.com/officedeveloperguild • MSDN • http://msdn.microsoft.com/office

35. Any questions? Want to share scenarios/solutions? Q&A

36. Remember to fill out your evaluations onMySPCfor your chance to win two HD web cams and a designer mouse (3 prizes awarded daily)

37. Learn More about SharePoint 2010 Information forIT Prosat TechNet http://MSSharePointITPro.com Information forDevelopersat MSDN http://MSSharePointDeveloper.com Information forEveryone • http://SharePoint.Microsoft.com

38. © 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.