Hi,
Hi Yashali,
Thanks for your posting and using Aspose.Cells.
Please download and try the latest version: Aspose.Cells
for .NET v8.4.2.1 and see if it makes any difference and resolves your issue.
If your issue still occurs, then please provide us your sample project illustrating your issue in detail. It will help us look into your issue more closely and precisely and we will be able to help you asap.
Hi,
Hi Yashali,
Thanks for your posting and using Aspose.Cells.
We are afraid, 3.5 and above version is not available at this moment. Kindly provide us your sample project with the v8.4.1 and v8.4.2. It will be helpful for us to investigate the issue. Thanks for cooperation.
Hi,
Hi,
Hi,
Thanks for your sample code and explanation and using Aspose.Cells.
We were able to observe this issue and found that latest version reads the properties in reverse and these properties are swapped.
We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as
- CELLSNET-43683 - Aspose 8.4.2 reads chart properties incorrectly and are swapped
Hi,
Thanks for using Aspose.Cells.
Please download and try the latest fix: Aspose.Cells
for .NET v8.4.2.7 and let us know your feedback.
By default, the series in SeriesCollection are ordered by the order in the excel file.
Please try the new fix. We provide a new method GetSeriesByOrder(int) for your requirement.
C#
string path = @"D:\Aspose\User\1004";
Workbook workbook1 = new Workbook(path + “sample1.xlsm”);
Workbook workbook2 = new Workbook(path + “sample2.xlsm”);
Series series0 = workbook2.Worksheets[0].Charts[0].NSeries.GetSeriesByOrder(0);
Console.WriteLine("wb2 name Nseries0 : " + series0.DisplayName);
Console.WriteLine("wb2 foreground color Nseries0 : " + series0.Area.ForegroundColor);
Series series1 = workbook2.Worksheets[0].Charts[0].NSeries.GetSeriesByOrder(1);
Console.WriteLine("wb2 name Nseries1 : " + series1.DisplayName);
Console.WriteLine("wb2 foreground color Nseries1 : " + series1.Area.ForegroundColor);
Series series2 = workbook2.Worksheets[0].Charts[0].NSeries.GetSeriesByOrder(2);
Console.WriteLine("wb2 name Nseries2 : " + series2.DisplayName);
Console.WriteLine("wb2 foreground color Nseries2 : " + series2.Area.ForegroundColor);
series0 = workbook1.Worksheets[0].Charts[0].NSeries.GetSeriesByOrder(0);
Console.WriteLine("wb1 series name Nseries0 : " + series0.DisplayName);
Console.WriteLine("wb1 series type Nseries0 : " + series0.Type);
series1 = workbook1.Worksheets[0].Charts[0].NSeries.GetSeriesByOrder(1);
Console.WriteLine("wb1 series name Nseries1 : " + series1.DisplayName);
Console.WriteLine("wb1 series type Nseries1 : " + series1.Type);
The issues you have found earlier (filed as CELLSNET-43683) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
Hi,
Thanks for your posting, appreciating and using Aspose.Cells.
We have tested this code with the latest version 8.6.0 and the older version 8.4.1 and the results match as you have shown in your post.
Please explain in detail why 8.4.1 result is correct than 8.6.0 so that we could log this issue in our database for investigation and fix. Thanks for your cooperation.
Hi,
Hi,
Thanks for your clarification and using Aspose.Cells.
We were able to observe this issue and logged it in our database for investigation. We will look into it and fix this issue if possible. Once there is some fix or other update for you, we will let you know asap.
This issue has been logged as
- CELLSNET-43956 - Chart properties later than v8.4.1 are read incorrectly
Hi,
Thanks for using Aspose.Cells.
We have applied new rule for series collection later than v8.4.1. Actually, we think the older version is incorrect.
For your requirement, you must call new method SeriesCollection.GetSeriesByOrder(int). It should fix your issue. Let us know your feedback.
Please see the screenshot for more clarification of this issue.
I can see what’s happening now! Thanks I used the new method. It works fine!
Hi,