This ASP.NET server control allows for the creation of spreadsheet grids with formulas, numbers, text, labels, and dates in cells. It can be used in financial calculators or any web page where a spreadsheet template is necessary.
In terms of functionality, this control supports all of the functions found within the .NET System.dll framework. This includes basic mathematics, math within the System.Math namespace, strings, and even dates. The formula cell references, such as [c0r1], are first replaced by the value within that cell and then evaluated.
This software also has the ability to create both simple and multiline formulas. Users can create formula cells using the following code: Spread1.AddCell(new FormulaCell(1,6,"[c1r4]*[c2r6]","Formula",NumericFormats.ToTheDollar)).
For those interested in testing this software out, the Mayersoft.Web.Controls must be used for initialization. Additionally, the example provided shows how to add columns and cells to a spreadsheet grid. Overall, this software is a great option for anyone in need of a spreadsheet control within a web page.
Version 1.0: N/A