Library home • Reviews • Submit • About

MayerSoft.Web.Controls.Spreadsheet 1.0

 MayerSoft LLC

MayerSoft.Web.Controls.Spreadsheet 		Description:

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:

Basic math: 100+200
System.Math namespace: Math.Pow(1+.045,2)
Strings: "$57".Trim().Replace("$","").Substring(0,1)
Dates:DateTime d=new DateTime(632272996777884556);return d.Year;

Formula cells are created like this:


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,"Price


Product home page: http://mayers.us/MayerSoft/Default.aspx
Download from http://mayers.us/MayerSoft/Default.aspx

Add Your Review for MayerSoft.Web.Controls.Spreadsheet
Your Name:
Your Email:
(Optional)
Review Title:
Review:
   characters left
Rating:

Related programs:

  • MailBee WebMail Lite 3.0 - MailBee WebMail Lite is a FREE set of ASP scripts that organize email web-interface. Users can receive, view, manage, compose and send email through web-interface (using POP3 and SMTP protocols). Multiple attachments, ESMTP, skins, source code, more.
  • M-Greek Mail Component 1.0.0 - M-Greek is an ActiveX component for sending Greek email from ASP Web sites and Microsoft Windows applications. It works as an ActiveX object but also exposes DLL functions directly. It includes an EXE for CGI operation via XMLHTTP.
  • IDAutomation Code 128 Font Advantage 5.1B - Our Code 128 Font Advantage Package is much more than a few barcode fonts. With this package you get 18 different font versions in 6 different font formats for Windows, Macintosh, UNIX and a variety of other operating systems.
Platform: Windows Developer Tools::Components & Libraries
Type: Commercial Cost: $19.95 US Size: 125 K Released: Jul 29, 2004
1