Hi GemBox Team,
loading a PowerPoint file with a diagram whose data basis is a spreadsheet seems to fail, when the referenced spreadsheet cannot be found.
This is the exception:
System.ArgumentException: Row or column index is invalid or out of required range.
at GemBox.Spreadsheet.CellRange.(Int32 , Int32)
at GemBox.Spreadsheet.CellRange.get_Item(Int32 relativeRow, Int32 relativeColumn)
at GemBox.Spreadsheet.CellRange.get_Item(Int32 contextIndex)
at .(CellRange ,`1)
at GemBox.Spreadsheet.Charts.ChartHelper.PopulateExcelFileWithChartData( cachedData, ExcelFile file)
at GemBox.Spreadsheet.Charts.ChartHelper.GenerateFileFromChartCachedDataCore( cachedData, ExcelChart chart, Boolean forInvalidReferencesOnly, Func`2 themeColorResolver)
cachedData, ExcelChart chart, Boolean forInvalidReferencesOnly, Func`2 themeColorResolver)
at GemBox.Spreadsheet.Charts.ChartHelper. )
at.( , Action`1)
at.(Stream , Action`1)
at GemBox.Spreadsheet.Charts.ChartHelper.ReadChartCore(Stream stream, Boolean preserveUnsupportedFeatures, ICollection`1 relationshipIds, Func`2 getPictureContent, Boolean generateFileFromChart, Func`2 themeColorResolver)
at GemBox.Spreadsheet.Charts.ChartHelper.ReadChart(ValueTuple`6 arg)
at .(Stream , Boolean, ICollection`1 , Func`2 , Boolean , Func`2 , Object& , Object& )
at .(GraphicFrame )
at .⸮
t GemBox.Presentation.PptxLoadOptions.2avatad2rqgmrafexv9mnuesdacaxjhrresentationDocument , Stream, String )
When I open it in PowerPoint itself, I cannot edit the data either, but the diagram is visible:
Can I somehow handle it and load the file anyway just with the diagram data it shows? Or if this is not possible just load the other contents of the file without the diagrams based on external files?
Best regards,
Sarah