|104524||Jul 26,2012 04:23 PM UTC||Aug 2,2012 11:06 AM UTC||Silverlight||2|
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.
In Model_QueryCellInfo event:
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.
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#]
Please let us know if this helps.
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.