Summary:
This article troubleshoots an error that occurs when copying Web Budgeting settings from one cell to another. The error persists even when the user deletes all Web Budgeting settings from the sheet and tries to save the workbook, preventing saving of the current workbook.
Symptoms:
When a user copies Web Budgeting settings from one cell to another, they receive the following error message:
Unable to cast object of type 'OneStop.Framework.Engine.ItemBounds' to type 'OneStop.ReportDesigner.ExcelItemBounds'.
System.InvalidCastException: Unable to cast object of type 'OneStop.Framework.Engine.ItemBounds' to type 'OneStop.ReportDesigner.ExcelItemBounds'.
at OneStop.ReportDesigner.SheetMapping.
at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at OneStop.ReportDesigner.SheetMapping.FixItems(Boolean raiseEvent, FixItemsResult& errorItem)
at OneStop.ReportDesigner.DesignEnvironment.BuildDefinition()
OSR Version: 4.6.50203.1703
Causes:
Cells are corrupted.
Resolution:
Perform a Save-As instead of Save to create this in a new workbook. That should clear out the corrupt cell. The user should then be able to copy Web Budgeting settings by copying and pasting the cell.
Properties:
Web Budgeting Reporting 4.x