Hello there,
I tried to load attached document via Workbook.Load(string fileName) method and has the following error:
An exception of type 'System.ArgumentOutOfRangeException' occurred in Infragistics4.Documents.Excel.v13.1.dll
Specified argument was out of the range of valid values.Parameter name: The specified index is is not valid in the collection.
at Infragistics.Documents.Excel.Utilities.VerifyCollectionIndex(Int32 index, Int32 count) at Infragistics.Documents.Excel.CustomTableStyleCollection.get_Item(Int32 index) at Infragistics.Documents.Excel.Serialization.BIFF8.BiffRecords.TABLESTYLEELEMENTRecord.Load(BIFF8WorkbookSerializationManager manager) at Infragistics.Documents.Excel.Serialization.BIFF8.BIFF8WorkbookSerializationManager.LoadCurrentRecord() at Infragistics.Documents.Excel.Serialization.BIFF8.BIFF8WorkbookSerializationManager.LoadWorkbookContents() at Infragistics.Documents.Excel.Serialization.WorkbookSerializationManager.Load() at Infragistics.Documents.Excel.Workbook.LoadBIFF8File(Workbook workbook, Stream stream, IPackageFactory packageFactory, Boolean verifyExcel2007Xml, String parameterName) at Infragistics.Documents.Excel.Workbook.LoadHelper(Stream stream, WorkbookFormat format, String parameterName, IPackageFactory packageFactory, Boolean verifyExcel2007Xml) at Infragistics.Documents.Excel.Workbook.Load(String fileName, IPackageFactory packageFactory, Boolean verifyExcel2007Xml) at Infragistics.Documents.Excel.Workbook.Load(String fileName, IPackageFactory packageFactory) at Infragistics.Documents.Excel.Workbook.Load(String fileName) at TallEmu.Studio.Excel.PriceListExporter.DoPriceListExport(Int32 priceListId) in d:\Projects\CRM_Studio\Trunk\Projects\WinStudio\Excel\PriceListExporter.cs:line 148 at TallEmu.Studio.RibbonForm.ProcessCommandExportPriceList(MetaCommand ACommand, MetaDataSource ASource, Dictionary`2 executionContext) in d:\Projects\CRM_Studio\Trunk\Projects\WinStudio\Forms\RibbonForm.cs:line 4570 at TallEmu.Studio.RibbonForm.ProcessRibbonItemCommand(String AItemKey, MetaCommand ACommand, MetaDataSource AContainerDatasource, RibbonScript AContainerDatasourceScript, ScriptClass AContainerDatasourceScript2, Dictionary`2 executionContext) in d:\Projects\CRM_Studio\Trunk\Projects\WinStudio\Forms\RibbonForm.cs:line 1614 at TallEmu.Studio.RibbonForm.ProcessRibbonItemCommands(String AItemKey, Dictionary`2 executionContext) in d:\Projects\CRM_Studio\Trunk\Projects\WinStudio\Forms\RibbonForm.cs:line 1236 at TallEmu.Studio.RibbonForm.ProcessRibbonItemCommands(String AItemKey) in d:\Projects\CRM_Studio\Trunk\Projects\WinStudio\Forms\RibbonForm.cs:line 1083 at TallEmu.Studio.RibbonForm.ToolbarsManager_ToolClick(Object sender, ToolClickEventArgs e) in d:\Projects\CRM_Studio\Trunk\Projects\WinStudio\Forms\RibbonForm.cs:line 8990 at Infragistics.Win.UltraWinToolbars.ToolClickEventHandler.Invoke(Object sender, ToolClickEventArgs e) at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.OnToolClick(ToolClickEventArgs e) at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.FireEvent(ToolbarEventIds id, EventArgs e) at Infragistics.Win.UltraWinToolbars.ToolBase.OnToolClick() at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.DoClickProcessing(MouseEventArgs e) at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.OnMouseUp(MouseEventArgs e) at Infragistics.Win.ControlUIElementBase.ProcessMouseUpHelper(Object sender, MouseEventArgs e) at Infragistics.Win.ControlUIElementBase.ProcessMouseUp(Object sender, MouseEventArgs e) at Infragistics.Win.Utilities.ProcessEvent(Control control, ProcessEvent eventToProcess, EventArgs e) at Infragistics.Win.UltraControlBase.OnMouseUp(MouseEventArgs e) at Infragistics.Win.UltraWinToolbars.UltraToolbarsDockArea.OnMouseUp(MouseEventArgs e) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Hello Kathleen,
Thank you for the details you have provided.
I created a sample application based on your scenario and I could not managed to reproduce the behavior that you have described. I tested it with the RTM version of 15.2 and the latest Service Release of 15.2 – 2100. If you are not able to reproduce the issue with the attached sample application, would you please modify it with the functionality, that you are using, so it reproduces the issue.
Would you please provide me with more detailed information regarding the environment in which you are developing your application (Operating system, Service Release, Integrated development environment and the specific version of our product that you are using and any other information that might help reproducing your issue), in order to be able to identify what might be causing this behavior?
This way I would be able to further investigate this for you and provide you with more detailed information on this matter.
Looking forward to hearing from you.
Sincerely, ZhivkoEntry Level Software Developer
Hi guys,
I am actually working with Infragistcs Excel Library, and when i am load a file i have the error
((System.NullReferenceException)(ex))
en Infragistics.Excel.FormulaUtilities.Tokens.FunctionOperator.Load(WorkbookSerializationManager manager, BiffRecordStream stream, Boolean isForExternalNamedReference, Byte[]& data, Int32& dataIndex) en Infragistics.Excel.Formula.LoadFormulaData(WorkbookSerializationManager manager, BiffRecordStream stream, UInt16 rpnTokenArraySize, FormulaType type, Formula formula, Byte[]& data, Int32& dataIndex) en Infragistics.Excel.Formula.Load(WorkbookSerializationManager manager, BiffRecordStream stream, UInt16 rpnTokenArraySize, FormulaType type, Byte[]& data, Int32& dataIndex) en Infragistics.Excel.Serialization.BIFF8.BiffRecords.NAMERecord.Load(BIFF8WorkbookSerializationManager manager) en Infragistics.Excel.Serialization.BIFF8.BIFF8WorkbookSerializationManager.LoadCurrentRecord() en Infragistics.Excel.Serialization.BIFF8.BIFF8WorkbookSerializationManager.LoadWorkbookContents() en Infragistics.Excel.Serialization.WorkbookSerializationManager.Load() en Infragistics.Excel.Workbook.LoadBIFF8File(Workbook workbook, Stream stream, String parameterName) en Infragistics.Excel.Workbook.LoadHelper(Stream stream, WorkbookFormat format, String parameterName, IPackageFactory packageFactory, Boolean verifyExcel2007Xml) en Infragistics.Excel.Workbook.Load(String fileName, IPackageFactory packageFactory, Boolean verifyExcel2007Xml) en Infragistics.Excel.Workbook.Load(String fileName, IPackageFactory packageFactory) en Infragistics.Excel.Workbook.Load(String fileName)
I attached the file, thank you for your help
Hello Andrew,
I am just checking if there is anything else I can do for you.
We have shipped out a new service release where your issue is resolved. I'd be glad to find out if you had tested it out and if it had met your requirements.
You can download the Service Releases by logging to our web site and going to Account\My Keys and Downloads.
Thank you for your post.
I have logged this behavior with our developers in our tracking system, with an issue ID of 191001. I have also created a support ticket on your behalf with number CAS-153194-M5F8X4 in order to link the development issue to it so that you are automatically updated when a Service Release containing your fix is available for download.
Thank you for using Infragistics controls.