Farpoint Spread 7.0.25

No software is perfect. Below are documented issues specific to this build:

| Issue | Workaround | |-------|-------------| | GDI+ overflow when rendering gradients | 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 | FarPoint Spread 7.0.25

Here is a minimal example of using FarPoint Spread 7.0.25 in a Windows Forms application: No software is perfect

using FarPoint.Win.Spread;
using FarPoint.Win.Spread.CellType;
public partial class ReportForm : Form
private FpSpread spread; If your project is still on  7
public ReportForm()
InitializeComponent();
    InitializeSpread();
private void InitializeSpread()
spread = new FpSpread();
    spread.Dock = DockStyle.Fill;
    spread.Sheets.Count = 1;
    spread.Sheets[0].RowCount = 100;
    spread.Sheets[0].ColumnCount = 10;
// Set a DateTime cell type
    DateTimeCellType dateCell = new DateTimeCellType();
    dateCell.DateTimeFormat = DateTimeFormat.ShortDate;
    spread.Sheets[0].Columns[0].CellType = dateCell;
// Add a formula
    spread.Sheets[0].Cells[0, 5].Formula = "SUM(A1:A10)";
// Load Excel file
    spread.OpenExcel("C:\\Data\\Report.xlsx");
Controls.Add(spread);
private void SaveButton_Click(object sender, EventArgs e)
spread.SaveExcel("C:\\Data\\Report_Modified.xlsx", 
                     ExcelSaveFlags.SaveCustomColumnHeaders);

If your project is still on 7.0.25, consider: