Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
{composition-setup}
{section}
{column:width=15%}
{excerpt-include
pluglib
:Advanced Macros
Plugin
 Plugin|nopanel=true}
{column}
{column:width=60%}

{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.
{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=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) or Word document (doc) file in a Wiki page.
{note:title=Viewing Powerpoint and PDF files with the *view* macro is not supported}
h3. The Code 

Displays an Excel file:
{code}
{viewxls:name=workbook.xls}
{code}

Displays a Word document file:
{code}
{viewdoc:name=Testdoc.doc}
{code}

h3. {toggle-cloak:id=6} Result 
{cloak:id=6}
*Displays an Excel file*:
{viewxls:name=workbook.xls}
*Displays a Word document file*:
{viewdoc:name=Testdoc.doc}
{cloak}
h3. {toggle-cloak:id=7} Parameters
{cloak:id=7}
h5. View Excel Parameters
||*Name*||*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|(x)|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: 
{code}{viewxls:name=my spreadsheet.xls|col=2|row=2}{code}|
|grid|(x)|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|(x)|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: 
{code}{viewxls:name=my spreadsheet.xls|page=Sample Page}{code}|
|row|(x)|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: 
{code}{viewxls:name=my spreadsheet.xls|col=2|row=2}{code}|
|sheet|(x)|First worksheet in the spreadsheet|Enter the name of the worksheet that you want displayed. |
|space|(x)|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:
{code}{viewxls:name=my spreadsheet.xls|space=DOC|page=Sample Page}{code}|
|date|(x)|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.|

h5. View Word Document Parameters
||*Name*||*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|(x)|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:
{code}{viewdoc:name=my document.doc|page=Sample Page}{code}|
|space|(x)|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:
{code}{viewdoc:name=my document.doc|space=DOC|page=Sample Page}{code}|
|date|(x)|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.|
{cloak}
{card}

{deck}
{card}
{deck}
{roundrect:bgcolor=#828282|width=909px|height=50px|corners=false,false,true,true}
{roundrect}

{column}
{column
:width
20%
=20%}
{column}
{section}
Wiki Markup
{composition-setup
}
deck.tab.active.background = #6495ED
Section
Column
width15%
pluglib:Advanced Macros Plugin
nopaneltrue
Column
width60%
Wiki Markup