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.
I can't think of any reason or any circumstance in which exporting an image would change the background color of the image. My best guess is that something in your code is doing that.
I'm not even sure how the exporter could possible even know what the background color of the image is. Images don't have a background color. So are you saying that your image is transparent and the background color of the cell is showing through? Perhaps you need to remove the color you are applying to the cell.
Hello Thomas,
I am attaching a sample that uses our latest service release for NetAdvantage 13.1. It includes an ImageList and and places the image into a cell. The grid can be exported by clicking the button provided. When you open the excel file generated and saved in the project's directory you can see that the image has not been changed. Please attempt to reproduce the issue with this sample or send us one so we can see what you are doing more closely. If you have any additional questions feel free to ask.