Download Freeware MayerSoft.Web.Controls.Spreadsheet 1.0

Tops and Ratings

MayerSoft.Web.Controls.Spreadsheet Description:

MayerSoft.Web.Controls.Spreadsheet is Commercial program for Windows developed by MayerSoft LLC

This ASP.NET server control creates a spreadsheet grid and enables formulas, numbers, content, labels and dates in cells. Use in fiscal calculators or anywhere else a spreadsheet template is worn...albeit in a snare 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=unusual DateTime([c1r0]); reappear d.Year;

Formula cell references such as '[c0r1]' are replaced by the value of the cell, then evaluated. (Note that the value of a season cell is the number of ticks.) So the above examples might observe 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=unusual DateTime(632272996777884556); reappear d.Year;

Formula cells are created like this:


Spread1.AddCell(unusual FormulaCell(1, 6, "[c1r4]*[c2r6]", "Formula", NumericFormats.ToTheDollar));
See underneath after more examples of how formula cells work. Note also that there are two kinds of formulas, unsophisticated and multiline. The example underneath shows both types of formulas.
Code worn in this example
Initialization of a spreadsheet
Using MayerSoft.Web.Controls;
undisclosed void Page_Init(fact sender, System.EventArgs e)
{
Spread1.LicenseKey="eL! NJ@2H3aF"; / / representative key
}
undisclosed void Page_Load(fact sender, System.EventArgs e)
{
if(! IsPostBack)
{
Spread1.Columns.Add(unusual Column(150));
Spread1.Columns.Add(unusual Column());
Spread1.AddCell(unusual Cell(0, 0, "Item 1", "Label"));
Spread1.AddCell(unusual Cell(0, 1, "Item 2", "Label"));
Spread1.AddCell(unusual Cell(0, 2, "Total", "Label"));
Spread1.AddCell(unusual Cell(0, 3, "Div by pct", "Label"));
Spread1.AddCell(unusual Cell(0, 4, "Result", "Label"));
Spread1.AddCell(unusual Cell(0, 5, "Price

Search similar software using these keywords:

Control, Server, Asp, Scroll, Newsscroller, Filter, News, Display, 

Other software by MayerSoft LLC

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