Farpoint Spread 7.0.25 -

FarPoint Spread 7.0.25 is a specific maintenance release of the popular spreadsheet and grid component used for developing Windows Forms and ASP.NET applications. Originally developed by FarPoint Technologies (now a part of Mescius/GrapeCity ), this version is part of the legacy product line. Overview of Spread 7.0.25

  • Namespace changes: FarPoint.Win.Spread to GrapeCity.Win.Spread
  • Cell type model redesigned for better performance
  • Property renaming: Sheets[0] → ActiveSheet
  • Event signature changes: Many EventArgs have been extended
  • Designer integration now requires Visual Studio 2022

Technical White Paper: FarPoint Spread 7.0.25

The Premier Grid Component for Legacy COM and Visual Basic 6 Applications FarPoint Spread 7.0.25

: Introduced integrated chart controls, conditional formatting, and AJAX-enabled features for web versions. Compatibility & Environment FarPoint Spread 7

Key Features of Version 7.0.25

1. High-Fidelity Excel Import/Export

With version 7.0.25, FarPoint introduced enhanced support for Excel 2007/2010 (XLSX) files. The component could handle: Namespace changes: FarPoint

  1. High DPI / scaling disaster – On 4K monitors, the cell editor shrinks to 4px high. Setting AutoSizeMode does nothing. Had to force fpSpread1.ScaleRatio manually – partial fix.
  2. ComboBox cell type bug – When you set EditorValue = EditorValue.ItemData, the Changed event fires twice. The second time Cell.Text is empty. My workaround is a debounce timer (hacky).
  3. Copy/paste with locked columns – If you lock column B, users can still paste into it via Ctrl+V if selection includes B+C. FarPoint confirmed this as a “by design” behavior back then – still annoying.
  4. Memory leak – Opening/closing a form with a Spread control repeatedly adds ~2-4 MB per instance (even after calling Dispose()). I finally added fpSpread1.Sheets.Clear(); fpSpread1.Dispose(); and called GC.Collect() – still leaks but slower.