This ASP.NET server control creates a spreadsheet grid and enables formulas, numbers, text, labels and dates in cells. Use in financial calculators or anywhere else a spreadsheet template is used...albeit in a web page!
This ASP.NET server control creates a spreadsheet grid and enables formulas, numbers, text, labels and dates in cells. Use in financial calculators or anywhere else a spreadsheet template is used...albeit in a web page!
FAQ
What functions are supported (Sum(),Year(), etc.)?
All functionality from the .NET System.dll framework are supported. For example:
Basic math: [c0r0]+[c0r1]
System.Math namespace: Math.Pow(1+[c1r7],2)
Strings: "[c0r1]".Trim().Replace("$","").Substring(0,1)
Dates: DateTime d=new DateTime([c1r0]);return d.Year;
Formula cell references such as '[c0r1]' are replaced by the value of the cell, then evaluated. (Note that the value of a date cell is the number of ticks.) So the above examples might look like this before being evaluated:
Spread1.AddCell(new FormulaCell(1,6,"[c1r4]*[c2r6]","Formula",NumericFormats.ToTheDollar));
See below for more examples of how formula cells work. Note also that there are two kinds of formulas, simple and multiline. The example below shows both types of formulas.
Code used in this example
Initialization of a spreadsheet
Using MayerSoft.Web.Controls;
private void Page_Init(object sender, System.EventArgs e)
{
Spread1.LicenseKey="eL!NJ@2H3aF";//sample key
}
private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
Spread1.Columns.Add(new Column(150));
Spread1.Columns.Add(new Column());
Spread1.AddCell(new Cell(0,0,"Item 1","Label"));
Spread1.AddCell(new Cell(0,1,"Item 2","Label"));
Spread1.AddCell(new Cell(0,2,"Total","Label"));
Spread1.AddCell(new Cell(0,3,"Div by pct","Label"));
Spread1.AddCell(new Cell(0,4,"Result","Label"));
Spread1.AddCell(new Cell(0,5,"PriceOperating system: Windows2000,Windows2003
ActiveX Charting Control offers hundreds of Graph styles in 2D and 3D, 33 mathematical and statistical Functions for you to choose from together with an unlimited number of axes and 17 toolbox components. For Windows and the Web.
Price: $449, Rating: 7, Downloads: 170 Download
The Chilkat C++ class library for VC++ 7.0 fully supports SMTP, POP3, MIME, HTML, SSL, S/MIME, secure authentication, attachments, SSL, progress monitoring, zip and unzip of attachments, XML import/export, and is fully internationalized to handle email in
Price: $99, Rating: 8, Downloads: 152 Download
Object-Oriented Charting component library completely written in PHP and ready to be used in any PHP scripts. It includes full source code meaning that no loaders have to be used in order to create a Graph on servers.
Price: $, Rating: 8, Downloads: 151 Download
In short, Colock is a software based lock for making your software copy protected. By adding just one line of code to source code of your program, you will be able to use powerful copy protection system of Colock.
Price: $45.00, Rating: 8, Downloads: 137 Download
User Rating
Rating:2.2 out of
5 Based on13 ratings.
13 user reviews.