Wiki Markup |
---|
{introducedin: 8.4} {description} {excerpt}Sets or returns the caption displayed in place of an error.{excerpt} {signature:C#} public System.String FriendlyErrorCaption{ get; set; } {signature} {signature:vb.net}Public Property FriendlyErrorCaption() As String {signature} {example}{code:csharp|title=C#} ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Open(@"C:\MySpreadsheet.xlsx"); Worksheet ws = wb.Worksheets[0]; ws.PivotTables[0].PivotTableSettings.FriendlyErrorCaption= "ErrorCell"; {code} {code:vbnet|title=vb.net} Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Open("C:\MySpreadsheet.xlsx") Dim ws As Worksheet = wb.Worksheets(0) ws.PivotTables(0).PivotTableSettings.FriendlyErrorCaption= "ErrorCell"; {code} {example} {remarks}{{FriendlyErrorCaption}} is only displayed when [ShowFriendlyErrorCaption|PivotTableSettings.ShowFriendlyErrorCaption] is {{true}}. {remarks} |
Page History
Overview
Content Tools