Hi Melinda,
Sorry for the inconvenience caused.
Regarding query 1:
GridControl will show the actual value and computed formula values even when the referring sheet is hidden or not viewed yet. It is not the problem in the GridControl. The problem is in the sample source. This can be resolved by changing the following lines of code at ExcelImportDemo sample source.
Index: GridCellImportingBehavior.cs
In Model_QueryCellInfo event:
Code Snipped[C#]
GridSheetFamilyItem family = GridFormulaEngine.GetSheetFamilyItem(gridModel);
string token = family.GridModelToToken[gridModel].ToString();
int index = int.Parse(token.Replace('!', ' '));
We have attached the modified sample for your reference.
Sample:
Regarding query 2:
You can have both virtual and non-virtual grid in a Silverlight application. This can be achieved by using the GridModelImportExtensions.ImportFromExcel() method inside the LoadWorkbook. This method import all value from excel to grid model at the time of importing itself. So there is no need to add behavior to the grid model imported using this method.
We have attached the code snipped for your reference.
Code Snipped [C#]
GridModelImportExtensions.ImportFromExcel(grid.Model, Workbook.Worksheets["Sheet2"]);
Please let us know if this helps.
Regards,
Kathirvel
Import_774629f3.zip