Posts Tagged ‘Office’

Author: Tobias Zimmergren
http://www.zimmergren.net | http://www.tozit.com | @zimmergren

Introduction

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 :-)

office15

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.

Releasedates

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 :-)

Clients

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

Servers

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.

Summary

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
Url:
http://www.zimmergren.net 

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"
simpleexcelservices2

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

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.
simpleexcelservices4

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)
simpleexcelservices5

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.
simpleexcelservices6

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

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 ;) )

Cheers!

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 www.microsoft.com/downloads 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:
vstoribbonword1

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:
vstoribbonword2

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:
vstoribbonword3

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 ;)
vstoribbonword4

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:
vstoribbonword5

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, http://www.ontheofficecouch.com/.