About Converting Microsoft Office Documents/text/shared/guide/ms_import_export_limitations.xhpMicrosoft Office;document import restrictionsimport restrictions for Microsoft OfficeMicrosoft Office;importing password protected filesMW moved "Microsoft Office;" from shared/guide/protection.xhp
About Converting Microsoft Office Documents
$[officename] can automatically open Microsoft Office 97/2000/XP documents. However, some layout features and formatting attributes in more complex Microsoft Office documents are handled differently in $[officename] or are unsupported. As a result, converted files require some degree of manual reformatting. The amount of reformatting that can be expected is proportional to the complexity of the structure and formatting of the source document. $[officename] cannot run Visual Basic Scripts, but can load them for you to analyze.The most recent versions of %PRODUCTNAME can load and save the Microsoft Office Open XML document formats with the extensions docx, xlsx, and pptx. The same versions can also run some Excel Visual Basic scripts, if you enable this feature at %PRODUCTNAME - PreferencesTools - Options - Load/Save - VBA Properties.The following lists provide a general overview of Microsoft Office features that may cause conversion challenges. These will not affect your ability to use or work with the content of the converted document.
Microsoft Word
AutoShapesRevision marksOLE objectsCertain controls and Microsoft Office form fieldsIndexesTables, frames, and multi-column formattingHyperlinks and bookmarksMicrosoft WordArt graphicsAnimated characters/text
Microsoft PowerPoint
AutoShapesTab, line, and paragraph spacingMaster background graphicsGrouped objectsCertain multimedia effects
Microsoft Excel
AutoShapesOLE objectsCertain controls and Microsoft Office form fieldsPivot tablesNew chart typesConditional formattingSome functions/formulas (see below)One example of differences between Calc and Excel is the handling of boolean values. Enter TRUE to cells A1 and A2. In Calc, the formula =A1+A2 returns the value 2, and the formula =SUM(A1;A2) returns 2. In Excel, the formula =A1+A2 returns 2, but the formula =SUM(A1,A2) returns 0.in SUM(A1<limiter>A2), use the Excel limiter comma , in English and semicolon ; in GermanFor a detailed overview about converting documents to and from Microsoft Office format, see the Migration Guide.
Opening Microsoft Office Documents That Are Protected With a Password
%PRODUCTNAME can open the following Microsoft Office document types that are protected by a password.
Microsoft Office formatSupported encryption methodWord 6.0, Word 95Weak XOR encryptionWord 97, Word 2000, Word XP, Word 2003Office 97/2000 compatible encryptionWord XP, Word 2003Weak XOR encryption from older Word versionsExcel 2.1, Excel 3.0, Excel 4.0, Excel 5.0, Excel 95Weak XOR encryptionExcel 97, Excel 2000, Excel XP, Excel 2003Office 97/2000 compatible encryptionExcel XP, Excel 2003Weak XOR encryption from older Excel versions
Microsoft Office files that are encrypted by AES128 can be opened. Other encryption methods are not supported.Setting the default file format