Excel2007：对编辑公式功能的改进Part 3_新增函数.doc

Excel2007：对编辑公式功能的改进Part 3_新增函数 Formula editing improvements Part 3: new functions对编辑公式功能的改进 Part 3：新增函数 In addition to improving the formula editing UI in Excel 12, the team has spent some time adding to Excel’s function library.? Over the years, customers have found new ways to combine and leverage the functions in Excel to build all sorts of things, but there remain many areas where our customers would like to see need new capability. This release, we have targeted three areas in which to improve our function library ?the Analysis ToolPak, SQL Server Analysis Services, and the most common requests we hear from customers.除了改进编辑公式的界面外，我们还在Excel 12的内置函数库上花了些功夫。多年以来，用户挖掘出许多新方法，整合和发挥Excel函数的功能，创建各式各样的公式。虽然如此，用户还是期望拥有更多新的函数。此版本中，我们瞄准了三个方面来扩充Excel内置函数库，它们是——分析工具库，SQL Server Analysis Services和用户提出的最具代表性的需求。 First, we have fully integrated the Analysis ToolPak functions into the Excel function library, making these functions first-class citizens and eliminating issues relating to the fact that they had been delivered as an add-in in the past.?Users already find a great deal of value in these functions and, from Excel 12 on, they can rely on them to simply work the way the rest of the Excel function library works. This means users no longer have to run the add-in to use the functions, the functions will show up in Formula Autocomplete (see previous post), the functions will offer the same tooltips as other native Excel functions, etc. 首先，我们把分析工具库函数整合到Excel内置函数库中，使其成为“一等公民”，并取消了原来的加载宏。这些函数对用户十分有价值。从Excel 12起，它们就可以和其它Excel内置函数一样方便地使用。这意味着，用户不需要加载宏，可以直接使用这些函数。它们会出现在Formula AutoComplete功能提供的下拉列表中（见前面的帖子），且和其他内置函数一样也有相应的功能提示。 Second, we have added a new set of functions that allow users to extract information from SQL Server Analysis Services. For the benefit of readers that are not familiar with SQL Server Analysis Services, let me give you a really high-level overview.?In addition to its relational database product, SQL Server includes a feature named Analysis Services