Series fill- "invert if negative" does not work

Aspose.Cells Product Family
1

We have the aspose Cells 5.3.3.2 installed and I noticed that when we have the option "invert if negative" selected for a solid series fill the chart looks fine in excel 2010 but when the chart gets rendered the negative fill is always white.

Is it possible to have the negative fill be what is defined in the file (see attached)

Thanks

2

Hi,

I have tested your issue. When I open your template Excel file into MS Excel 2007, it does show the series fill with white color
but displaying the chart into MS Excel 2010 series has red background
color. Well, I think it is the behavior of MS Excel versions, you may check it. For XLSX file, the chart would be rendered accordingly what is shown in MS Excel 2007.

Anyways, I have also added a ticket with an id: CELLSNET-28193. We need to investigate and check if we can enhance it according to Excel 2010 version. Once we have any update, we will let you know.

Thank you.


3

Hi,


We have released a fix version of Aspose.Cells for .NET v5.3.3.5 [attached].
I have verified through my below source code that your said issue has been taken care of in this release. My output file is attached for your reference. Please test your scenario and let us know of your results.
Thank you.

C# Code

var options = new ImageOrPrintOptions();

options.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg;

MemoryStream msChart = new MemoryStream();

Workbook wb = new Workbook(“c:\temp\Invert+if+negative+series+fill.xlsx”);

Chart chart = wb.Worksheets[1].Charts[0];

chart.ToImage(@“c:\temp\outputJpeg.jpg”, options);

4

Hi,

We have fixed this issue. Please download Aspose.Cells for .NET v5.3.3.6.

We have solved the invert issues for Excel 2010.