Wiki Markup |
---|
{introducedin: 8.4} {description} {excerpt}Sets or returns whether Microsoft Excel will automatically show a caption in place of an error.{excerpt} {signature:C#} public boolean ShowFriendlyErrorCaption{ get; set; } {signature} {signature:vb.net}Public Property ShowFriendlyErrorCaption() As Boolean {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.ShowFriendlyErrorCaption= true; {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.ShowFriendlyErrorCaption= true; {code} {example} {remarks}{{ShowFriendlyErrorCaption}} is {{false}} by default. If it is set to true, {{[FriendlyErrorCaption|PivotTableSettings.FriendlyErrorCaption]}} also needs to be set. {remarks} |
Page History
Overview
Content Tools