Thanks for your posting and using Aspose.Cells.
You are right. The alternative property Marker.Border.Formatting does not exist and Marker.Border.FormattingType does not have “FormattingType.Custom”.
We have logged this issue in our database for investigation. We will look into it and provide you an alternative. Once, there is some update for you, we will let you know asap.
This issue has been logged as CELLSNET-42626.
I actually had this originally:
series.MarkerBackgroundColorSetType = FormattingType.Custom;
series.MarkerForegroundColorSetType = FormattingType.Custom;
I replaced the top one with what you suggest already (as that’s what the warning message said to do), but you are suggesting that .MarkerForegroundColorSetType can also be replaced by the same thing…
so is it the case that BOTH of the above can now be replaced by your suggestion?
Thanks for using Aspose.Cells.
Aspose.Charts.Series.MarkerForegroundColorSetType is designed for Excel 2003. In Excel 2007 or later, Marker is an object of series and replace Custom type with Solid type.
We think Excel 2003 will be not supported in the distant future. So we suggest it is best to use Marker.Border.Formatting property instead.
The relation is:
- FormattingType.Automatic is same as ChartLineFormattingType.Automatic.
- FormattingType.None is same as ChartLineFormattingType.None.
- FormattingType.Custom is same as ChartLineFormattingType.Solid.
Please check the attachment, it contains a simple test that illustrates how to set the border’s color of marker and fill color of marker.