Right now static would be fine but at a later stage I will want them to dynamically update when other cells change. Thanks,
Rashi On Tue, Jul 20, 2010 at 1:47 PM, Niklas Nebel <niklas.ne...@oracle.com>wrote: > > It still seems unusual. Are these formulas supposed to be static, or should > they be updated when other cells change? > > Anyway, if you modify cell content from UI code, you have to take care of > repaint, undo, formula updates, and possibly row heights. There's a method > ScDocFunc::SetCellText for a single cell, which handles this, or you might > do something similar to lcl_PutDataArray in cellsuno.cxx. > > > Niklas > >