Confluence Docs 3.0 : Editing an Office Spreadsheet from Confluence This page last changed on Nov 11, 2008 by smaddox. When viewing a wiki page that displays an attached Office document, you can launch your Office editor directly from Confluence. This allows you to edit an Excel spreadsheet from within Confluence and save it back to Confluence. This is just one of the ways Confluence can interact with Office documents. For an overview of all Office Connector features, please refer to Working with the Office Connector. Your System Administrator can enable or disable the Office Connector or parts of it. The Office Connector options can appear in different places on your Confluence page, depending on the themes and configuration of your Confluence site. Please refer to Configuring the Office Connector in the Confluence Administration Guide and discuss any configuration problems with your administrator. On this page: Prerequisites for Editing an Attached Office Spreadsheet Step 1. View the Office Spreadsheet in Confluence Step 2. Open the Spreadsheet in your Office Application Troubleshooting ## Prerequisites for Editing an Attached Office Spreadsheet The Office Connector allows you to edit Office documents embedded in a wiki page or to edit a wiki page in Word. To make use of these editing capabilities, you will need the setup described below. ###### Browsers If you are using Firefox, you will need to install a Firefox add-on. Firefox will prompt you to do this, the first time the add-on is required. You will find instructions in Installing the Firefox Add-On for the Office Connector. ###### Editors To edit documents, you will need to have Microsoft Office, OpenOffice or NeoOffice installed. (See the configuration matrix below.) If you are using Firefox, you can choose which of the above editors you want to use. The Firefox add-on allows you to configure this option for each document type. See Installing the Firefox Add-On for the Office Connector. If you are using Internet Explorer, you will need Microsoft Office. You cannot edit documents in OpenOffice when using IE. ###### Configuration Matrix You need one of the following software combinations to edit Office documents from your wiki page:
Operating System | Office Version | Browser
--- | --- | ---
Windows Vista, or Windows XP with Service Pack 2 or 3 | OpenOffice 2.x, or Microsoft Office XP, 2003 or 2007 (all documents must be in Microsoft Office 97-2003 compatible format) | Internet Explorer 6 or 7, or Firefox 2.x or 3.0
Mac OS X | NeoOffice | Firefox 2.x or 3.0
Linux | OpenOffice 2.x The only known supported Office editor for Linux is OpenOffice. But in theory it should work with any WebDAV-aware application. | Firefox 2.x or 3.0
## Step 1. View the Office Spreadsheet in Confluence If an Office document is attached to a Confluence page, you can view the attached Office document from within Confluence. View the Office document in one of the following ways: Search for the Office document by file name, then click the 'View' link next to the Office document on the Search results page. (See Searching Confluence.) View the list of attachments for a specific Confluence page, then click the 'View' link next to the Office document on the Attachments page. (See Viewing Attachment Details.) View a list of attachments displayed on a page via the Attachments macro, then click the 'View' link next to the Office document in the list of attachments. (See Displaying List of Attachments in a Page.) View a Confluence page which has the Office document embedded in the page via the View File macro. (See View File Macro.) ## Step 2. Open the Spreadsheet in your Office Application To edit the spreadsheet in your Office application, Move your mouse pointer to the top of the spreadsheet embedded in the Confluence page, until the hidden title bar appears. Screenshot: The title bar showing 'spreadsheet.xls' above an embedded Excel spreadsheet Click the title bar above the embedded spreadsheet. A window will pop up, asking you to confirm that you want to open this document. Screenshot: Confirmation window in Firefox Screenshot: Confirmation window in Internet Explorer Click 'OK'. Now you may be asked to log in to your Confluence server. Screenshot: Logging in to Confluence Enter your Confluence username and password, then click 'OK'. The Office spreadsheet will open in your Office application. Make the necessary changes, then save the spreadsheet. It will be saved back into Confluence. ## Troubleshooting Problems? Please refer to our guide to the Office Connector limitations and known issues. ##### RELATED TOPICS Working with the Office Connector Office Connector Prerequisites Installing the Firefox Add-On for the Office Connector Editing a Confluence Page in an Office Application Importing an Office Document into Confluence Displaying an Office Document in Confluence Editing an Office Document from Confluence Editing an Office Presentation from Confluence Editing an Office Spreadsheet from Confluence Configuring the Office Connector in the Confluence Administration Guide Take me back to Confluence User Guide

Document generated by Confluence on Nov 05, 2009 23:35