The name Excel uses to reference the slicer cache (the value of the SlicerCache.Name property). If omitted, Excel will generate a name. By default, Excel concatenates "Slicer_" with the value of the PivotField.Caption property for slicers with non-OLAP data sources, or with the value of...
BlockedErrorCellValueSubType BorderIndex BorderLineStyle BorderWeight BuiltInPivotTableStyle BuiltInSlicerStyle BuiltInStyle BuiltInTableStyle BusyErrorCellValueSubType CalcErrorCellValueSubType CalculationMode CalculationState CalculationType CellControlType CellValueType ChartAxisCategoryType ChartAxisDisplayUnit Chart...
SlicerCacheLevels SlicerCaches SlicerItem SlicerItem Properties Application Caption Creator HasData Name Parent Selected SourceName SourceNameStandard Value SlicerItems SlicerPivotTables Slicers SmartTag SmartTagAction SmartTagActions SmartTagOptions SmartTagRecognizer SmartTagRecognizers SmartTags Sort SortField ...
Learn more about the Microsoft.Office.Interop.Excel.IPivotValueCell.Creator in the Microsoft.Office.Interop.Excel namespace.
XlSlicerSort XlSmartTagControlType XlSmartTagDisplayMode XlSortDataOption XlSortMethod XlSortMethodOld XlSortOn XlSortOrder XlSortOrientation XlSortType XlSourceType XlSpanishModes XlSparklineRowCol XlSparkScale XlSparkType XlSpeakDirection XlSpecialCellsValue ...
ActiveSlicer 获取一个 对象,该对象表示活动工作簿或指定工作簿中的活动切片器。 (继承自 _Workbook) Application 在没有对象限定符的情况下使用时,此属性返回表示 Application Microsoft Excel 应用程序的 对象。 如果与对象识别符一起使用,则此属性返回代表指定对象的创建者的 Application 对象(可以将此属性与 OL...
ActiveSlicer 获取一个 对象,该对象表示活动工作簿或指定工作簿中的活动切片器。 (继承自 _Workbook) Application 在没有对象限定符的情况下使用时,此属性返回表示 Application Microsoft Excel 应用程序的 对象。 如果与对象识别符一起使用,则此属性返回代表指定对象的创建者的 Application 对象(可以将此属性与 OL...
This workbook contains Slicers that can be used to filter PivotTables and CUBE functions within the workbook. Slicers will not be saved. Formulas that reference Slicers will return a #NAME? error. What it means Slicers are not supported in Excel 97-2007 and cannot be shown. ...
This workbook contains Slicers that can be used to filter PivotTables and CUBE functions within the workbook. Slicers will not be saved. Formulas that reference Slicers will return a #NAME? error. What it means Slicers are not supported in Excel 97-2007 and cannot be shown. ...
Here you can control whether or not the slicer must be printed and should move/size with cells just like any other shape on a sheet. And you can turn off resizing and moving to prevent your users from messing with your layout.Changing a Slicer's font size...