對編輯公式功能的改進Part 1_Excel 12 編輯欄_Excel 2007新知

對編輯公式功能的改進Part 1_Excel 12 編輯欄_Excel 2007新知

譯者：apolloh? 來源：http://blogs.msdn.com/excel 發表于：2006年7月7日

Meet the Excel 12 formula bar, or “don’t hijack my grid!”. 相約Excel 12 編輯欄——“請別妨礙到表格”

I’d like to shift gears a bit and talk about the work we’ve done to improve the experience around building and editing formulas.? For most customers, this is a core activity in their daily use of the product.? In planning for this version of Excel, we took a hard look at the features in this area, and we have made what we think are some significant improvements.? Over the next week, I am going to cover the work we have done in this area. 我想稍微調整進度，提前來談一下我們在創建和編輯公式方面所做的改進。對絕大多數用戶來說，創建和編輯公式是平時使用產品的主要工作。在規劃Excel 12時，我們仔細地研究過此方面的功能，并且做了看來較為充分的改善。接下來，我打算用一整周的時間，來討論我們對此所做的努力。

To start, let’s take a look at some changes to the formula bar.? In Excel 12, we’ve redesigned the formula bar to be both flexible and less intrusive.? When we were researching the area of formula editing, the most common customer feedback we received about the formula bar was that it didn’t respect their data on the grid.? In order to display text in the active cell, the formula bar would spill into the sheet, often resulting in obscured column headers and sheet content. This could be frustrating when users were working with a spreadsheet containing cells with more than one line of text. We’ve addressed this issue in Excel 12 by giving formula bar its own space that never overlaps with the grid.? The behaviour is similar to resizing a docked task pane.?? Let’s take a look at an example. 先來看看編輯欄有了哪些變化？在Excel 12 里，為了讓您用得輕松自如，我們對編輯欄做了新設計。“編輯欄無視數據表的存在！”是調研中用戶給我們最多的反饋——顯示活動單元格的(長)文本時，編輯欄常會越位，擋到列標和工作表的內容。用戶工作表單元格的文本超過一行時，這種令人沮喪的事就有可能會發生。在Excel 12中，這個問題已解決。編輯欄開始固守本位，不再占用表格的空間。解決方式有點類似調整任務欄的大小。我們來看個例子：

Below is an image of the Excel 2003 formula bar when a cell containing a lot of text is selected.? Column headers and data are obscured by the formula bar. 如下圖，在Excel 2003 中，選擇一個包含長文本的單元格時，編輯欄會遮擋到列標和數據。

Now let’s look at that same document in Excel 12.? Rather than spilling the content, we’ve added a scroll bar and kept the formula bar to a single line (which is the default state).? 再來看看Excel 12中同一文檔的情況。為使編輯欄不越位，我們對其新增了滾動條，保證其僅顯示一行的文本內容。（默認設置）

Another piece of feedback we heard from users about the formula bar was that the name box was not big enough to display long range names.? Accordingly, we’ve added the ability to resize the name box horizontally. This gives customers the ability to accommodate their long range names by dragging the name divider (circular dimple) left or right. 還有一個關于編輯欄的反饋信息。原有的名稱框太小，不夠用來顯示長名稱。為此，我們添加了水平方向調整名稱框的功能。用戶可以通過左右拖曳名稱框的分隔符（圓點），來調整寬度，使其能夠適應長名稱。

Here is an example of a long range name that doesn’t fit in the name box: 這是名稱框中不夠位置顯示長名稱的例子：

Here is what things look like after the name box has been resized: 這是名稱框調寬之后的樣子：

Finally, I’ve already talked about limits, but I thought I’d mention a few here in the context of the formula bar.? The changes we’ve made will accommodate these increased limits and the larger formulas that result. 之前，我已經談過Excel 12的限制問題。但在本文結束前，還有必要指出這些限制中與編輯欄相關的一些內容。我們對編輯欄做了改變后，相應地加大了這些限制的上限，允許編輯更長的公式。

The maximum length of formulas (in characters) Old Limit: 1k characters New Limit: 8k characters 公式長度限制（字符） 舊限制：1K個字符 新限制：8k個字符

The number of levels of nesting that Excel allows in formulas Old Limit: 7 New Limit: 64 公式嵌套的層數限制 舊限制： 7 新限制： 64

Maximum number of arguments to a function Old Limit: 30 New Limit: 255 公式中參數的個數限制 舊限制： 30 新限制： 255

That’s all for today.? Next up, formula auto complete (yes, it’s as great as it sounds) 今天就到這。下回我們談Formula AutoComplete（吼，這聽起來很不錯）。

Published Tuesday, October 18, 2005 3:31 PM by David Gainer Filed Under: Formulas and functions

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。