Export to XLS cause image to export in grayscale images.
We are using the crystal report 13 engine to print or preview reports. When our customers export their reports to Excel (.xls) images (read from binary field in database) are saved as grayscale images in the generated Excel file.
When I uncheck the "Retain Original Image Color Depth" option in the main report, the images are in color (OK). But I've enabled this option in the past with previous Crystal Reports engine to avoid color loss, halftone or color patterns. In my mind, when this option is enabled, Crystal Report must keep the original image colors. It should not turn them in grayscale.
The images are store in the database in binary fields using the Tiff file format. Is the file format causing me some trouble I'm not aware of?
We also have noticed that images are coming out in grayscale when they are greater than a specific size in pixels or file size (don't know exactly which one is because they are tightly coupled).
Is Crystal Report runtime 13 need the option "Retain Original Image Color Depth" to be set to avoid color loss. We need to keep original colors.
Any idea if it is a limitation or a bug?
Any known workaround?