Office Developer Tools for Visual Studio 2013 – March 2014 Update

Office Developer Tools for Visual Studio 2013 – March 2014 Update

Rate This
  • Comments 39

Today at SharePoint Conference 2014, the Office Developer Tools for Visual Studio 2013 – March 2014 Update was made available to download. This update contains a ton of new features that improves support for Office 365 Cloud Business Apps and LightSwitch projects as well as apps for Office & SharePoint in Visual Studio 2013.

Read the announcement on the Visual Studio Team Blog.

Download the Office Developer Tools for Visual Studio 2013 – March 2014 Update.

This update builds upon the Visual Studio 2013 release and all the great LightSwitch features you already have to build cross-browser, mobile-first HTML5 apps that you can optionally publish to a SharePoint 2013 app catalog. There are many more features in this update that I think LightSwitch developers will enjoy. Besides design-time performance improvements and bug fixes there are some new features I’d like to specifically call out.

Attaching to Enterprise Data

In addition to attaching to databases, SharePoint, OData Services and WCF RIA Services, this update also offers first class support for SAP Netweaver Gateway. When connecting to SAP, it honors SAP annotations for Phone, WebAddress, and Email; speeding up the configuration of entities consumed from SAP Netweaver Gateway.


Whether you’re building a LightSwitch application or Cloud Business App, you’ll notice that the Attach Data Source Wizard has been updated to handle much larger data sources and schemas. You now have the ability to search for specific entities and discover their relationship to other entities before you select them, as well as browse the data. We also now support complex data types.

The data designer has also been updated to handle these larger schemas and draw more efficiently. You’ll also notice little things like multi-select of data fields in an entity so you can set properties across them all, as well as sorting them.

Improved HTML Controls & “Common Screen Set” Template

When you build screens from your data model, we set you up with smart defaults on controls depending on the data types of fields. In this release we’ve improved our most used controls as well as provided a new Common Screen Set template that will create and wire up all the screens necessary to Browse & Search, Update, and View data. This speeds up the design and development of your apps. You can also now organize these screens into sub-folders in the Solution Explorer.


You’ll enjoy improvements to the Table control, which now supports sorting out of the box, the Picker control, which now supports auto-complete, as well as Summary properties which now associate themselves with the right controls corresponding to the data type.


Bookmarking and Improved “Edit & Refresh”

Often users want to bookmark a page in your application so they can get back to the data directly later. In this release, we’ve updated the screen URLs to make it easy for bookmarking right out of the box, without requiring you write code. Users can bookmark a page, or pin a page to the start screen on their mobile device, and always get back to that page in the application. The icon used is your application’s user-logo (in the Content folder of the client).


As a fallout of this, we now have improved “Edit & Refresh” for quick screen development. You can run your app and make changes to any of the screens or JavaScript files and simply refresh your browser to see the changes. However, you used to have to drill into the particular data screens to see those screen updates. In this release, when you make a change to the client code or screens and refresh your browser, the browser will automatically navigate back to the exact screen you were viewing.

Integrating Document Libraries

Documents are critical pieces of information in many business applications. That’s why we added controls in this release for integrating with SharePoint document libraries for SharePoint-enabled LightSwitch and Cloud Business Apps.

This allows users to create new Office documents (either blank documents or from document templates that are available in the attached document library), open documents in the corresponding Office Web App or Office client (if installed), and upload existing documents. All of this is provided without requiring you to write code.


Download the Free Update & Learn More!

What are you waiting for? This is a free update for Visual Studio 2013 and we know you’ll love it. Just click on the link to kick off the Web Platform Installer:

Download the Office Developer Tools for Visual Studio 2013 – March 2014 Update

Also check out my unscripted “How Do I…?” instructional video series I started on Channel 9 on building Cloud Business Apps. This is just a start, I plan on releasing more in the coming weeks.

Cloud Business Apps “How Do I…?” videos on Channel 9

The team also has a full pipeline of blog posts in the hopper that will drill into the details of all these features and more, so stay tuned! In the meantime, check out our updated documentation. And if you have questions or need help troubleshooting please visit the Visual Studio LightSwitch forum.


-Beth Massi, Visual Studio Community

Leave a Comment
  • Please add 3 and 1 and type the answer here:
  • Post
  • Thanks LS team...some really nice stuff here.

  • Like!!!

  • Excellent. But how do I upgrade an existing LS solution?

  • @Yannick -- if you have an existing LightSwitch or Cloud Business App solution you built with VS2013, then right-click on the project in Solution Explorer and select "Upgrade" to get the new features in this release. Once you upgrade, all the developers on your team will need the tools installed so keep that in mind. That's why we didn't force it.



  • Great but the logout button is removed when navigating to homescreen from another screen.

  • Great news, thanks LS Team!

    Is VS2013 Update 2 CTP 2 required for this March update?

  • Found it! Thanks Beth.

    Could you elaborate on how the new Search function works for the browse screen? Search results seem limited as it doesn't find text that's from a linked table's summary field nor from integer fields.

    Also I'm curious to know if we can keep the search bar visible instead of having to click the command bar button.

  • After installing it, I can't open any of my LS solutions! "The specified default content type (Default) is not defined in the project item schema."

    I install it through the link on top of the article, not by updating my project as I read (later) on the comments from Beth.

  • @Sven - You're right. We've logged a bug.

    @Yannick - you can create your own search screens by creating a query with a parameter and then adding a browse screen for the query. You can then drag the search parameters onto the screen and they will be visible always. See this article:

    @Xander - No, you do not need Update 2

    @FrancoisM - Do you have a non-English version of Visual Studio by chance? If so, you'll need to install the corresponding language pack. You have to re-run the WebPI feed and change the language – which is at the bottom of the options dialog. If you're still having trouble, please report the details of your environment in the forums so we can troubleshoot there:

  • Tks Beth.

    Well actually my VS2013 is in English (easier to find help on the net then :-)) but WePI installed the update in French. That maybe the problem from what you say. I'll uninstall and re-install in English and will let you know.

  • Solutions launched properly, tks for the help Beth!

  • @FrancoisM: That is probably it. The WebPI defaults to your OS/Browser Language (which I am guessing is French). Should work if you install English on English (or French on French for that matter).

  • @yannick - To keep the search bar always visible for a visual collection, set its enableSearch property as true in the screen created method.

    In the code below Orders is the visual collection and BrowseOrders is the screen

    myapp.BrowseOrders.created = function (screen) {

       // Write code here.

       screen.Orders.enableSearch = true;


  • @Rohit_Agrawal Thanks that's what I meant. Strange thing though is that when you refresh the page it disappears again...

    Is there also a way to customize it so it will search Integer fields?

    Also can we customize the Placeholder text?

    @Beth I was aware of the old search functionality but just curious what the power of the new "built-in" search is.

  • @yannick - search bar not showing up after refreshing the page can be fixed by replacing "screen.Orders.enableSearch = true;" with "screen.Orders.showSearch();" in the screen created method.

    You can set the search bar placeholder text by writing following code in the postRender method of the collection control.

    myapp.BrowseOrders.Orders_postRender = function (element, contentItem) {

       // Write code here.

       $(element).find("input").attr("placeholder", "My Custom Placeholder");


    The built-in search bar performs search only on properties of type String. In order to perform a search on Integer type fields, you can create a server query with a parameter and create a screen for that query.

Page 1 of 3 (39 items) 123