Excel to Numbers Functions will be a major compatibility issue for importing Excel spreadsheets. Numbers ‘08 has about 170 functions, about half as many in Excel 2008. 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. If an Excel spreadsheet contains a function that numbers doesn’t support, Numbers will import only the calculated value of a cell. Numbers will flag these cells with a blue triangle, which you can click to see the Excel function that was deleted.
Numbers also doesn’t support Excel’s ability to password-protect hidden cells and rows. Numbers will translate these as unhidden, but empty cells. The only way to retain the information in these cells is to have the creator of the Excel document remove the password protection.
Source
No comments:
Post a Comment