Field Settings and PivotTable Options dialogs
The goal of the ribbon is to provide all the functionality needed for most users. More advanced options are available in the Field Settings dialog and the PivotTable Options dialog. While both of these dialogs existed in previous versions of Excel, we have updated them to achieve two things. First, to group the options more intuitively together, and second, to include settings for new features as well as some features previously only available through the object model. We have used tabs to group options logically. Let’s take a brief look. (Note, this is more detailed than the rest of the post, but since I am feeling productive today, and since many of the changes we made were in direct response to places where we had received a bunch of customer feedback, I decided to walk through the dialogs and highlight some of the changes we made.)
字段設(shè)置和數(shù)據(jù)透視表選項(xiàng)對話框
RIBBON的目的是為絕大多數(shù)用戶提供所有的功能。更高級的選項(xiàng)可利用在字段設(shè)置對話框和數(shù)據(jù)透視表選項(xiàng)對話框。這兩個對話框在以前的Excel版本中就存在了，現(xiàn)在我們已經(jīng)將其升級以實(shí)現(xiàn)兩個功能：第一是將各種選項(xiàng)更直觀地歸類，第二是包含新功能的設(shè)置和以前只能通過對象模型才能實(shí)現(xiàn)的那些功能的設(shè)置。我們已經(jīng)使用標(biāo)簽將選項(xiàng)邏輯地分組。讓我們大致來看一下。（注：這比本文其余部分更詳細(xì)，但由于我覺得今天比較能寫，而且我們所做的許多更改是對我們收到的一連串用戶反饋的直接回應(yīng)，所以我決定詳細(xì)講一下這些對話框并重點(diǎn)說明我們所做的一些改變。）
Here is a screenshot of the first tab of the new Field Settings dialog for a field on rows or columns – this allows users to set a number of options on a field-by-field basis.
這是一個行或列字段新的字段設(shè)置對話框的第一個標(biāo)簽的截圖——在這里允許用戶設(shè)置各個字段的基本選項(xiàng)。
On this tab there is a checkbox for “Display items from the next field in the same column”. With this you can control on an individual field basis whether to display items of that field in the new compact form or not (see my previous post for an explanation of the three forms – Compact Form, Tabular Form and Outline Form). And here is the second tab of the Field Settings dialog.
在此標(biāo)簽中有一個復(fù)選框，在同一列中顯示下一個字段的項(xiàng)目。這里你可以控制每一個單獨(dú)字段的基本要素，即是否在新的緊湊形式下顯示該字段項(xiàng)目（詳見我以前的文章 previous post，那里講明了三種形式：緊湊形式、平板形式、大綱形式）。下面是字段設(shè)置對話框的第二個標(biāo)簽。
The new “Include New Items in Filter” checkbox allows you to control whether new items appearing in the source data will automatically show up in the PivotTable when the field is manually filtered ("manually filtered" meaning not all items are checked in the filter UI).
新的“在篩選里包含新項(xiàng)目”的復(fù)選框允許你控制當(dāng)字段為手動篩選時源數(shù)據(jù)里的新項(xiàng)目是否自動顯示在數(shù)據(jù)透視表中（手動篩選意味著不是所有的項(xiàng)目都在篩選界面上被選中）。
Next, here are some screenshots of the PivotTable Options dialog – on each screenshot, I will try and point out something new to Excel 12 or that may be interesting to frequent PivotTable users … if folks have further questions, please post comments.
以下是數(shù)據(jù)透視表選項(xiàng)對話框的一些截圖——在每一個截圖中，我將試圖列出Excel12中的新東西或大多數(shù)數(shù)據(jù)透視表用戶感興趣的東西……如果有其它問題，請回貼。
The first tab allows users to control layout and format options for the entire PivotTable.
第一個標(biāo)簽允許用戶控制整個數(shù)據(jù)透視表的布局及格式選項(xiàng)
The “Compact Row Axis indent” control allows you to control how the extent to which fields added to the rows area are indented when they are added to the PivotTable.
當(dāng)你給數(shù)據(jù)透視表添加行字段時，“Compact Row Axis 縮進(jìn)”控制項(xiàng)允許你控制這個字段的行縮進(jìn)量.
The next tab deals with options relating to totals and filtering.
下一個標(biāo)簽與總計(jì)和篩選有關(guān)。
The “Use Custom Lists when sorting” checkbox allows you to control whether sorting items on rows or columns will take custom lists into account. For example, if this checkbox is checked, we will sort labels that represent months in logical data order (Jan, Feb, Mar) as opposed to in alphabetical order (Feb, Jan, Mar).
“在排序時使用自定義序列”復(fù)選框允許你控制在按行或列排序項(xiàng)目時是否使用自定義序列。例如，如果選中此項(xiàng)，我們將把代表月份的標(biāo)志按數(shù)字順序排列（JAN、FEB、MAR）而不是按字母表順序排列（FEB、JAN、MAR）
The next tab contains options on displaying different components of PivotTables.
下一個標(biāo)簽包含控制顯示數(shù)據(jù)透視表不同部分的選項(xiàng)
“Show Drill Buttons” turns on and off the Expand/Collapse indicators in the PivotTable. This checkbox is similar to the “+/- buttons” button in the ribbon.
“show drill buttons”控制數(shù)據(jù)透視表中展開/折疊指示器的開關(guān)。這個復(fù)選框類似RIBBON上的“+/-”按鈕。
“Tooltips with member properties” controls whether member properties are displayed in tooltips when hovering over items on rows and columns (only applicable to PivotTables based on OLAP data sources).
“成員屬性工具提示”控制當(dāng)鼠標(biāo)停留在項(xiàng)目的行和列上面時是否在工具提示上顯示成員屬性（只有當(dāng)數(shù)據(jù)透視表基于OLAP數(shù)據(jù)源時才有效）。
“Tooltips on cells” controls whether tooltips are displayed when hovering over cells inside the PivotTable row, column and values areas. These tooltips contain information about the context (row, column and value information) to make it easier to interpret a large PivotTable where all the items and headers might be scrolled out of sight.
“單元格工具提示”控制當(dāng)鼠標(biāo)停留在數(shù)據(jù)透視表的行、列及值區(qū)域里的單元格上面時是否顯示工具提示。這些工具提示包含上下文的信息（行、列、及值信息），讓我們很容易了解這個大的數(shù)據(jù)透視表（有可能這個數(shù)據(jù)透視表的所有項(xiàng)目及標(biāo)題都滾動到了看不見的地方）。
When the “Classic PivotTable layout (enables drag/drop of fields in the grid)” checkbox is checked, we will display drop zones in the grid and you can drag/drop fields from the field list to these drop zones as well as move fields between them.
當(dāng)這個“經(jīng)典的數(shù)據(jù)透視表布局(在柵格里可以拖拽字段)”的復(fù)選框被選中時，就會在柵格里顯示拖拽區(qū)域，然后你就可以從字段列表里拖拽字段到這些拖拽區(qū)域，也可以在拖拽區(qū)域之間拖拽字段。
The “Show items with no data on rows” and “Show items with no data on columns” checkboxes only applies to PivotTables based on OLAP data sources. They control whether we use the NON EMPTY keywords when querying the OLAP server. As an example, if you are looking at sales data by product groups, when these checkboxes are checked, the PivotTable will display a product group even if no sales were ever made for this product group. By default these checkboxes are not checked and we do not show items with no data. While this is available in the object model in current versions of Excel, we get a lot of customer requests to see this in the product, so we elevated it to mainline UI.
“顯示無行數(shù)據(jù)項(xiàng)目”和“顯示無列數(shù)據(jù)項(xiàng)目”復(fù)選框只對基于OLAP數(shù)據(jù)源的數(shù)據(jù)透視表有效。它們控制我們在查詢OLAP服務(wù)器時是否使用NON EMPTY關(guān)鍵字。例如，如果你在產(chǎn)品組中查看銷售數(shù)據(jù)，當(dāng)這些復(fù)選框被選中時，即使在此組產(chǎn)品中沒有銷售記錄，數(shù)據(jù)透視表也將顯示此產(chǎn)品組。。默認(rèn)狀態(tài)下這些復(fù)選框是沒有選中的，所以我們不會顯示沒有數(shù)據(jù)的項(xiàng)目。雖然當(dāng)前的Excel版本的對象模型中這些功能可用，但許多用戶要求在產(chǎn)品中看到此功能，于是我們將其提升到了主要用戶界面中。
Here is the Printing tab.
以下是打印標(biāo)簽
When the “Print drill buttons” checkbox is checked, the expand/collapse indicators in the PivotTable will be included when printing.
當(dāng)“Print drill buttons”復(fù)選框被選中時，數(shù)據(jù)透視表中的展開/折疊指示器將在打印時一起被打印出來。
Finally, some choices around data in the PivotTable.
最后，關(guān)于數(shù)據(jù)透視表數(shù)據(jù)的一些選項(xiàng)
The “Number of items to retain per field” textbox/drop down controls whether the PivotTable will “remember” items even when they no longer exists in the source data so that if they ever reappear, they will be treated like they were before they were deleted. If you don’t want these “ghosted” items to be “remembered”, just set this setting to “None”. This setting was previously only exposed in the object model. We got consistent feedback from many customers needing an easy way to turn this off so we added it to the PivotTable Options dialog.
“保留每個字段項(xiàng)目的數(shù)量”文本框/下拉選項(xiàng)控制數(shù)據(jù)透視表能夠“記住”的項(xiàng)目數(shù)，即使在源數(shù)據(jù)中它們已經(jīng)不再存在，這樣，在項(xiàng)目重新出現(xiàn)時，它們將以其被刪除前的狀態(tài)出現(xiàn)。如果你不想這些鬼魂一樣的東西再現(xiàn)，將這個選項(xiàng)設(shè)為“NONE”即可。這個設(shè)置以前只在對象模型中才能實(shí)現(xiàn)。我們從許多用戶處得到同樣的反饋，說是需要一種簡單的方法關(guān)閉這個功能，于是我們將其添加到數(shù)據(jù)透視表選項(xiàng)對話框中。
