Trying to filter a list on its workflow status is pretty non-intuitive. You need the special status codes. Theese will work with all workflows in ShaePoint even Nintex workflows.

Status Code

Status Description

0

Not Started

1

Failed on Start

2

In Progress

3

Error Occurred

4

Cancelled (i.e. Stopped by User)

5

Completed

6

Failed on Start (retrying)

7

Error Occurred (retrying)

8

(unknown)

9

(unknown)

10

(unknown)

11

(unknown)

12

(unknown)

13

(unknown)

14

(unknown)

15

Cancelled

16

Approved

17

Rejected

Theese status codes can be used in editing list view query in both the user interface and the CAML in the list schema.xml

image005

 

image006

Another little special SharePoint speciality is that the workflow status field is referenced as the 8 first letters in the workflow instance name and the value type as WorkflowStatus

References:

Tags: , , , , , | Categories: Tips and tricks | SharePoint Development | SharePoint Configuration

At last it is now possible to download a standalone SkyDrive Pro client.

The standalone SkyDrive Pro sync client allows users of SharePoint 2013 and SharePoint Online in Office 365 to sync their personal SkyDrive Pro and any SharePoint 2013 or Office 365 team site document libraries to their local machine for access to important content on and offline. The SkyDrive Pro sync client can be installed side-by-side with previous versions of Office (Office 2010, Office 2007, etc).

 Download SkyDrive Pro client for Windows

Tags: , , , , , | Categories: SharePoint related

Of course there is a print button in all Microsoft Office programs and even in Office Web App!

Well I thought so… But there is no print functionality in Office Excel Web App in the SharePoint Online.

The hunt begins:

Searching Microsoft Office Support

In search of the holy print button I found this at http://office.microsoft.com/en-us/web-apps-help/print-an-excel-workbook-from-the-browser-HA010379748.aspx

There is a nice headline saying “Print an Excel workbook from the browser”, sounds good but it only gives us two possibilities:

  • By using the Print command in Internet Explorer
  • By opening the workbook in Excel, and using the Print features there

Well, nothing new there!

Office support excel print

 

Using the Browsers print button will give you a print with the toolbar on, not very useful. If using Excel on the computer is an option then this is for now the best choice.

Let’s take a look at the services offered with Office 365

Downloading and reading the Microsoft Office Web Apps Service Description.docx at http://www.microsoft.com/download/en/details.aspx?id=13602 gets me no further. Print is offered for Word and PowerPoint Web Apps but not in Excel.

SkyDrive has it

I was pretty surprised when I spotted the print button at the SkyDrive Excel Web App.

Comparison of the two Excel Web Apps in SkyDrive and Office 365:
SkyDrive Office 365
Excel_webApp_SkyDrive Excel_webApp_Office365

The print in Excel Web App in SkyDrive opens a new window with the workbook content and gives you the choices to print the active sheet or print selection.

But why not this functionality in Office 365?

Not coming soon

Reading the smoke signals from mount Redmond, the print in excel is nowhere in the recent roadmap for Office 365, telling me that we have to wait a couple of month, at least.

Tags: , , , | Categories: SharePoint related