Table of contents

DataLabel.FormulaR1C1 属性 (PowerPoint)DataLabel.FormulaR1C1 Property (PowerPoint)

office 365 dev account|上次更新日期: 2018/3/13
2 参与人员

返回或设置对象,用宏语言的 R1C1 样式表示法表示的公式。读/写,字符串Returns or sets the formula for the object, using R1C1-style notation in the language of the macro. Read/write String.


表达式FormulaR1C1expression. FormulaR1C1

表达式_一个表示数据标签对象的变量。_expression A variable that represents a DataLabel object.


如果单元格包含一个常量,此属性返回该常量。如果单元格为空,此属性返回一个空字符串。如果单元格包含公式,此属性将该公式作为字符串返回,所使用的格式与在公式栏中显示的格式相同(包括等号)。If the cell contains a constant, this property returns the constant. If the cell is empty, the property returns an empty string. If the cell contains a formula, the property returns the formula as a string, in the same format in which it would be displayed in the formula bar (including the equal sign).

如果将单元格的值或公式设置为日期,Microsoft PowerPoint 将检查该单元格的格式是否符合某种日期或时间数字格式;如果不符合,则将数字格式更改为默认短日期数字格式。If you set the value or formula of a cell to a date, Microsoft PowerPoint verifies whether that cell is already formatted with one of the date or time number formats. If not, the number format is changed to the default short date number format.

如果区域是一维或二维区域,则可以将公式设置为相同维数的 Visual Basic 数组。同样,也可以在 Visual Basic 数组中使用公式。If the range is a one-dimensional or two-dimensional range, you can set the formula to a Visual Basic array of the same dimensions. Similarly, you can put the formula into a Visual Basic array.

如果为多重单元格区域设置公式,则使用此公式填充该区域中的所有单元格。Setting the formula of a multiple-cell range fills all cells in the range with the formula.

另请参阅See also


DataLabel 对象DataLabel Object

© 2018 Microsoft