Hi,
When calling chart.Calculate() on some specific combo charts, Aspose will sometimes error. When trying to reproduce a client doc (that unfortunately can’t be shared at the moment) I ran into the exception System.InvalidCastException : Specified cast is not valid. In a similar vein on that actual client doc we were seeing System.FormatException : Input string was not in a correct format. at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt) at System.String.System.IConvertible.ToDouble(IFormatProvider provider) when trying to calculate the combo chart on their document.
Any help would be greatly appreciated! I’ve attached a test file that reproduces the Specified cast is not valid exception.
Repro code:
var format = FileFormatUtil.DetectFileFormat("ComboChart_Broken.xlsx");
var asposeLoadOptions = new LoadOptions(format.LoadFormat)
{
LoadFilter = new LoadFilter(LoadDataFilterOptions.All)
};
using (var workbook = new Workbook("ComboChart_Broken.xlsx", asposeLoadOptions))
{
workbook.Worksheets[0].Charts[0].Calculate();
}
Thanks!
ComboChart_Broken.zip (15.7 KB)