Aspose Cells - ignore images background for attached text blocks and series

Aspose.Cells Product Family
1

When trying to render a worksheet as Tiff image, the background color of specific cells and embedded objects (Text Box and Data Series) is completely ignored in the rendered image/

2

@SamManoff,

Thanks for the details.

Please attach your template Excel file and output image files (you may zip the files prior attaching here). Also paste your sample code (runnable) to reproduce the issue on our end, we will check it soon.

3

XLS Legal Port.zip (40.1 KB)

4

@SamManoff,

Thanks for the template file and output tiff image.

I found you are using CompressionCCITT4 as tiff compression type, so the output image will use black and white colors only. Please use CompressionLZW as tiff compression to get your desired output image. See the following sample code for your reference:
e.g
Sample code:

Workbook workbook = new Workbook("e:\\test2\\XLS Legal Port.xls");

            ImageOrPrintOptions opts = new ImageOrPrintOptions();
            opts.ImageType = ImageType.Tiff;
            opts.TiffCompression = Aspose.Cells.Rendering.TiffCompression.CompressionLZW;//Please do not use CompressionCCITT3 or CompressionCCITT4 as tiff compression type, it will render black/white image 

            Worksheet sheet = workbook.Worksheets[0];
            SheetRender renderer = new SheetRender(sheet, opts);
            renderer.ToImage(0, "e:\\test2\\out.tiff");

Hope, this helps a bit.

5

Hi Amjad
Unfortunately the image has to be be generated using CCITT4 / CCITT3 compression as this is what is required for fax CTI transmission. We are generating such images using Aspose Docs and Aspose Slides and the background is rendered reasonably well.
The problem seems to be specifically related to Excel rendering using Aspose.Cellls.

Regards, Sam

6

@smanoff,

I am not sure if Tiff compression CCITT4 / CCITT3 type could itself render colored images. Could you provide us your desired CCITT4 / CCITT3 compression type tiff image from the Excel file, we will check it soon.

7

Hi Amjad
Here is an example of the required generated image - using CCITT4 - of course it is rendered black and white and the background is gray scaled as you’d expect.

Please review.

LegalPort_1D50EFB0BF84D.zip (11.7 KB)

8

Hi Again
Here is another example - this image was generated using Aspose.Words - I simply copied the Excel content into a new word document and used Aspose.Words to render it as required - The result as you can see, looks reasonably clear and the background was captured just fine.
Cheers, Sam.

XLS_LegalPort_doc.zip (71.7 KB)

9

@SamManoff,

Thanks for your desired output image files.

We evaluated it further and found an issue where Tiff compression type CompressionCCITT3 and CompressionCCITT4 ignores background shading for charts and shapes. I have logged a ticket with an id “CELLSNET-46739” for your issue. We will look into it to figure it out soon.

Once we have an update on it, we will let you know.

10

@SamManoff,
Please try our latest version/fix: Aspose.Cells for .NET v19.5.7 (attached).

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells19.5.7 For .Net2_AuthenticodeSigned.Zip (4.9 MB)
Aspose.Cells19.5.7 For .Net4.0.Zip (4.9 MB)

11

The issues you have found earlier (filed as CELLSNET-46739) have been fixed in Aspose.Cells for .NET v19.6. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi

12

Hi Amjad
The new version of Aspose Cells seems to have resolved the issue.

Thanks for your support.
Sam.

13

@SamManoff,

Good to know that your issue is sorted out by the new fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.