How to export merged cell to excel by UltraGridExcelExporter

270

Chen posted over 16 years ago

Hi~

I met thefollowing issue when using UltraWinGrid..

When I try to export data with merged cells to excel, all of the merged cells are no longer merged in the exported excel file. Does that mean excel exporter does not support merged cell in win grid? Should I manually write merge logic in the events of exporter? If so, how can I set the merge cell when exporting data?

Thank you~

700

Ravi posted over 15 years ago in reply to john

Hi, ultraCheckEditorMergeCells - is this a control ?
Cancel
Reply

Cancel
685

john posted over 15 years ago in reply to Ravi

Excel export works fine - picks up merged state. It is PDF export that does not have as many features.

private void ultraGridExcelExporter1_CellExported(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.CellExportedEventArgs e)

{

if (this.ultraCheckEditorMergeCells.Checked != true

return ;

)
Cancel
Reply

Cancel
700

Ravi posted over 15 years ago in reply to Mike Saltzman

Hi Mike, I am into a similar situation where I need the cell merging to be available in the exported excel sheet. Is there any improvements on the subject. I am using version 7.2 Do let me know if there is a solution. Thanks
Cancel
Reply

Cancel
469350

Offline Mike Saltzman posted over 15 years ago in reply to john

I don't beleive this is currently supported for PDF exporting, either. You should once again Submit a feature request to Infragistics.
Cancel
Reply

Cancel
685

john posted over 15 years ago in reply to Mike Saltzman

And DocumentExporter for PDF ?
e.GridRow.Index ; // .CurrentColumnIndex;
can change but ,

e.CurrentWorksheet.MergedCellsRegions.Add( rowIndex, colIndex, rowIndex + (mergedCells.Length - 1), colIndex);

causes a problem ?????

please ?
Cancel
Reply

Cancel