In this videocast, you will learn how to edit a Microsoft excel spreadsheet directly within Filamente using your iPad.
To do so, your SharePoint site needs to be configured with Microsoft Office Web Apps. Office Web Apps are available in SharePoint 2010 and Office 365.
Let’s browse to a SharePoint document library and open a Microsoft excel file. I tap the Quick Browse to view the file in a browser mode.
The Microsoft excel file is displayed in the Office Web Apps. Tap Edit in Browser.
Enter the amount in the Cash Sales field. When editing a file in the Office Web Apps, you don’t need to save the changes manually because changes are saved automatically.
Tap the Refresh button to get the latest excel file. Filamente has the latest excel file that has been modified in the Office Web Apps. The file is now stored within Filamente for an offline access.
Note: This feature is available in Filamente v1.6.0 for the both full and lite version. The feature is applicable to iPad users only.
This video provides an overview of how to use Filamente’s most basic features such as adding multiple SharePoint sites, marking contents as favorite, sorting and filtering contents and viewing documents.
Filamente is a Microsoft mobile SharePoint client for Apple iPad, iPhone and iPod touch. It supports SharePoint 2007, SharePoint 2010 and Office 365.
Managing multiple sites
You can add many SharePoint sites to Filamente for quick access without needing to provide a userID and password by selecting the userID from the existing userID list.
Favorites
You can tap a star icon for each SharePoint list or document library to save it to your Favorites. Once marked as favorite, you can access them easily from Favorites section.
Local Documents
When you want to keep a SharePoint document for an offline viewing, you can save it to Local Documents.
SharePoint views, sorts and filters
You can view all existing SharePoint views. To select a SharePoint view, simply tap a SharePoint view. You can sort SharePoint items by tapping a column name. Filamente will group items intelligently based on the column type. For instance, for the User group type, items are grouped by each assigned user. You can then directly navigate to each user via the index.
When you long press (tap & hold) a column, you can apply filters. For instance, to display only Priority 1 and Priority 2 items, select P1, P2 and tap Apply. If you want to apply additional filter criteria, long press the other corresponding column. For instance, by selecting “John Doe” I see Priority 1 and Priority 2 items assigned to John Doe only.
Document Library
When you go to a document library, you can see all documents and folders. When you tap a folder, you see all documents within the folder. When you tap a document, Filamente shows it on the main pane. For full screen view, tap the full screen view icon. To come back to a normal view, tap the exit full screen view icon.
You can edit MS office documents by sending the document to a third-party software such as Documents2Go and QuickOffice. To do so, tap Action, then tap “Open In..” and select the app that you’d like to use to send a document to.