Freeware & Shareware > Development > Components & Libraries > MayerSoft.Web.Controls.Spreadsheet free download

MayerSoft.Web.Controls.Spreadsheet 1.0 Free Download

MayerSoft.Web.Controls.Spreadsheet 1.0 at a glance

ASP.NET spreadsheet Cells may contain text, labels, dates, numbers or formulas.

Download MayerSoft.Web.Controls.Spreadsheet

(Version: 1.0, 125 KB)

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

MayerSoft.Web.Controls.Spreadsheet Info

MayerSoft LLCPublisher:

1.0Version:

Windows2000,Windows2003OS :

125 KBFile Size:

$19.95 CommercialPrice:

July 29, 2004Date Added :

Download MayerSoft.Web.Controls.Spreadsheet 1.0

MayerSoft.Web.Controls.Spreadsheet Related Downloads

Web Page Maker 3.0 Popular!
Web Page Maker is an easy-to-use web page design tool that allows you to create and upload a professional web page in minutes without having to know HTML.
M6.Net PR Quick Check 1.00
The M6.Net PR Quick Check is a extremely easy to use, free Page Rank checker tool that allows you to check the PR of a page or a web site and compare it with the previous PR of the same page. A very useful tool for webmasters.
MicroStation Excel- {Cadig AutoTable 3 } 3.0
{ Cadig AutoTable 3.0 } is designed to import Excel spreadsheet to MicroStation and modify it with Excel at anytime. Besides, you can update table in MicroStation to synchronize it with the original Excel spreadsheet. == http://www.cadig.com ==
AutoCAD LT Excel- {Cadig AutoTable 3.0} 3.3
{ Cadig AutoTable 3.0 } is designed to import Excel spreadsheet to AutoCAD LT and modify it with Excel at anytime. Besides, you can update table in AutoCAD to synchronize it with the original Excel spreadsheet. == http://www.cadig.com ==
AutoCAD Excel - { Cadig AutoTable 3.0 } 3.6
{ Cadig AutoTable } is designed to import Excel spreadsheet to AutoCAD and modify it with Excel at anytime. Besides, you can update table in AutoCAD to synchronize it with the original Excel spreadsheet.
StatPlus 5.1.2.0
StatPlus 2008 is a powerful and flexible software solution that processes data to perform statistical analysis.
Sudoku Assist 1.1
SU DOKU Assist is an Excel Spreadsheet. SO DUKU Assist will NOT SOLVE a SO DUKU Puzzle for you. It will ONLY provide assistance and guidance to point you in the right direction and assist in the prevention of common mistakes.You must STILL use LOGIC
Abykus 1.02
Allows complex data types such as matrixes, coordinates, polygons, etc. to be stored in individual cells. Ideally suited for engineering and surveying applications. A structured script language is also included.
ZeN 2005 Desktop Database 2.0.0.0
Free Spreadsheet Desktop Database by ZPSSoft: ZeN 2005 with an interface like Microsoft Excel spreadsheet.
Profit Loss Report Spreadsheet 4.0
Award-winning Excel spreadsheet is a simple alternative to accounting software for a small business to track income and expenses. Easier for you and tax preparer when tax time rolls around. Save time, money and tax time headaches. Requires MS Excel.