MayerSoft.Web.Controls.Spreadsheet Free Download

Version: 1.0   (version history)
Date: July 29, 2004

Free To Try

OS: Win 2000
Rating: Not rated
Popularity: Popularity 0/10
Author: MayerSoft LLC

Download Sites:

MayerSoft.Web.Controls.Spreadsheet Description

MayerSoft.Web.Controls.Spreadsheet Free Download.

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!

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)
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 keywords:, server, control, spreadsheet, mayersoft

More Downloads

  • MayerSoft.Web.Controls.NewsScroller

    Two server controls: NewsScroller scrolls content in a box, and Display shows content with transitions. Declarative or code-behind content.

  • Pivo Ping Component

    Pivo.Ping allows you to effortless enable your applications to send Internet Control Message Protocol (Ping/ICMP) packets in .NET. Programmatically ping a remote server, host, route, or any network device to see if it is up.

  • XLplus V2.X

    XLplus is a tools collection for Microsoft EXCEL 2000 (or higher) which helps to do your daily work faster and more efficient. XLplus is available for free and for various languages.

  • Take Note

    Take Note: Simple, easy to use, note taking Features:Add and delete notes.Note Search.Save note as text file.Print out note.List all notes.System try quick-loader.Take Note. Because notes are ment to be simple.

  • String-O-Matic

    A shareware program that performs search and replace operations on multiple substrings in multiple files. Case-insensitive, whole-word, and wildcard searches are supported.