Follow Me

Converting Office Documents to PDF with the Office Interop Assemblies

By Stefan Feenstra   /     May 21, 2014  /     Office, SharePoint 2010, SharePoint 2013  /     5 Comments

Converting Office Documents to PDF

If you want to convert a document to PDF you can save it as PDF (File -> Export -> PDF). But what if you have a lot of documents you want to convert to PDF. Then the Office Interop Assemblies could help you. This blog explains how you could use the Office Interop Assemblies to convert Word, PowerPoint and Excel files to PDF.

Prerequisites:
– Microsoft Office needs to be installed
– Some dev skills

This is not something you would like to use on a large production environment. But if you are in need of a onetime solution this could be a solution. Always keep in mind that you backup your Office documents and check the results after converting.

Continue reading “Converting Office Documents to PDF with the Office Interop Assemblies” »

Continue Reading

FIX: Version comments not saved in SharePoint 2013

By Stefan Feenstra   /     Nov 27, 2013  /     Office 365, SharePoint 2013  /     1 Comment

Yesterday Microsoft released an cumulative update for SharePoint 2013. This update fixes the issue with version comments that are not saved in SharePoint 2013. See my previous post: Version comments not saved in SharePoint 2013

Text from Microsoft (to reproduce):

Consider the following scenario:

  • You create a SharePoint Server 2013 document library that has the Versioning and Required Check Out features enabled.
  • You upload a document to the document library.
  • You check in the document and then leave a version comment.
  • You check the version history of the document.

In this situation, the version comment is blank.

Cumulative update for SharePoint 2013: KB2825647

http://support.microsoft.com/kb/2825647

Prerequisites: KB2767999

http://support.microsoft.com/kb/2767999

Continue Reading

Workaround: The “Save site as template” action is not supported on this site

By Stefan Feenstra   /     Nov 26, 2013  /     Office 365, SharePoint 2013  /     2 Comments

In SharePoint 2013 when you try to save a publishing site as sitetemplate you get the following error message “The “Save site as template” action is not supported on this site.”. When you try the same with a teamsite everything goes fine (Publishing features not activated).

Workaround for publishing sites:

  1. Open the site in SharePoint designer.
  2. Click on Site Options

  3. Change the “SaveSiteAsTemplateEnabled” property from ‘false’ to ‘true’

  4. Try again to save the site as a sitetemplate. The option is still not available on the sitesettings page but you can browse to: https://[URL TO SUBSITE]/_layouts/savetmpl.aspx

     

Continue Reading

Workaround: Version comments not saved in SharePoint 2013

By Stefan Feenstra   /     Oct 31, 2013  /     Office 365, SharePoint 2013  /     1 Comment

Today I found a workaround for the bug I reported a few weeks ago: “Version comments not saved in SharePoint 2013“.

When you have one content type available in the library the version comments cannot be saved when you upload a new file. If you have more than one content type available the version comments can be saved in SharePoint.

Steps to add a content type to the library

  1. Go to the “Library Settings”
  2. Click on “Advanced settings”
  3. Change “Allow management of content types” to: “Yes” and save the settings.

  4. On the “Library Settings” page click on Add from existing site content types.

  5. Add a content type to the library e.g. ‘Basic page’ and save it again.
  6. Now try again to upload the file. Select a file. Fill in the version comments and click on OK.
  7. Click on “Save”
  8. Now when you view the library you will see the version comments you entered at step 6.
Continue Reading

Bug: Version comments not saved in SharePoint 2013

By Stefan Feenstra   /     Sep 27, 2013  /     Office 365, SharePoint 2013  /     1 Comment

Yesterday I discovered a new bug in SharePoint 2013 and Office 365 (2013 experience). When you upload a file to SharePoint using the upload button in the ribbon you get a dialog where you can fill in some version comments. These version comments aren’t stored in SharePoint when you check in the file you uploaded.

Steps to reproduce: 

Make sure you have the same version settings as in the screenshot below.

Document library version settings

Go to your documentlibrary and click in the Ribbon on Upload Document.

Upload Document Ribbon button

You will get the following dialog. Select a file and fill in some version comments.

Upload dialog

Click on Ok and wait untill the file is uploaded to the server. Then the following dialog appears and click on Check in.

Metadata dialog

Now when you check the version history the version comments are missing.

Version history

 

When you follow the same steps in SharePoint 2010 the version comments are stored in the version history.

SP2010 - Step4

 

Some companies heavily rely on the version history and the comments that are submitted.

Update (31-10-2013): Workaround for this problem

Update (27-11-2013): Microsoft released a cumulative update to fix this problem

Continue Reading