I tried changing the CellDataFormat while in the export process, from a handle to the WritingCell event on the ExcelExport object.
The exception I get if I try this is “Property setters or methods cannot be called when the component is currently exporting.”. Ok, so I can’t change the property when work has begun, I’ve established that.
So back to my question – is it possible to format the spreadsheet cells according to the data contained in the grid (part numeric, part text). Like I said before, if I use CellDataFormat.Value I keep getting an exception, and I’m assuming that’s down to the grid containing text as well as numeric data.
Imported from legacy forums. Posted by matt (had 294 views)