Versions Compared

Old Version 40

changes.mady.by.user Devin Stronge

Saved on

compared with

New Version Current

changes.mady.by.user Devin Stronge

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Section
Column
width15%
Excerpt Include
pluglib:Advanced Macros Pluginpluglib:
Advanced Macros Plugin
nopaneltrue
Column
width60%
Deck of Cards
width907px
idOffice
Card
labelOverview

Office Connector plugin

The 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
    titleThe 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
labelDocumentation
Deck of Cards
idofficem

Card
labelImporting 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.

Toggle Cloak
id3
2. Click on the 'Tools' menu and select 'Doc Import'.

Cloak
id3

Toggle Cloak
id4
3. Select the document you want to import and click 'Import'.

Cloak
id4

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) or Word document (doc) file in a Wiki page. {note:title=Viewing Powerpoint and PDF files with the (({viewfile})) macro is not supported} h3. The Code Displays an Excel file: {code}
Card
labelExporting as an Office Document

You can also export a Wiki page as an editable Office document.

Exporting a Wiki page as an Office Document

1. Navigate to the page you wish to export.

Toggle Cloak
id1
2. Click on the 'Tools' menu.

Cloak
id1

Toggle Cloak
id2
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
id2

Card

Card
labelview

Displays an Excel (xls) or Word document (doc) file in a Wiki page.

Note
titleViewing Powerpoint and PDF files with the *view* macro is not supported

The Code

Displays an Excel file:

Code Block

{viewxls:name=workbook.xls}
{code} 
Displays 
 
 a 
 
 Word 
 
 document 
 
 file:

{
 Code Block
}

{viewdoc:name=Testdoc.doc}

{code}

Displays a Powerpoint file:
{code}

{code}

Displays a PDF document:
{code}
{viewpdf:name=Portable Document.pdf}
{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}
*Displays a Powerpoint file*:

*Displays a PDF document*:
{viewpdf:name=Portable Document.pdf}
{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}


 Result 
 Cloak
id6
Displays an Excel file:
 workbook.xls 
Displays a Word document file:
 Testdoc.doc
 Toggle Cloak
id7
 Parameters
 Cloak
id7
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
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 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
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.
 Card
 Deck of Cards
 Round Rectangle
cornersfalse,false,true,true
bgcolor#828282
width909px
height50px
 Column
width20%