I am using the UltraGridExcelExporter to export my grid to an Excel spreadsheet. I figured out how to format my datetime columns. But, there are two issues I can't figure out.
1. How do I prevent borders around the resulting spreadsheet cells? I've tried many different ways of formatting the grid's cell borders before exporting, but I still get a solid black border around each exported cell.
2. When I open the resulting Excel spreadsheet, I am unable to format any of the cells by right-clicking and selecting "Format Cells..." nor by using the "Format" menu item. I can click them, but nothing happens.
Thanks,Dan
Hi Dan,
1) Do you want no borders at all? Or just the default borders in Excel?
2) I think this is a known bug that was already fixed. Do you have the latest Hot Fix?
Hi Mike,
I would like just the default borders in Excel. I tried modifying the borderstyle, etc... of the grid before exporting, but that didn't work.
I will double-check that we have the latest hot fix.
I'm not sure if this is currently supported. The grid has borders on the cells by default and I think it automatically copies those settings to the Excel cells. You might be able to trap the CellExported event of the UltraGridExcelExporter and see if there is some property on the WorkSheetCell that is exposed that might let you reset the borders.