| Column |
|---|
| | Excerpt Include |
|---|
| pluglib:Advanced Macros Pluginpluglib: |
|---|
| Advanced Macros Plugin |
|---|
| nopanel | true |
|---|
|
|
| Column |
|---|
| | Deck of Cards |
|---|
| | Card |
|---|
| Office Connector pluginThe Office Connector allows you to use Microsoft Office or OpenOffice to create and edit rich content for your Confluence wiki. The features of the Office Connector plugin:- Import Word documents
- Seamlessly edit Confluence content in Microsoft Word
- View and edit Office documents from within Confluence
- Choose between OpenOffice and Microsoft Office, if you are using Firefox as your browser.
This plugin includes the following macros:- view - Display an Office file in a Wiki page.
| Note |
|---|
| title | The Office Connector only supports .doc and .xls file types. You can convert the format of a file by clicking "Save As.." and selecting 'Word 97 - 2004 Document' in the "Format" dropdown |
|---|
| |
|
| Card |
|---|
| | Card |
|---|
| label | Importing an Office Document |
|---|
| |
You can import a Word document into the Wikis and convert it into a Wiki page. Importing an Office Document as a Wiki Page 1. Navigate to the page where you wish to import to. 2. Click on the 'Tools' menu and select 'Doc Import'.3. Select the document you want to import and click 'Import'.| Cloak |
|---|
|
Browse | Search your local directories for a file to import. |
|---|
Import | Import selected document. |
|---|
5Advanced | Opens the "Advanced' options menu. |
|---|
5
Use these options to choose how to import the document, either as a new page or as content on a page, etc. If the document has defined headings, you can split the file into multiple pages or as multiple pages based on the headings.
|
|
| | Wiki Markup |
|---|
{deck:id=Office|width=907px}
{card:label=Overview}
h4. Office Connector plugin
The Office Connector allows you to use Microsoft Office or OpenOffice to create and edit rich content for your Confluence wiki.
h5. The features of the Office Connector plugin:
* Import Word documents
* Seamlessly edit Confluence content in Microsoft Word
* View and edit Office documents from within Confluence
* Choose between OpenOffice and Microsoft Office, if you are using Firefox as your browser.
h5. This plugin includes the following macros:
* *view* - Display an Office file in a Wiki page.
{card}
{card:label=Documentation}
{deck:id=officem}
{card:label=Importing an Office Document}
You can import a Word document into the Wikis and convert it into a Wiki page.
h3. Importing an Office Document as a Wiki Page
*1.* Navigate to the page where you wish to import to.
{toggle-cloak:id=3}*2.* Click on the 'Tools' menu and select 'Doc Import'.
{cloak:id=3}
!export_import.png|border=2,bordercolor=grey!
{cloak}
{toggle-cloak:id=4}*3.* Select the document you want to import and click 'Import'.
{cloak:id=4}
!doc_import.png|border=2,bordercolor=grey!
||Browse | Search your local directories for a file to import.|
||Import | Import selected document.|
||{toggle-cloak:id=5}Advanced| Opens the "Advanced' options menu.|
{cloak:id=5}
!advanced.png|border=2,bordercolor=grey!
Use these options to choose how to import the document, either as a new page or as content on a page, etc. If the document has defined headings, you can split the file into multiple pages or as multiple pages based on the headings.
{cloak}
{card}
{card:label=Exporting as an Office Document}
You can also export a Wiki page as an editable Office document.
h3. Exporting a Wiki page as an Office Document
*1.* Navigate to the page you wish to export.
{toggle-cloak:id=1}*2.* Click on the 'Tools' menu.
{cloak:id=1}
!export_import.png|border=2,bordercolor=grey!
{cloak}
{toggle-cloak:id=2}*3.* Select 'Export to PDF' or 'Export to Word' and click the 'Ok' button in the pop-up window to export the Wiki page as a PDF or Word document. If the Wiki page is exported as a Word document - it can be opened and edited using Office Software.
{cloak:id=2}
!pop-up.png|border=2,bordercolor=grey!
{cloak}
{Card}
{card:label=view}
Displays an Excel(xls), Word document (doc), Portable Document (PDF) or Powerpoint (ppt) file in a Wiki page.
h3. The Code
Displays an Excel file:
{code}| Card |
|---|
| label | Exporting as an Office Document |
|---|
| You can also export a Wiki page as an editable Office document. Exporting a Wiki page as an Office Document1. Navigate to the page you wish to export. 2. Click on the 'Tools' menu.3. Select 'Export to PDF' or 'Export to Word' and click the 'Ok' button in the pop-up window to export the Wiki page as a PDF or Word document. If the Wiki page is exported as a Word document - it can be opened and edited using Office Software.Displays an Excel (xls) or Word document (doc) file in a Wiki page. | Note |
|---|
| title | Viewing Powerpoint and PDF files with the *view* macro is not supported |
|---|
| |
The Code Displays an Excel file: |
{viewxls:name=workbook.xls}
|
|
{code}
{}code}
Displays a Powerpoint file:
{code}
{code}Displays a PDF document:
{code}
{code}
h3. {toggle-cloak:id=6} Result
{cloak:id=6}
*Displays an Excel file:*
{viewxls:name=workbook.xls}
*Displays a Word document file:*
*Displays a Powerpoint file:*
*Displays a PDF document:*
{cloak}
h3. {toggle-cloak:id=7} Parameters
{cloak:id=7}
||*Name*||*Required?*||*Default*||*Description*||
{cloak}
{card}
{deck}
{card}
{deck}
{roundrect:bgcolor=#828282|width=909px|height=50px|corners=false,false,true,true}
{roundrect}
viewdoc:name=Testdoc.doc}
|
Result | Cloak |
|---|
| Displays an Excel file: workbook.xls Displays a Word document file: Testdoc.doc |
Parameters| Cloak |
|---|
| View Excel ParametersName | Required? | Default | Description |
|---|
name |
| none | This is the file name of the document to be displayed. The document must be attached to a wiki page on your Confluence site. | col |
| Last column with content | Enter the number of the last column you want displayed, starting from '0' as the first column. For example, the following code will show the first 3 rows and the first 3 columns: | grid |
| true | Select the check box in the macro browser (true in Wiki Markup) to show grid lines around each cell of the Excel spreadsheet. Clear the check box in the macro browser (false in Wiki Markup) to hide these grid lines. | page |
| The page which contains the viewxls macro | Enter a page name, if you wish to display a document which is attached to another Confluence page. For example: | row |
| Last row with content | Enter the number of the last row you want displayed, starting from '0' as the first row. For example, the following code will show the first 3 rows and the first 3 columns: | sheet |
| First worksheet in the spreadsheet | Enter the name of the worksheet that you want displayed. | space |
| The space of the page which contains the viewxls macro | Enter a space key, if you wish to display a document which is attached to a page in another Confluence space. For example: | date |
| none | If the Page Name refers to a blog post instead of a conventional page, enter the date of the post in the form mm/dd/yyyy. |
View Word Document ParametersName | Required? | Default | Description |
|---|
name |
| none | The file name of the Office Word document to be displayed. The document must be attached to a wiki page. | page |
| The page which contains the viewdoc macro | Enter a page name, if you wish to display a document which is attached to another Confluence page. For example: | space |
| The space of the page which contains the viewdoc macro | Enter a space key, if you wish to display a document which is attached to a page in another Confluence space. For example: | date |
| none | If the Page Name refers to a blog post instead of a conventional page, enter the date of the post in the form mm/dd/yyyy. |
|
|
|
| Round Rectangle |
|---|
| corners | false,false,true,true |
|---|
| bgcolor | #828282 |
|---|
| width | 909px |
|---|
| height | 50px |
|---|
| |
|
|