![]() PowerPoint to Keynote Slide presentations are tricky to move around between Mac and Windows versions of PowerPoint. The only way to retain the information in these cells is to have the creator of the Excel document remove the password protection. Numbers will translate these as unhidden, but empty cells. Numbers also doesn’t support Excel’s ability to password-protect hidden cells and rows. Numbers will flag these cells with a blue triangle, which you can click to see the Excel function that was deleted. If an Excel spreadsheet contains a function that numbers doesn’t support, Numbers will import only the calculated value of a cell. Many of the missing functions are statistical and numeric functions, and Numbers doesn’t have any of Excel’s database functions or Excel’s three-dozen engineering functions. Numbers ‘08 has about 170 functions, about half as many in Excel 2008. Excel to Numbers Functions will be a major compatibility issue for importing Excel spreadsheets. ![]() Numbers will delete hundreds of Excel functions that it doesn’t support, but will mark affected cells and show you the deleted formula. Pixel settings in Word and Pages are the same size, so the imported document will look more like the original. A setting of 16 pixels is usually equal to 1 line in most fonts. To fix the issue, redefine the line spacing in both Word and Pages as pixels rather than lines. The reason is that Word and Pages define line spacing slightly differently, so that “single spaced” in Pages is slightly larger than in Word, causing a page full of text to spill into a second page. Which means you’re out of luck if you need to trade a macro-laden file back and forth with Office users.Ī frustrating issue is that you can still have the text overflow problem even when you have the same font, font size, and line spacing set in Word and Pages. There is no way to automatically translate macros into AppleScripts. The catch is that you have to create the script mostly by hand. You can recreate much of the functionality of an Office macro usingĪppleScript. When you import a file containing a macro, any macro in the document is lost. One major Office feature that iWork does not support is Visual Basic Application (VBA) macros from Office 2004 for Mac and Office 2007 for Windows. The more complex the Office file, the more likely you will lose something in the translation. And when it does import items, they will often appear differently in iWork. ![]() When importing an Office file, iWork will often bring up a Warning box telling you which aspects of the original document were removed or changed. When it imports or exports Office files, iWork tells you what got lost in the translation. Expand the “Open with” section and chose Pages from the popup menu. If you have both Office and iWork installed on your Mac, and you want Pages to open when you double-click a Word file, select the file and chose Get Info from the File menu. ![]()
0 Comments
Leave a Reply. |