Posts Tagged ‘Office’

Visual Studio 2013 March 2014 Update has been released

March 3rd, 2014 by Tobias Zimmergren

Today, Microsoft announced the release of Visual Studio 2013 March 2013 Update which have additional features, project types and support for some of the enhancements that comes with Office 2013 SP1 and Office 365. So if you’re a developer targeting Office 365, Office 2013 or SharePoint Server 2013 it may be a good idea to go grab the update and install it now.

SAP Data Source in your Cloud Business Application


As quoted from the Visual Studio blog:

The March 2014 Update also offers first class support for SAP Netweaver Gateway. When connecting CBA to SAP, it honors SAP annotations for Phone, WebAddress, and Email; speeding up your configuration of entities consumed from SAP Netweaver Gateway.

While this may seem like a trivial update, I know this is a popular requirement from a lot of my clients. I don’t think this is the last data source type we’ll see in the list of available types, which is ever growing:


Integrating new document features in your Cloud Business Applications

One of the cool features, which I lacked in one of my CBA projects in the past, is the integration of native controls for managing documents in a library that your CBA is connected to. With the latest update, you get the ability to create new documents in your library from the CBA interface.

When you attach your application to a SharePoint host-web document library, the application will be integrated with a set of new document controls, which allows your users to create new Office documents (either blank documents or from document templates that are available in the attached document library), open documents in Office Web App or Office client, and upload existing documents. All of these are provided by the tools without requiring any extra coding from you.

Picture from, as per the article mentioned in the introduction.

To add such a control and work with these types of controls, you simply have a new option here in the CBA Screen design interface:


Apps for Office Development enhancements

Some of the additions to the Office App development toolset are mentioned:

Office 2013 SP1 and Office 365 supports PowerPoint content apps, Access Web App content apps and allows your mail app to be activated in compose forms (i.e. when users are writing a new email message or creating a new appointment). Office Developer Tools for Visual Studio 2013 – March 2014 Update supports all of these new app types across the development cycle from project creation, manifest editing, programming, debugging to publish.

Apps for SharePoint Development enhancements

There’s some additions to the experiences for developers when creating SharePoint Apps.

With the latest release of the tools, we now can switch the App project to target Office 365 or target an on-premises installation of SharePoint. It’s a new property in the SharePoint project settings dialog:


The app for SharePoint tooling now allows you to target your app exclusively to SharePoint Online in Office 365, or target to an on-prem SharePoint Server 2013 (which can also run in SharePoint Online). Through a simple switch in the app for SharePoint project properties page, the tools will update the SharePoint version number and the SharePoint Client Components assembly references used in your project accordingly.

Another pretty neat thing is the support for MVP in client web parts:

To enhance the support with ASP.NET MVC web applications, we added MVC support for client web part pages in this update. If your app for SharePoint project is associated with an ASP.NET MVC application, when you add a client web part and choose to create a new part page in the client web part creation wizard, a client web part controller and a default view will be added, following the MVC pattern.

Wrap up

I’ve been trying these things out really quick now, and I must say the small but constant flow of enhancements and additions with the new update cadence for all Microsoft products is pretty impressive. Visual Studio 2013 hasn’t been around for that long, but we’re still seeing new updates being published frequently. It is easier than ever to keep up with new development techniques and tools, and no need for exhausting waiting periods.

Read the full story on MSDN Blogs: Announcing Office Developer Tools for Visual Studio 2013 – March 2014 Update

Author: Tobias Zimmergren | | @zimmergren


If you haven’t followed the trend today, you’ve most certainly missed out. The Office 2013 and SharePoint 2013 preview versions were released to the wild today. Steve Ballmer did a LIVE pressrelease where he revealed that the new versions of Office and SharePoint are now officially available for public beta consumption. This is pretty amazing news, so I’ll just leave you with the following information and links and you can be certain that I’ll update this blog regularly with content of SharePoint 2013 awesomeness from this day forth :-)


Download the SharePoint 2013 preview binaries

You can find some of the relevant downloads right here:

SharePoint 2013 binaries

SharePoint Designer 2013 binaries


SharePoint Server 2013 SDKs


Microsoft Office Web Apps Server 2013


Duet Enterprise for SharePoint 2013 and SAP 2.0


Enjoy – and see you on the other side :-)

Microsoft Office Systems 2007 – Service Pack 2

November 16th, 2008 by Tobias Zimmergren

Recent announcements around the blog-o-sphere and the announcements at TechEd in Barcelona indicated that the SP2 for Office Systems 2007 is on it’s way.


Don’t even bother to try to get an exact date for your upgrade. As it is said today, the SP2 for Microsoft Office Systems 2007 will be released somewhere between February and April 2009.
If you are to take SP2 into consideration, I would go for the latter timescope (April/May) to be sure :-)


As announced by the Office Service Pack Team:

Improved Outlook Calendaring Reliability

Improved Outlook Performance

Enabling Object Model support for Charts in PowerPoint and Word

Improved cryptographic functionality by supporting all cryptographic algorithms offered by the operating system

Improved functionality in Excel’s charting mechanism

Ability to ungroup SmartArt graphics (and as a result, the ability to add animations to them in PowerPoint)

Ability for Visio to export UML models to an XML file compliant with the XMI standard

Tool that enables the uninstall of Office client Service Packs


As per the Microsoft SharePoint Team Blog, the following parts are some of the SharePoint-related things that will be taken care of:

Improved Read-only Content Databases
Whenever a content database is marked read-only, all of the site collections in that database are automatically marked as read-only. 

ECM Performance and Manageability Improvements
Improved performance and manageability in variations, including STSADM commands for repairing links between source and target pages.

Improved Index Rebuild Timer Jobs
SharePoint content databases running in SQL Server 2005 will undergo an automatic index rebuild, which helps stop defragmentation, and stop the database from degrading in performance.

Upgrade Checker
This will scan your SharePoint farm in advance of applying SP2 and will provide feedback on the environments readiness to upgrade.


I do hope to see some more in-depth details as to what exact improvements are being made regarding the read-only content databases!

Regarding the Upgrade Checker, I think it’s something that should have existed for every SP and KB/Patch you install. Kind of like the “Windows Vista Upgrade Advisor”, but for SharePoint!

More info will be published about SP2 when it’s announced, stay tuned!

Office Labs site launched – I urge you to check it out!

April 28th, 2008 by Tobias Zimmergren

All I can say is, go check out "Office Labs" for yourself (click here).

And by the way, DO check out the "Community Clips" section. It’s awesome.

That’s all I had for now, back to coding some enhancements on the Forum WebPart which is coming along nicely… Just wish one had more time ;)

Author: Tobias Zimmergren

In this post I will briefly describe how you can connect your excel spreadsheet to a SharePoint list using Excel Services.
I will not go into any details as to what Excel Services is, how you get it online or what the great uses are. I will simply step you through the process of creating a spreadsheet and publish it in a document library and be able to open it in your browser.

For any theory on Excel Services, consult any of the hundreds of blogs out there that is talking about it.

Now, let’s get started…

First, I created a Document Library called "Excel Documents"
simpleexcelservices0 simpleexcelservices1

Secondly, you need to make sure that SharePoint has a trusted file location to use. To set a trusted

file location, go to Central administration and then your SSP admin-page.
Choose "Trusted File Locations"

Create your Trusted File Location (I chose to use my default website as a trusted file location for this demo)

Next, fire up Excel 2007 by either opening an existing excel document or create a new one. I chose to create a new one for demonstration purpose.
Fill in some sample-data, if you decided to create a new one.

When your Excel spreadsheet is complete, choose to publish it by choosing the Office button -> Publish -> Excel Services and then fill in the URL to the document library where you want to save your Excel spreadsheet (for instance, in your newly created doclib)

When it’s published the file will open in your browser.. Close that window and go to your Document Library and choose Settings -> Document Library Settings -> Advanced settings. Make sure the "Browse-enabled Documents" is set to "Display as a webpage" in order to open the Spreadsheets in your browser instead of Excel.

Now when you click your excel spreadsheet in your Document Library, it will look like this:

Now wasn’t that simple? This was just a very simple scratch on the surface, leave a comment if you want a deep-dive into Excel Services (So I know it’ll be worth my time to blog about it ;) )


Zimmergren VSTO Tip #1: Extend the Ribbon-menu in Word 2007

April 18th, 2007 by Tobias Zimmergren

In this Visual Studio Tools for Office I will walk you through how to make a very simple customization to the Word 2007 (or any of these: Visio, PowerPoint, InfoPath, Outlook or Excel) Ribbon-menu and add our own button with some code to execute when it’s pressed.

Basically, what you need to do before doing anything else is to install and configure the VSTO add-in for Visual Studio. Just search for it and you will find it.

Once the prerequisites are installed, we will create a new project and choose the Word-template as seen in this screenshot:

What we do next before doing anything else, is the following: Right-click your project in the Solution Explorer, choose "Add" -> "New Item…" and choose the Ribbon component, as seen in the following Screenshot:

Once that’s done. Uncomment the commented code in the new Ribbon1.cs (or whatever you chose to call it).

Basically, everything’s done now. All we need to do is add some buttons or any other controls we would like to add in order to extend the Ribbon-menu.
In the following screenshot I’ve done only minor modifications to the labels and text and I havn’t added any other controls, to keep it simple:

Note: I’m defining a method to be executed when the button is toggeled with this xml: onAction="OnToggleButton1"

The following code shows a simple method that’s implemented by default with some minor modifications to insert my signature when the button is toggeled (Best practice would be to use the button control, not the toggleButton.. I just chose to do it this way because I couldn’t care less to change the default ;)

We’re done for now.
Execute the project and you’ll see the following screen with the option to press a toggleButton that will insert my very basic signature into the document:

What I wanted to show with this blogpost was simply the fact that it’s quite easy to extend the Ribbon to enable the use of your own custom code. The possibilites are almost endless since you get access to the entire .NET Framework via the code and can do basically whatever you want.
You can also integrate the menu with SharePoint via the Microsoft.SharePoint namespace, however if you’re going to communicate with the SharePoint API I would suggest making a WebService with the required methods and host it on the SharePoint-machine and then call the WebService from your clients.

Note: In order for this to work on the client machines, I think you need to install the VSTO on them aswell (Note, a full installation of the Office-suite will enable this feature if I’m not mistaken). The clients will also need the .NET Framework installed.

That’s it for now. I hope someone could enjoy this simple VSTO Tip :)

Cheers people!

I am Outlook 2007! Try the quiz :)

February 13th, 2007 by Tobias Zimmergren

Apparently I am Outlook 2007 according to this fun little quiz :)

"Connecting with people is the key to your happiness and success. Your outgoing, action-oriented personality is something everyone who knows you can count on. You have the information at your fingertips – whether it is a date or a keyword, you can always come up with it. You are the social chairperson among your friends, and people seek you out for the party details, the latest hot spot or celebrity gossip. Your color-coded to-do lists are legendary, and your calendars are masterpieces. You make it look so easy to manage multiple priorities; multi-tasking could be your middle name. With the new Microsoft Office Outlook 2007, it will be easy to manage and share all your vital information from one place. With your positive outlook, you will be thrilled to know that others can enjoy the same increased collaboration and functionality. Your favorite new feature Office 2007 will no doubt be the RSS reader in Outlook 2007. "

Check the quiz out,