Posted 8 September 2017, 1:53 pm EST
we're using Spread in WinForms and .Net 3.5 and are building up a SheetView in code. We are experiencing severe performance issues when scrolling the spread control or selecting a cell.
After some profiling we figured out that a lot of BitmapPaint-ing was going on sourced in the CellType.RichTextEditor class. Our SpreadView contained two ranges with celltype set to RichTextCellType with multiline and wordwrap set to true. If we set the celltype to a plain TextCellType we saw a 13% performance increase in profiling and greater UI responsiveness.
Is this a known issue? Are there special considerations we should take when using the rich text cell type?