Posts Tagged ‘Office’
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:
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.
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:
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:
Another pretty neat thing is the support for MVP in client web parts:
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
July 16th, 2012 by Tobias 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
- Download SharePoint Foundation 2013 preview
- Download SharePoint Foundation 2013 preview Language Packs
- Download SharePoint Server 2013 preview
- Download SharePoint Server 2013 Language Packs
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 :-)
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.
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!
April 28th, 2008 by Tobias Zimmergren
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 ;)
May 9th, 2007 by Tobias Zimmergren
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"
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 ;) )
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:
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 :)
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/.