I have a column that acts as a marker if there is a message associated with the row or not. During export is it possible to substitute the marker with the actual message?
Hi,
jquerijero said:Can you do same thing during the exportING event instead?
Not really. The problem with exportING is that it fires before the UltraGridExcelExporter writes the value from the grid into the Excel Worksheet cell. So whatever you write to the cell inside the "-ING" event will just get overwritten.The only way to handle this in the "-ing" event would be to change the actual value of the grid cell - which you obviously don't want to do, since this will affect the on-screen grid and the real data. So you should use CellExported.
jquerijero said:I'm just trying to see if it is also possible when exporting to PDF.
PDF is a different story, because it's forward-only and you cannot write directly into the IGridCell, anyway.
The way to do this for PDF is to use the CellExporting event and set the ExportValue property on the event args.
Can you do same thing during the exportING event instead? I'm just trying to see if it is also possible when exporting to PDF.
Well, if it's just text, then the easiest thing to do is handle the CellExported event of the UltraGridExcelExporter. Then you can simply set the Value of the cell in the Excel Worksheet to whatever you want. The event gives you the grid cell and also the current worksheet, row, and column indices.
Sorry, I want the message to be exported instead of the marker.
Just a column set to URL style that says Add (if no message) and Edit (has message).