I'm using an Ultrawingrid and ultragridexcelexporter.
Since ultraGridExcelExporter.DefaultWorkbookPaletteMode is obsolete i have in my created exceldokument for every image a fillcolor in excel set. Every image has a blue background. Any idea why? how can i set the color manually? And i tried to set in the ultraGridExcelExporter1_CellExporting event to set the value of an imagecoloum to null, which did'nt work.
We use an Imagelist with no set transparetn color, should i set one?
Hi Thomas,
I'm having a hard time understanding the issues you are describing.
Thomas said:Since ultraGridExcelExporter.DefaultWorkbookPaletteMode is obsolete i have in my created exceldokument for every image a fillcolor in excel set. Every image has a blue background. Any idea why? how can i set the color manually?
I don't understand what this means or what the problem is. It sounds like you are trying to apply a background color to a cell in the Excel document, and it's not working. But without knowing what your code is doing, I'm afraid I can't guess why it's not working. Could you post a small sample project demonstrating the issue so I can check it out?
Thomas said: And i tried to set in the ultraGridExcelExporter1_CellExporting event to set the value of an imagecoloum to null, which did'nt work.
I don't know what you mean by "value of an imagecolumn". Are you talking about the grid column? Or the cell in the spreadsheet? What are you trying to do - prevent the image from exporting?
Thomas said:We use an Imagelist with no set transparetn color, should i set one?
What does the ImageList or TransparentColor have to do with it?
i have a ultrawingrid with a ImageColumn. the Grid displays the image as ecpected. now i export the grid to excel an die image has a blue backgroundcolor. I know sometime in the past the exceldoc. was displayed without the backcolor.
than i have tried to remove the image in the exporter-events, but this did not work. i wanted to set e.gridrow.cells[xy].Value = null to remove the image fpr the excelexport.