I have defined a function in which I take as input, cell values from a range and after doing some calculation output them on the spreadsheet using the ScDocument::SetString and ScDocument::SetValue functions. But the values get printed partially ( Eg: 8 => 3 [half an 8] ) in each of the cells .Then after a while or if I scroll down the sheet and back up, then the all the values are displayed entirely. To me it seems like a case where the values are in memory but are not being entirely printed on the sheet. So I need to refresh the spreadsheet manually. How do I enforce a refresh of the spreadsheet ?
Thanks, Rashi