Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Darren
285
UltragridExcelExporter - The indent level must be between 0 and 15.
posted

Hello,

 

I am using the excel exporter to export a grid to an existing workbook/worksheet.  I only have a single band but the export crashes with the error below.

I am using Exporter V2.0 with VS 2005 / Excel 2003.

Note that the export works if I create a new XLS when exporting rather than use an existing worksheet.

 Dim Workbook As Infragistics.Excel.Workbook = Workbook.Load(Filename)

UltraGridExcelExporter1.Export(ugFundProcessing, Workbook)

 

I have tried playing with the indent level but no joy. I only have a single band anyway.

Is there anything else I can try?

regards

Darren

 

{"The indent level must be between 0 and 15.
Parameter name: value
Actual value was -1."}

 

   at Infragistics.Excel.WorksheetCellFormatData.set_Indent(Int32 value)
   at Infragistics.Excel.WorksheetCellFormatProxy.set_Indent(Int32 value)
   at Infragistics.Excel.WorksheetCellFormatProxy.SetValue(CellFormatValue valueToSet, Object value)
   at Infragistics.Excel.Utilities.CopyCellFormatValue(WorksheetCellFormatProxy sourceCellFormat, WorksheetCellFormatProxy targetCellFormat, CellFormatValue value)
   at Infragistics.Excel.WorksheetMergedCellsRegion.Infragistics.Excel.IWorksheetCellFormatProxyOwner.OnCellFormatValueChanged(CellFormatValue value)
   at Infragistics.Excel.WorksheetCellFormatProxy.OnPropertyChanged(CellFormatValue value)
   at Infragistics.Excel.WorksheetCellFormatProxy.SetFormatting(IWorksheetCellFormat source)
   at Infragistics.Excel.WorksheetMergedCellsRegion..ctor(Worksheet worksheet, Int32 firstRow, Int32 firstColumn, Int32 lastRow, Int32 lastColumn)
   at Infragistics.Excel.WorksheetMergedCellsRegionCollection.Add(Int32 firstRow, Int32 firstColumn, Int32 lastRow, Int32 lastColumn)
   at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter.ExportBandHeaderRow(UltraGridExporterHelper exportHelper, UltraGridRow row, UltraGridBand band)
   at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter.ProcessHeaderRows(UltraGridExporterHelper exportHelper, UltraGridRow row, UltraGridBand band)
   at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter.ProcessGridRowInternal(UltraGridExporterHelper exportHelper, UltraGridRow row, ProcessRowParams processRowParams)
   at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExporterHelper.ProcessRow(UltraGridRow row, ProcessRowParams processRowParams)
   at Infragistics.Win.UltraWinGrid.RowsCollection.InternalTraverseRowsHelper(IUltraGridExporter exporter)
   at Infragistics.Win.UltraWinGrid.UltraGrid.Export(IUltraGridExporter exporter)
   at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter.Export(UltraGrid grid, Worksheet worksheet, Int32 startRow, Int32 startColumn)
   at Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter.Export(UltraGrid grid, Worksheet worksheet)
   at IAIFormulaEngine.ReportingMethodMaint.GenerateTemplate()
   at IAIFormulaEngine.ReportingMethodMaint.ToolbarMain_ToolClick(Object sender, ToolClickEventArgs e)
   at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.OnToolClick(ToolClickEventArgs e)
   at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.FireEvent(ToolbarEventIds id, EventArgs e)
   at Infragistics.Win.UltraWinToolbars.ToolBase.OnToolClick()
   at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.DoClickProcessing(MouseEventArgs e)
   at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.OnMouseUp(MouseEventArgs e)
   at Infragistics.Win.ControlUIElementBase.ProcessMouseUpHelper(Object sender, MouseEventArgs e)
   at Infragistics.Win.ControlUIElementBase.ProcessMouseUp(Object sender, MouseEventArgs e)
   at Infragistics.Win.Utilities.ProcessEvent(Control control, ProcessEvent eventToProcess, EventArgs e)
   at Infragistics.Win.UltraControlBase.OnMouseUp(MouseEventArgs e)
   at Infragistics.Win.UltraWinToolbars.UltraToolbarsDockArea.OnMouseUp(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

 

Parents
No Data
Reply
  • 469350
    Offline posted

    I can't see any reason why you should get the error if you only have a single band in the grid, unlessyou are using OutlookGroupBy.

    Perhaps something in the existing worksheet that is causing a problem, or already has indentations applied. If you can post a small sample project demonstrating this exception, we would be happy to take a look.

    You should not have to do this, but just as a workaround, try setting the OutliningStyle property on the UltraGridExcelExporter to None or IgnoreDepthOverflow.

    Another thing you could try is to handle the BeginExport event and set some properties on the layout:

    


            private void ultraGridExcelExporter1_BeginExport(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.BeginExportEventArgs e)
            {
                e.Layout.MaxBandDepth = 1;
                e.Layout.ViewStyle = Infragistics.Win.UltraWinGrid.ViewStyle.SingleBand;
            }

     

     

     

Children