// Add a formula spread.Sheets[0].Cells[0, 5].Formula = "SUM(A1:A10)";
: Developers used it to create massive data entry screens. It wasn't just a grid; it had "cell types," meaning you could turn a single cell into a checkbox, a combo box, or even a date picker with a few clicks. FarPoint Spread 7.0.25
| Issue | Workaround | |-------|-------------| | | Set Sheet.Skin = DefaultSpreadSkin.Default (non-gradient) | | PrintDocument memory leak | Dispose and recreate print object per print job | | Excel export loses images | Export as XLS (Excel 97-2003) instead of XLSX | | Data binding fails with nullable decimals | Handle DataError event and set Cell.Value = DBNull.Value | | Designer crashes in VS2012 | Disable "AutoToolboxPopulate" in VS options | // Add a formula spread