How To Change My Microsoft Document Files On Open Office

Sharing in a Mixed application Surround

Migration is people issue, not a software consequence

Near migration difficulties occur considering of incompatibility issues. No two certificate production applications will ever take 100% fidelity, not fifty-fifty if those ii applications are just unlike versions of the aforementioned plan. So one of the essential tasks in a successful migration is to identify infidelity risks and thus reduce user frustration. Oftentimes the bug that occur are not actually caused by the migration simply are areas that take always been problematic but it was easier for users to piece of work around than complain. Migration back up desks will inevitably cease up fielding calls that have zilch to do with the migration only has been a point of frustration for some time.

Many of these tin be minimised by the adoption of some simple policies:

Ensure all computers in the organisation have the same font set. This is especially important where at that place is a variation in Operating systems
Put in place policies for document collaboration, for instance found standard fonts for use in documents
Make bachelor a fix of templates on the network that covers all document instances that at that place needs to be collaboration.
Ensure that all machines use the same default template

File formats

This section gives a simplified overview of Apache OpenOffice's file format.

By default Apache OpenOffice stores its files in Open Document Format (ODF), ISO/IEC 26300. For details nigh ODF, come across here.

Older versions of Microsoft Part files are stored in a proprietary format which is not man-readable and not publicly documented. Newer versions of MS Office tin now edit and save in ODF.

File extensions for Apache OpenOffice iv.0.
Document type	Application	Extension	MS Office equiv
Text	Writer	odt	dr., docx
Text Template	Author	ott	dot
Master Document	Writer	odm	doc, docx
HTML document	Writer	html	html
Spreadsheet	Calc	ods	xls, xlsx
Spreadsheet Template	Calc	ots	xst
Drawing	Draw	odg	N/A
Drawing Template	Draw	otg	N/A
Presentation	Impress	odp	ppt, pptx
Presentation Template	Impress	otp	pot
Formula	Math	odf	N/A
Nautical chart	Nautical chart	odc	N/A
Database	Base	odb	mdb

Although Apache OpenOffice can open up Microsoft Role files. The reverse is not always true. Microsoft Role has various degrees of support for ODF, starting in Role 2007, but before versions: MSO '97, Office XP etc, are not able to open up, read or write ODF documents. For this reason, it is essential, during Migration setup, to place your document users and their needs to ensure the minimization of compatibility bug. For instance:

Internal usage -- Utilise Native file format (OD*)
External User Not AOO user - Editable -- Save as *.doctor (2000, XP)
External User AOO user - Editable -- Apply Native file format (OD*)
External User - Editable non needed -- Use PDF.
Archive -- Always utilise ODF

Identifying these User needs and getting staff to work within those parameters should be part of a pre Migration training programme.

Apache OpenOffice tin can not open up or catechumen Microsoft Access files (.mdb) files straight, however it tin can access the data in the tables using DAO and ODBC. Come across the Database Guide for more data.

Bulk conversion

To use Apache OpenOffice to catechumen a lot of files, click File → Wizards → Document Converter .

Earlier doing a bulk conversion of files, think about whether it is really necessary. Read this document right through to get an appreciation of the limitations of the conversion procedure.

Opening files

Opening text documents

In addition to the native OpenDocument formats (.odt and .ott), Apache OpenOffice Writer tin can import the following text document formats:

Microsoft Word 6.0/95/97/2000/XP)	(.doc, .dot)
Microsoft Word 2003	XML
Microsoft Office XML	docx
Microsoft Winword 5	.doc
WordPerfect Certificate	.wpd
WPS 2000/Office 1.0	.wps
AportisDoc (Palm)	.pdb
Pocket Discussion	.psw
Rich Text format	.rtf
Text	.txt, .csv

When opening .HTM or .HTML files, Apache OpenOffice customizes Writer for working with these files.

Opening spreadsheets

In addition to the native OpenDocument formats (.ods and .ots), OpenOffice Calc tin can open the following spreadsheet formats:

Microsoft Excel 97/2000/XP (.xls, .xlw, .xlt)	Rich Text Format (.rtf)
Microsoft Excel four.10–5/95 (.xls and .xlw, .xlt)	Text CSV (.csv and .txt)
Microsoft Excel 2003 XML (.xml)	Lotus 1-2-three (.wk1 and .wk1)
Data Interchange Format (.dif)	StarCalc formats (.sdc, .vor)
dBase (.dbf)	SYLK (.slk)
.htm and .html files including Web page queries	Pocket Excel (pxl)
Quattro Pro 6.0 (.wb2)

Opening presentations

In improver to the native OpenDocument formats (.odp and .otp), OpenOffice Impress can open the following presentation formats:

Microsoft PowerPoint 97/2000/XP (.ppt, .pps)	Reckoner Graphics Metafile (.cgm)
Microsoft PowerPoint 97/2000/XP Template (.pot)	StarDraw, StarImpress (.sda, .sdd, .sdp, .vor)

Opening graphics files

In addition to the native OpenDocument formats (.odg, and .otg), OpenOffice Describe tin open up the post-obit graphic formats:

BMP, JPEG/JPG, PCX, PSD, SGV, WMF, DXF, MET, PGM, RAS, SVM, XBM, EMF, PBM, PLT, SDA, TGA, XPM, EPS, PCD, PNG, SDD, TIF/TIFF, GIF, PCT, PPM, SGF, VOR

Opening formula files

In addition to OpenDocument Formula files, OpenOffice Math can open the StarMath (.smf) and MathML (.mml) files.

When opening a Word document that contains an embedded equation editor object, select the [L] checkbox for MathType to OpenOffice Math/OpenOffice Math to MathType in Tools → Options → Load/Save → Microsoft Part and the object volition exist automatically converted to an OpenOffice Math object.

Saving files

Default file format

OpenOffice.org saves files in the OpenDocument format past default unless told otherwise. This default can be inverse, for example if y'all ever want to salve as Microsoft Office files. To alter the default file formats:

Go to Tools → Options → Load/Save → General .
In the Standard File Format section of this page, cull a document type (for example, "Text document") and a file format from the Always save as list.
Repeat for each document type as necessary.
Click {{push button}OK}} to save your changes.

If the option "Warn when not saving in OpenDocument or default format" is checked in the Options - Load/Save - General dialog, a alert dialog well-nigh potential loss of formatting may be displayed. In most cases, no loss of formatting will occur, so you may find this alarm annoying and cull to disable information technology.

The Java Runtime Environment is required to employ the mobile device filters for AportisDoc (Palm), Pocket Word and Pocket Excel.

Export to PDF and XHTML

Each application has the power to direct export to PDF (Portable Document Format). This industry-standard format for universal file compression and viewing is ideal for sending the file to anyone else to view using Acrobat Reader or any other PDF display program on any operating system.

You tin export directly to PDF using the button on the toolbar next to the Printer icon, or by choosing File → Export equally PDF , which allows you to select some detailed options.

To export as XHTML, utilize File → Export and for File format choose XHTML In the dropdown box.

Saving files in other formats

To salve files in different formats, use File → Save As and select a format from the File Type dropdown box.

Writer tin can save to these file formats

In addition to its native formats, Writer can relieve in these formats:

OpenOffice.org Writer 1.x (.sxw, .stw)

Microsoft Discussion 97/2000/XP (.doc)

Microsoft Word 95 (.md)

Microsoft Discussion half dozen.0 (.physician)

Microsoft Word 2003 XML (.xml)

Microsoft Pocket Word (.psw)

DocBook (.xml)

Aportis Doc (Palm) (.pdb)

Rich Text Format (.rtf)

StarWriter 5.0 (.sdw)

StarWriter Template (.vor)

StarWriter 4.0 (.sdw)

StarWriter four.0 Template (.vor)

StarWriter iii.0 (.sdw)

StarWriter Template 3.0 (.vor)

Text (.txt)

Text Encoded (.txt)

HTML (.html; .htm)

The .rtf format is commonly used for transferring text files betwixt applications, but y'all are likely to feel loss of formatting and images when the file is opened by Microsoft Part. The all-time way to pass a file in Writer to a Microsoft Word user is to save information technology equally Microsoft Word 97/2000/XP (.physician).

Calc can salvage to these file formats

In addition to its native formats, Calc can salve in these formats:

OpenOffice.org Calc i.x (.sxc, .stc)

Microsoft Excel 97/2000/XP (.xls; .xlw)

Microsoft Excel 97/2000/XP Template (.xlt)

Microsoft Excel 95 (.xls; .xlw)

Microsoft Pocket Excel (.pxl)

Microsoft Excel 2003 XML (.xml)

Data Interchange Format (.dif)

dBase (.dbf)

SYLK (.slk)

Text CSV (.csv; .txt)

StarCalc formats (.sdc, .vor)

HTM and HTML files

Impress tin can save to these file formats

In addition to its native formats, Print tin can save in these formats:

Microsoft PowerPoint 97/2000/XP (.ppt; .pps)

Microsoft PowerPoint 97/2000/XP Template (.pot)

StarDraw, StarImpress (.sda, .sdd, .vor)

Impress tin can also export to MacroMedia Flash (.swf) and any of the graphics formats as listed below for Draw.

Draw tin can save to these file formats

Depict can only save in its native and StarDraw formats, only it can consign to:

BMP, EMF, EPS, GIF, JPEG, MET, PBM, PCT, PGM, PNG, PPM, RAS, SVG, SVM, TIFF, WMF, XPM

The HTML writer can save in these formats

HTML Document (.html; .htm)

OpenOffice.org 1.0 HTML Template (.stw)

OpenOffice.org 2.0 HTML Template (.oth)

StarWriter/Web 5.0 and 4.0 (.vor)

Text (OpenOffice.org Writer/Web) (.txt)

Text Encoded (OpenOffice.org Writer/Web) (.txt)

Object Linking and Embedding (OLE)

To change the settings for Microsoft Office OLE objects, use ' Tools → Options → Load/Save → Microsoft Office .

Having all of these options checked allows embedded objects to be converted and thus be editable in both function suites.

For other OLE objects, it will depend on the machine where the file is being edited just equally it does with Microsoft Office alone. Thus, Windows application based OLE objects volition not be editable in Apache OpenOffice on a Linux machine, although the object volition nevertheless be displayed correctly and can be resized.

Linked files

Cells copied from Excel and pasted special, linked and with RTF format, into Give-and-take are imported into Writer equally a normal table. This ways that when the document is imported, the link to the Excel file is lost.

Similarly when a chart is copied from Excel and pasted special, linked into Word, and and so the file imported into Writer, the chart is imported equally an embedded OLE object but is non converted into a Calc chart. On saving the file in Word format and and so opening the file in Give-and-take and trying to edit the chart by double-clicking, it displays an error message.

Links in Microsoft Office files betwixt Word and Excel are lost when the Microsoft office files have been edited by OpenOffice.

WordArt and Fontwork

The equivalent to Microsoft Role's WordArt in Apache OpenOffice is Fontwork. WordArt objects are imported as Fontwork objects; they may look slightly dissimilar on import. Fontwork objects are automatically exported to WordArt objects when the document is saved in a Microsoft Office format.

Vector graphics

The basic shapes (lines, arrows, rectangles, ovals) all import and export without whatever problem. Apache OpenOffice provides a greater degree of control over some properties than Microsoft Role does, so sometimes in that location will be changes when going from Apache OpenOffice to Microsoft Office. Examples include the size of arrow heads, and line styles.

The Microsoft Office autoshapes, such as the smiley face, keep their special characteristics, for instance the ability to adapt the degree of the smile or frown on the smiley face.

Microsoft Part provides more shadow options than Apache OpenOffice, so sometimes there will be a change in shadow appearance. Microsoft Office shadow styles 1, 2, 4, 6, 14, 17 and eighteen are supported in Apache OpenOffice. Horizontal and tapered shadows do not get imported and any 3D upshot on the bottom left is ignored.

Frames and text boxes

When frames or text boxes from Microsoft Office are imported into Apache OpenOffice with linked text, the links are lost.

Active content controls

These are the controls in Microsoft Part available on the Controls toolbar; they all import without a problem. However, every bit these controls typically require macros to be of use, they will be functionally useless in the absence of macros custom built for use in OpenOffice.org.

Macros

Apache OpenOffice cannot run Microsoft Office macros. Although the macro language is very similar, the underlying objects are quite dissimilar. To set whether Apache OpenOffice keeps attached macros (so that they are however available for use in Microsoft Office) for Word, Excel and PowerPoint files, utilise Tools → Options → Load/Save → VBA Properties .

Opening a Microsoft Part file infected with a macro virus is quite prophylactic in Apache OpenOffice.

Apache OpenOffice has the power to record macros. It is meliorate practice to use the awarding program interface (API).

Import, export and sharing issues in text documents

Proficient practice in text documents

Some issues can be avoided merely by using adept discussion-processing practice:

Use character and paragraph styles rather than directly formatting.
Use paragraph formatting for space before and after rather than difficult returns, particularly in numbered or bulleted lists.
Utilize paragraph text period properties (for example, proceed with next) rather than using manual page breaks.
Exercise not use multiple tabs or spaces to align text – either gear up specific tab stops or better still use a table.
Use only commonly available fonts.

Compatibility settings in Apache OpenOffice for the current certificate

The following settings modify the mode Apache OpenOffice works with the current certificate so that it works more similar Microsoft Part.

Use Tools → Options → OpenOffice Writer → Compatibility .

Add paragraph and table spacing at tops of pages (in current document)

In Writer, with this setting unchecked, if a paragraph at the top of the folio (or column) is formatted with space above then that space is ignored; whereas in Word the infinite above is included. Checking this option causes Writer to acquit in the same way equally Word.

Use OpenOffice.org 1.1 tabstop formatting

This setting specifies whether centered and right-aligned paragraphs containing tabs are formatted as a whole in the eye or aligned to the right. If this checkbox is checked, only the text to the right of the final tab is aligned to the right, while the text to the left remains as is.

Use OpenOffice.org 1.1 line spacing

Writer uses the greater of the two spacings for above and beneath paragraphs; Word sums the two together. Uncheck this box to have Writer conduct in the aforementioned mode as Discussion.

Font and font spacing

Text effect animations are imported by Writer with the character aspect of blinking from Word files. For example "Marching crimson ants" simply becomes "blinking".

Typically Word'due south graphic symbol spacing is tighter than Writer's, and then oft Word will fit more characters to a line. It is besides possible that the spacing between lines could be slightly different. The end result is that the folio breaks may be in different places.

Tables

The author could detect no problems with tables.

Mail merge documents

As Apache OpenOffice has a unlike approach to data sources. On importing a Word certificate that is the main document for a mail service merge, there is no connection with the data source. It is not simply a affair of making that connection; each field needs to exist reinserted. See the Mail service Merge department in the chapter titled "Differences in use betwixt Writer and Discussion".

Besides in Discussion you can have another Word document every bit a data source for a mail merge. There is no fashion of specifying a Give-and-take (or Writer) document as a data source in Apache OpenOffice.

Author does not have the option of suppressing bare lines when data fields are empty, so you need to utilize conditional fields.

Writer merge fields export as text with the name of the field between angle brackets, for case <Name>.

Summary: To work in a shared environment would require a separate file for each "primary certificate": one in Discussion format, the other in Apache OpenOffice format. If you have a primary mail service merge document in Word format, it is probably easiest to paste the text into Author and use the Author mail service merge wizard to recreate the mail merge from scratch.

Forms

Bug with forms created in Microsoft Role

A locked file in Microsoft Office imports unlocked into Apache OpenOffice; that is, in design mode.

Text form fields import into Apache OpenOffice as Input fields and so lose their blazon. For instance, a text class field of type "number" or "date" will accept whatsoever text for input. In utilize a text form field in Apache OpenOffice displays a dialog for entering the text. Exporting dorsum to Microsoft Part, text form fields are changed into "Fillin" fields. The current date and time and calculation fields import as simple text.

Checkboxes import and export correctly.

Drop-downward class fields import as Input List fields. Like text form fields in operation these display a dialog from which the user tin can select an choice. On export back to Microsoft Office they render to drib-downwards form fields once again.

Bug with forms created in Apache OpenOffice

The controls are exported as active controls when at that place is a Microsoft Office equivalent. As Word does not have the same database functionality of Apache OpenOffice and as the macros are not compatible, it would be very hard to take one form that works in both environments using standard grade controls.

Summary: To work in a shared environment with forms is not easy, but one workaround would be to use other fields similar Input field and Input List. To insert these fields, use Insert → Fields → Other → Functions .

Footnotes, endnotes, tables of contents and indexes

Footnotes, endnotes and indexes all import / export correctly. Some issues have been found:

The location of the endnotes may change (in Give-and-take the endnotes are placed before the index. In Writer they are always at the finish of the document).
Writer bibliographic entries go text in Give-and-take.
A three-column index exported from Author to Word as three columns but on re-import information technology was one column.
On importing a Word file containing alphabetize entry fields, the index entry fields are imported but as fields to the left of the text rather than the field containing the text.

Summary: Working in a shared surround is possible with some small-scale bug.

Numbered paragraphs, outline numbering, cantankerous-references

Numbered paragraphs, outline numbering, and cross-references import / export without a problem, except for references to numbered paragraphs:

Cross-references to the numbers of numbered paragraphs that are not numbered using outline numbering exercise not piece of work as Writer does not have this ability.
Writer likewise does not have the ability to use relative numbering in its cross-references to numbers.
Cross-references to chapter numbers do not take the same format as that displayed.

Page numbering

A quick and dirty arroyo in Word for having a different first page (like a embrace page) then to accept the numbering showtime on the 2nd page simply numbered as folio 1 is to accept a layout of dissimilar first page and setting the starting page to be zero. Unfortunately, on importing such a file into Apache OpenOffice the page number on the second page is two instead of 1. To gear up this problem in Writer:

Create a page style for how the pages after the starting time folio should look. Proper name it (for case) Convert1.
Have the cursor in the kickoff paragraph of the second folio.
Format → Paragraph → Text Catamenia .
In the Breaks portion of the dialog, select the checkbox Insert.
Check With Folio Manner.
Cull the folio style created in step i.
Go out the position as Before and set the page number to 1.

On exporting this document back to Word it volition work, the only divergence being that the document will accept a department break at the end of the get-go page. Documents created with section breaks like this in Word volition work fine importing and exporting with Writer. There is 1 difference with Discussion: now there will be a blank page between the cover page and the next folio when printed (or impress previewed).

In the author'south testing a certificate with different formats for odd and even page numbering, the odd page numbers were imported as the text of the first odd page rather than equally a field.

Summary: For some documents a fiddling work maybe required to ready up the page numbering on importing to Writer. Once "fixed" the page numbering of the documents will import / export without a problem.

Engagement and time fields

Discussion's CreateDate and SaveDate fields do not get imported with the aforementioned formats. For example, if the fields in the Word certificate accept a format that includes time, and then this information is not displayed by default. To include time in the format:

Right-click on the field > Fields > scroll to the bottom of the Formats listbox > Boosted formats > in format code add HH:MM:SS

On export the SaveDate / DocInformation:Modified is exported as text.

Writer's Time Fixed and Engagement Stock-still fields get exported every bit text.

Importing Discussion fields

Imported Word fields conversion
Word field:	Writer converts to:
Enquire	Input field
Author	DocInformation:Created
AUTONUM	Number Range AutoNr
AUTONUMLGL	Number range AutoNr
AUTONUMOUT	Number range AutoNr
COMMENTS	DocInfomation:Comments
CREATEDATE	DocInformation:Created
Date	Date
EDITTIME	DocInformation:Modified
FILENAME	File name
FILLIN	Input field
HYPERLINK	(as a hyperlink)
INFO xxx	DocInformation:xxx
KEYWORDS	DocInformation:Keywords
LASTSAVEDBY	DocInformation:Modified
MACROBUTTON	(the name of the macro?)
MERGEFIELD	Post merge fields (displayed as the proper noun of the field)
MERGEREC	Record number
Adjacent	Next tape
NOTEREF	Show variable
NUMCHARS	Statistics (with select = Characters)
NUMPAGES	Statistics (with select = Pages)
Page	Folio numbers
PAGEREF	Bookmarks (displayed equally name of bookmark)
REVNUM	DocInformation:Certificate number
SAVEDATE	DocInformation:Modified
SEQ	Number range
Fix	Fix variable
SUBJECT	DocInformation:Subject
TEMPLATE	Templates
TIME	Date
Title	DocInformation:Title
TOC	(Displays the tabular array of contents)

The following fields are not imported into OpenOffice.org (only the text that they displayed when concluding saved): =, IF, DOCPROPERTY, FILESIZE, LINK, LISTNUM, QUOTE, Section, SECTIONPAGES, STYLEREF, TOA, USERADDRESS, USERINITIALS, USERNAME.

The following fields are ignored on import: AUTOTEXT, AUTOTEXTLIST, BARCODE, BIDIOUTLINE, DOCVARIABLE, EQ, GOTOBUTTON, INCLUDETEXT, LISTNUM, MERGESEQ, PRINT, RD, SKIPIF, SYMBOL, TA, TC.

The Discussion field EDITTIME is mapped to Writer field DocInformation:Modified on import but the meaning has changed to the date and time last saved rather than how long the file has been open for editing.

Import, consign and sharing problems in spreadsheets

Form fields

Combo boxes, listing boxes and checkboxes with links to spreadsheet cells all import and export properly, although due to font handling the number of rows displayed in listing boxes may be slightly unlike. Listing boxes in Calc tin either have multi-selection or not, whereas Excel has two multi-selection modes: multi and extend. In Excel a link from a multi-pick listbox to a jail cell is ignored (at least in Excel 2000; the writer has not checked Excel XP). In Calc the link works, just if more than than one item is selected, the jail cell's value is set to #Due north/A.

Option buttons import into Calc, just the link with cells works differently. In Calc each option button has its own link to a cell, setting its value to true or false depending on whether the option is selected. In Excel the cell link returns the number of the selected option button. On exporting option buttons to Excel, the option buttons lose their radio operation; in other words, they are not grouped and then that selecting i "unselects" the others.

Scroll bars and spinners are now implemented in Calc, but are not imported all the same.

Array constants

Array constants are not available in Apache OpenOffice. The workaround is to have the constant values in cells on a sheet and refer to them. Array constants used as parameters to a function in Excel are omitted when imported into Calc.

Optional parameters in formulas

Some formulas have more than 1 optional parameter at the end of the parameter listing. In Excel it is possible to leave an optional parameter blank and specify a later on parameter, but this is non possible in Calc. Formulas with optional parameters are non correctly imported into Calc.

Functions

Statistical, engineering and financial functions

In Excel some of the fiscal functions accept string parameters for dates; in Apache OpenOffice they crave a series number, and thus they are not correctly imported into Calc.

Assay ToolPak Functions

The office Event provided past the Analysis ToolPak for Excel is converted to EFFECT_ADD in Calc and returns the aforementioned results.

Other functions not implemented / imported

Simply 3 other functions are not imported: INFO, GETPIVOTDATA, and HYPERLINK. Hyperlinks are supported just not as a function; use the Hyperlink button on the Office bar.

DataPilot—Pin Table

DataPilots are Calc'due south equivalent to Excel's Pivot Tables. However there are a number of limitations. Pin tables import from Excel into Calc (although the cells do not have the PivotTable shading) but as soon as they are worked on these limitations become apparent. The limitations are:

There is no PivotChart facility, but a DataPilot can be used as the data source for a chart.
The user interface allows a maximum of 8 fields in the data, row or column areas. (An alternative interface which allows more is available from: the quondam http://homepages.paradise.net.nz/hillview/OOo/ in a certificate called MyDataPilot.sxc.
There is some ability to group information (for example, a appointment field grouping by week or quarter but non past calendar month). The workaround is to create a new cavalcade with a formula for calculating the grouping, east.g. =Month().
You lot can non ascertain different formats for different fields.
Calc can have formulas based on things similar "Difference From" or "% of", simply tin can non have own custom fields (work around create new columns to summate the desired values).
The Application Program Interface specification is incomplete for writing macros that work with DataPilots—for example, the power to control through another program, such every bit OpenOffice.org's own macro language, BASIC, whether the tables have grand totals, or having access to DataPilots created from external data.

AutoFilter

AutoFilter imports and exports correctly with the required rows existence hidden. However, there are a number of differences between Excel and Calc:

There is only one AutoFilter active for a spreadsheet document at a time. The rows remain subconscious simply the drop-downs in the first row disappear on applying AutoFilter elsewhere.
The remaining visible row numbers do not alter color to warn that there is a filter in place.
Error values do not evidence as an selection in the drop down lists when cells in the cavalcade accept errors.
In the drib downwardly lists, the equivalent to Excel's "Custom" is chosen "Standard".

Charts

Chart types that Excel provides only Calc does non:

Bar of pie converts to a 2d – columns – normal.
Pie of pie converts to a 2D – columns – normal.
Radar filled converts to 3D – columns deep.
Radar with markers – converts to 2D – internet – normal but counterclockwise rather than Excel's clockwise.

Number formats

In that location is no "accounting" format (with the currency symbol at the left border of the jail cell). A workaround would be to have another column to the left that contains the currency symbol.

There is no predefined option for bracketing negative numbers. Utilise a custom format such every bit "$#,##0.00_);[RED]($#,##0.00)".

Filigree lines

In Excel grid lines are a property of a worksheet; in Calc it is an application-broad option:

Tools → Options → OpenOffice Calc → View

Import, consign and sharing issues in presentations

Color gradients and borders

The author had not noticed the following changes, so this is a direct quote from StarOffice 7 Migration Guide by Sun.

Unlike Microsoft PowerPoint, StarOffice Print does non back up three-color gradients, double and triple borders, or circular-dotted borders. To amend the results of the import, you have to make the necessary adjusts earlier import. Alter 3-colour presets to like ii-color gradient fills and modify double and triple border lines to a single border line with appropriate width. Round-dotted border lines that are mapped to rectangle-edge closely resemble the original line style in PowerPoint, then transmission editing should not be necessary.

Multimedia

Voice-over narration is not supported by Impress.

At that place appear to be no settings for multimedia custom animations, such as the power to play a sound for the next slides.

Chart animations

At that place is no facility in Impress for "chart effects" as there is in PowerPoint, such every bit presenting a series or category at a time. On import the charts but appear. A workaround is to have multiple copies of the chart with each ane set up upwards to display as desired.

Pack and Go

The Pack and Go feature in PowerPoint allowed a PowerPoint file to exist split over several floppy disks and assured that all related files were included. This facility is not included in Print, nor can Impress open such files.

Fields

Date fields are exported as text, so they exercise not automatically update.

Action settings and interaction

PowerPoint provides action settings for mouseover, but Impress does non have this option, merely on mouse click, so mouseovers go mapped to mouse clicks. PowerPoint has an selection for highlighting the object on mouse click or mouse over; Impress does not have this, and then it gets ignored on import.

PowerPoint custom animations and Print object effects

Table iii shows how the custom animations and object furnishings are imported into Impress and exported to PowerPoint.

Importing / exporting custom animations between PowerPoint and Impress
PowerPoint	Print
Announced	Announced
Blinds	Fade Horizontally
Box	Fade To Eye
Checkerboard	Checkerboard
Diamond	Announced
Crawl	Fly In From lesser
Dissolve	Deliquesce
Flash once	Appear
Peek	Short Fly In from Lesser
Random Bars	Horizontal lines
Spiral	Spiral Outward Clockwise
Split	Close Vertical
Stretch	Stretch Vertical
Strips	Fade From Top Right
Swivel	Rotate Horizontally
Wipe	Cantankerous-Fade From Pinnacle
Zoom	Fade From Middle
Random effects	Vertical Lines

PowerPoint—Impress slide transitions

Table 4 shows how slide transitions are imported into Impress and exported to PowerPoint.
PowerPoint	Impress
Blinds Horizontal	Venitian Blinds Horizontal
Blinds Vertical	Venitian Blinds Vertical
Box In	Box In
Box Out	Box Out
Checkerboard Across	Checkerboard Across
Checkerboard Downward	Checkerboard Down
Cover Down	Cover Downwardly
Cover Left	Encompass Left
Comprehend Correct	Cover Correct
Comprehend Up	Cover Upwardly
Cover Left Down	Cover Left-Down
Cover Right Downward	Embrace Right-Down
Cover Left Up	Cover Left-Up
Cover Right Up	Cover Right-Upwardly
Cut	No issue
Cut Through Blackness	No effect
Dissolve	Dissolve
Fade Through Black	Fade Through Black
Random Bars Horizontally	Random Confined Horizontal
Random Bars Vertically	Random Bars Vertical
Horizontal In	Split Horizontal In
Horizontal Out	Split Horizontal Out
Split Vertical In	Divide Vertical In
Split Vertical Out	Separate Vertical Out
Strips Left Down	Fade From Top Right
Strips Left Up	Fade From Bottom Correct
Strips Right Down	Fade From Peak Left
Strips Correct Up	Fade From Bottom Left
Uncover Downwards	Uncover Down
Uncover Left	Uncover Left
Uncover Right	Uncover Correct
Uncover Upward	Uncover Upwards
Uncover Left Downward	Uncover Left-Down
Uncover Left Upwards	Uncover Left-Up
Uncover Right Down	Uncover Right-Down
Uncover Right Up	Uncover Right-Up
Wipe Downward	Wipe Down
Wipe Left	Wipe Left
Wipe Right	Wipe Correct
Wipe Upwardly	Wipe Up
Random Transition	Random Transition

Source: https://wiki.openoffice.org/wiki/Documentation/UserGuide/Migration_Guide/Sharing_Files

Posted by: thomasscat1962.blogspot.com