Request is to have the ability preferably using a mouse drag to change the height of the column headers in the grid. We can already do that for data rows of the grid, but it is not possible currently to do the same for the header row.
RunExport(filename) method generates a System.UnauthorizedAccessException, Access to the path "C:\..." is denied. given that I`m the administrator and I`m able to export crystal report documents (all formats) with no issues at all. what could be the issue. below is the sample code: SaveFileDialog svd = new SaveFileDialog(); svd.FileName = "AnyThing"; svd.Filter = "Excel files (*.xls)|"; if (svd.ShowDialog() == DialogResult.OK) { PivotExportToExcelML exportExcel = new PivotExportToExcelML(radPivotGrid1); exportExcel.ShowGridLines = true; exportExcel.ExportVisualSettings = true; exportExcel.HeaderCellsFont = new System.Drawing.Font("Arial", 8); exportExcel.DataCellsFont = new System.Drawing.Font("Arial", 8); exportExcel.GridLinesColor = Color.Black; exportExcel.CellBackColor = Color.White; exportExcel.SheetName = "Test"; exportExcel.ExportFlatData = false; exportExcel.RunExport(Path.GetDirectoryName(svd.FileName)); }
DECLINED: The cells remain bold because there is no explicit setting for the Font property in the default state of the PivotCellElement. When one sets a style for a given element state, this setting will also remain for other states if they don't have an explicit setting for the same property. This is how our theming mechanism works. To resolve the issue, just set the Font property of the PivotCellElement in its default state in Visual Style Builder. To reproduce: Open ControlDefaultTheme in VisualStyleBuilder, go to RadPivotGrid -> RadPivotGridElement -> PivotCellElement and set bold font for the PivotCellElement.GrandTotalRow. Bind RadPivotGrid and set the properties AutoExpandColumnHeaders to false and AutoExpandRowHeaders to false. Start the application and expand the rows. You will see that the cells will be incorrectly formatted.
PivotGrid get all the rows that 'lie' beneath a visible cell value