Current filter:
                                You should refresh the page.
                                  • After upgrading to v19.1.7, I'm getting an exception throw in an area of my code that was working before. See attached screen shot (if I remove the paste special and just do a straight copy, I still get the same problem). Nothing seems to be wrong with the source or destination cells. Could this be a bug or new behavior introduced in v19.1.7? Any idea what this is?
                                    Thanks.
                                    -Eric

                                Show all comments
                                • Yulia (DevExpress Support) 10.23.2019

                                  Hello Eric,

                                  The information you provided is not enough to determine the cause of the problem. Usually, such an exception is specific to a document where cells are copied and pasted. To find the cause of the issue, we need to replicate the problematic behavior on our side. Please send us a small sample that shows the issue in action.

                                  I understand that creating such a sample will take time and effort. In the meantime, you can provide additional information regarding your scenario, and we will do our best to create a test project.
                                  Please provide us with the Excel document where the issue occurs. Specify values of the "cell" and "rollupCell" variables illustrated in your screenshot. Also, please send us the entire code of that method.

                                  It will be useful if you send us the call stack of this exception. Please refer to the How to obtain the exception's call stack article that describes the recommended settings for collecting a call stack.

                                • Customer40115 10.23.2019

                                  Trying to narrow this down, but it's happening in a for() loop. The cell is copied successfully 3 times, but on the 4th iteration in this loop the exception gets thrown. I'v looked at these cells and there does not appear to be anything special or different about AH62 versus AG62 in any way. All these cells AG62 to past AH62 are simple formulas that reference the previous cell (e.g., AH62 is "=AG62").

                                        > Copying formula [=E63-E61] from cell E62 to cell AE62
                                        > Copying formula [=E63-E61] from cell E62 to cell AF62
                                        > Copying formula [=E63-E61] from cell E62 to cell AG62
                                        > Copying formula [=E63-E61] from cell E62 to cell AH62

                                • Customer40115 10.23.2019

                                  If I follow the instructions to get the call stack, I can't even get to the point where the above problem occurs. If I disable "Enable Just My Code", I get the following error just loading files. This does not happen if I click "Enable Just My Code". Can you help me get past this? Attached is a screen shot of this error and the Call Stack is below. Again, this is not the problem above and it ONLY happens if I uncheck "Enable Just My Code".

                                  Here's the call stack from this problem loading a document:

                                  System.dll!System.Uri.CreateThis(string uri, bool dontEscape, System.UriKind uriKind) Unknown
                                    System.dll!System.Uri.Uri(string uriString) Unknown
                                    DevExpress.Spreadsheet.v19.1.Core.dll!DevExpress.XtraSpreadsheet.Import.OpenXml.RelationshipDestination.GetActualTarget(string target) Unknown
                                    DevExpress.Spreadsheet.v19.1.Core.dll!DevExpress.XtraSpreadsheet.Import.OpenXml.RelationshipDestination.ProcessElementOpen(System.Xml.XmlReader reader) Unknown
                                    DevExpress.Printing.v19.1.Core.dll!DevExpress.Office.Destination.ProcessCore(System.Xml.XmlReader reader) Unknown
                                    DevExpress.Printing.v19.1.Core.dll!DevExpress.Office.Destination.Process(System.Xml.XmlReader reader) Unknown
                                    DevExpress.Office.v19.1.Core.dll!DevExpress.Office.DestinationAndXmlBasedImporter.ProcessCurrentDestination(System.Xml.XmlReader reader) Unknown
                                    DevExpress.Office.v19.1.Core.dll!DevExpress.Office.DestinationAndXmlBasedImporter.ImportContent(System.Xml.XmlReader reader) Unknown
                                    DevExpress.Office.v19.1.Core.dll!DevExpress.Office.DestinationAndXmlBasedImporter.ImportContent(System.Xml.XmlReader reader, DevExpress.Office.Destination initialDestination) Unknown
                                    DevExpress.Spreadsheet.v19.1.Core.dll!DevExpress.XtraSpreadsheet.Import.OpenXml.OpenXmlImporter.ImportRelationsCore(System.Xml.XmlReader reader) Unknown
                                    DevExpress.Spreadsheet.v19.1.Core.dll!DevExpress.XtraSpreadsheet.Import.OpenXml.OpenXmlImporter.ImportRelations(string fileName) Unknown
                                    DevExpress.Spreadsheet.v19.1.Core.dll!DevExpress.XtraSpreadsheet.Import.OpenXml.OpenXmlImporter.ReadExternalFilePath(string fileName) Unknown
                                    DevExpress.Spreadsheet.v19.1.Core.dll!DevExpress.XtraSpreadsheet.Import.OpenXml.OpenXmlImporter.ImportExternalReference() Unknown
                                    DevExpress.Spreadsheet.v19.1.Core.dll!DevExpress.XtraSpreadsheet.Import.OpenXml.OpenXmlImporter.AfterImportMainDocument() Unknown
                                    DevExpress.Office.v19.1.Core.dll!DevExpress.Office.DestinationAndXmlBasedImporter.ImportMainDocument(System.Xml.XmlReader reader) Unknown
                                    DevExpress.Office.v19.1.Core.dll!DevExpress.Office.DestinationAndXmlBasedImporter.ImportMainDocument(System.Xml.XmlReader reader, System.IO.Stream baseStream) Unknown
                                    DevExpress.Spreadsheet.v19.1.Core.dll!DevExpress.XtraSpreadsheet.Import.OpenXml.OpenXmlImporter.ImportWorkbook(System.IO.Stream stream) Unknown
                                    DevExpress.Spreadsheet.v19.1.Core.dll!DevExpress.XtraSpreadsheet.Import.OpenXml.OpenXmlImporter.ImportCore(System.IO.Stream stream) Unknown
                                    DevExpress.Spreadsheet.v19.1.Core.dll!DevExpress.XtraSpreadsheet.Import.OpenXml.OpenXmlImporter.Import(System.IO.Stream stream) Unknown
                                    DevExpress.Spreadsheet.v19.1.Core.dll!DevExpress.XtraSpreadsheet.API.Internal.InternalAPI.LoadDocumentOpenXmlContent(System.IO.Stream stream, DevExpress.XtraSpreadsheet.Import.OpenXmlDocumentImporterOptions options) Unknown
                                    DevExpress.Spreadsheet.v19.1.Core.dll!DevExpress.XtraSpreadsheet.Import.OpenXmlDocumentImporter.LoadDocument(DevExpress.Office.IDocumentModel documentModel, System.IO.Stream stream, DevExpress.Office.Import.IImporterOptions options, bool leaveOpen) Unknown
                                    DevExpress.Office.v19.1.Core.dll!DevExpress.Office.Internal.ImportHelper<DevExpress.Spreadsheet.DocumentFormat, bool>.Import(System.IO.Stream stream, string sourceUri, DevExpress.Office.Internal.IImporter<DevExpress.Spreadsheet.DocumentFormat, bool> importer, System.Text.Encoding encoding, bool leaveOpen) Unknown
                                    DevExpress.Office.v19.1.Core.dll!DevExpress.Office.Model.DocumentModelBase<DevExpress.Spreadsheet.DocumentFormat>.LoadDocument(System.IO.Stream stream, DevExpress.Spreadsheet.DocumentFormat documentFormat, string sourceUri, System.Text.Encoding encoding, bool leaveOpen) Unknown
                                    DevExpress.Office.v19.1.Core.dll!DevExpress.Office.Model.DocumentModelBase<DevExpress.Spreadsheet.DocumentFormat>.LoadDocument(System.IO.Stream stream, DevExpress.Spreadsheet.DocumentFormat documentFormat, string sourceUri, bool leaveOpen) Unknown
                                    DevExpress.Office.v19.1.Core.dll!DevExpress.Office.Model.DocumentModelBase<DevExpress.Spreadsheet.DocumentFormat>.LoadDocument(System.IO.Stream stream, DevExpress.Spreadsheet.DocumentFormat documentFormat, string sourceUri) Unknown
                                    DevExpress.Spreadsheet.v19.1.Core.dll!DevExpress.XtraSpreadsheet.Internal.InnerSpreadsheetDocumentServer.LoadDocumentCore(System.IO.Stream stream, DevExpress.Spreadsheet.DocumentFormat documentFormat, string fileName) Unknown
                                    DevExpress.Spreadsheet.v19.1.Core.dll!DevExpress.XtraSpreadsheet.Internal.InnerSpreadsheetDocumentServer.LoadDocument(string fileName, DevExpress.Spreadsheet.DocumentFormat documentFormat) Unknown
                                    DevExpress.Docs.v19.1.dll!DevExpress.Spreadsheet.Workbook.LoadDocument(string fileName) Unknown
                                  > GrowthPlanV1.exe!GrowthPlan1.LoadModelData.GP_LoadModule.LoadModule(GrowthPlan1.Model.GP_Module module) Line 45 C#
                                    GrowthPlanV1.exe!GrowthPlan1.MainWindow.LoadModuleView(GrowthPlan1.Model.GP_Module selectedModule, bool showWaitCursor, GrowthPlan1.Model.GP_LeftNavOption leftNavOption, GrowthPlan1.Model.GP_TabMenuOption subMenuOption) Line 304 C#
                                    GrowthPlanV1.exe!GrowthPlan1.MainWindow.LoadModuleView(GrowthPlan1.Model.GP_Module selectedModule) Line 270 C#
                                    GrowthPlanV1.exe!GrowthPlan1.View.HomeOptionsView.Button_Click(object sender, System.Windows.RoutedEventArgs e) Line 207 C#
                                    PresentationCore.dll!System.Windows.RoutedEventHandlerInfo.InvokeHandler(object target, System.Windows.RoutedEventArgs routedEventArgs) Unknown
                                    PresentationCore.dll!System.Windows.EventRoute.InvokeHandlersImpl(object source, System.Windows.RoutedEventArgs args, bool reRaised) Unknown
                                    PresentationCore.dll!System.Windows.UIElement.RaiseEventImpl(System.Windows.DependencyObject sender, System.Windows.RoutedEventArgs args) Unknown
                                    PresentationCore.dll!System.Windows.UIElement.RaiseEvent(System.Windows.RoutedEventArgs e) Unknown
                                    PresentationFramework.dll!System.Windows.Controls.Primitives.ButtonBase.OnClick() Unknown
                                    PresentationFramework.dll!System.Windows.Controls.Button.OnClick() Unknown
                                    PresentationFramework.dll!System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(System.Windows.Input.MouseButtonEventArgs e) Unknown
                                    PresentationCore.dll!System.Windows.UIElement.OnMouseLeftButtonUpThunk(object sender, System.Windows.Input.MouseButtonEventArgs e) Unknown
                                    PresentationCore.dll!System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(System.Delegate genericHandler, object genericTarget) Unknown
                                    PresentationCore.dll!System.Windows.RoutedEventArgs.InvokeHandler(System.Delegate handler, object target) Unknown
                                    PresentationCore.dll!System.Windows.RoutedEventHandlerInfo.InvokeHandler(object target, System.Windows.RoutedEventArgs routedEventArgs) Unknown
                                    PresentationCore.dll!System.Windows.EventRoute.InvokeHandlersImpl(object source, System.Windows.RoutedEventArgs args, bool reRaised) Unknown
                                    PresentationCore.dll!System.Windows.UIElement.ReRaiseEventAs(System.Windows.DependencyObject sender, System.Windows.RoutedEventArgs args, System.Windows.RoutedEvent newEvent) Unknown
                                    PresentationCore.dll!System.Windows.UIElement.OnMouseUpThunk(object sender, System.Windows.Input.MouseButtonEventArgs e) Unknown
                                    PresentationCore.dll!System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(System.Delegate genericHandler, object genericTarget) Unknown
                                    PresentationCore.dll!System.Windows.RoutedEventArgs.InvokeHandler(System.Delegate handler, object target) Unknown
                                    PresentationCore.dll!System.Windows.RoutedEventHandlerInfo.InvokeHandler(object target, System.Windows.RoutedEventArgs routedEventArgs) Unknown
                                    PresentationCore.dll!System.Windows.EventRoute.InvokeHandlersImpl(object source, System.Windows.RoutedEventArgs args, bool reRaised) Unknown
                                    PresentationCore.dll!System.Windows.UIElement.RaiseEventImpl(System.Windows.DependencyObject sender, System.Windows.RoutedEventArgs args) Unknown
                                    PresentationCore.dll!System.Windows.UIElement.RaiseTrustedEvent(System.Windows.RoutedEventArgs args) Unknown
                                    PresentationCore.dll!System.Windows.UIElement.RaiseEvent(System.Windows.RoutedEventArgs args, bool trusted) Unknown
                                    PresentationCore.dll!System.Windows.Input.InputManager.ProcessStagingArea() Unknown
                                    PresentationCore.dll!System.Windows.Input.InputManager.ProcessInput(System.Windows.Input.InputEventArgs input) Unknown
                                    PresentationCore.dll!System.Windows.Input.InputProviderSite.ReportInput(System.Windows.Input.InputReport inputReport) Unknown
                                    PresentationCore.dll!System.Windows.Interop.HwndMouseInputProvider.ReportInput(System.IntPtr hwnd, System.Windows.Input.InputMode mode, int timestamp, System.Windows.Input.RawMouseActions actions, int x, int y, int wheel) Unknown
                                    PresentationCore.dll!System.Windows.Interop.HwndMouseInputProvider.FilterMessage(System.IntPtr hwnd, MS.Internal.Interop.WindowMessage msg, System.IntPtr wParam, System.IntPtr lParam, ref bool handled) Unknown
                                    PresentationCore.dll!System.Windows.Interop.HwndSource.InputFilterMessage(System.IntPtr hwnd, int msg, System.IntPtr wParam, System.IntPtr lParam, ref bool handled) Unknown
                                    WindowsBase.dll!MS.Win32.HwndWrapper.WndProc(System.IntPtr hwnd, int msg, System.IntPtr wParam, System.IntPtr lParam, ref bool handled) Unknown
                                    WindowsBase.dll!MS.Win32.HwndSubclass.DispatcherCallbackOperation(object o) Unknown
                                    WindowsBase.dll!System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate callback, object args, int numArgs) Unknown
                                    WindowsBase.dll!System.Windows.Threading.ExceptionWrapper.TryCatchWhen(object source, System.Delegate callback, object args, int numArgs, System.Delegate catchHandler) Unknown
                                    WindowsBase.dll!System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority priority, System.TimeSpan timeout, System.Delegate method, object args, int numArgs) Unknown
                                    WindowsBase.dll!MS.Win32.HwndSubclass.SubclassWndProc(System.IntPtr hwnd, int msg, System.IntPtr wParam, System.IntPtr lParam) Unknown
                                    [Native to Managed Transition]
                                    [Managed to Native Transition]
                                    WindowsBase.dll!System.Windows.Threading.Dispatcher.PushFrameImpl(System.Windows.Threading.DispatcherFrame frame) Unknown
                                    WindowsBase.dll!System.Windows.Threading.Dispatcher.PushFrame(System.Windows.Threading.DispatcherFrame frame) Unknown
                                    PresentationFramework.dll!System.Windows.Application.RunDispatcher(object ignore) Unknown
                                    PresentationFramework.dll!System.Windows.Application.RunInternal(System.Windows.Window window) Unknown
                                    PresentationFramework.dll!System.Windows.Application.Run(System.Windows.Window window) Unknown
                                    PresentationFramework.dll!System.Windows.Application.Run() Unknown
                                    GrowthPlanV1.exe!GrowthPlan1.App.Main() Unknown

                                • Yulia (DevExpress Support) 10.24.2019

                                  Hello,

                                  Thank you for providing the call stack. I've passed this ticket to my team. Our developers will research this issue in detail. We will get back to you once we have any results.

                                • Customer40115 10.24.2019

                                  Thanks!

                                • Customer40115 10.25.2019

                                  The 19.1.8 HotFix fixed my KeyNotFound Exception. After getting Hotfix 19.2.4 is available, I'll download v19.2 when Hotfix 19.2.4 is available to me.

                                1 Solution

                                Creation Date Importance Sort by

                                Fixed:

                                • 19.2.4 :
                                • 19.1.8 :