The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
I use V2.0.5 of the GridControl in a multi-sheet family with cross-sheet formulas. Sheet 1 has a cell reference to a cell in Sheet 2. Sheet 1 is shown initially. The value in the Sheet 1 cell is not correct until I have navigated to Sheet 2 once. How do I fix this?
I must add that the cell in Sheet 2 is a formula cell itself.
>I use V2.0.5 of the GridControl in a multi-sheet family with cross-sheet formulas. Sheet 1 has a cell reference to a cell in Sheet 2. Sheet 1 is shown initially. The value in the Sheet 1 cell is not correct until I have navigated to Sheet 2 once. How do I fix this?
GRGregMay 25, 2004 10:46 AM UTC
1) I believe you may be in the wrong sub-Forum. This one is about the ExcelRW product that reads and writes Excel files. There is a Grid forum, which gets faster responses as well.
2) My guess is that you may have to Invalidate the regions or some other action which would force a (re)calculation.? (we use the Virtual Grid, and do all calculations ourselves)
-Greg