MayerSoft.Web.Controls.Spreadsheet 1.0 details
Company: MayerSoft LLC [More Softs]
Release date: 2004-07-29
Last update: 2006-07-13
Price:19.95 $
License: Commercial
Platform: Windows2000,Windows2003
Language: English
File size: 125 KB

Rate this software:
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 1.0 screenshot:
Notification and links
If you would like to be notified when this program is updated enter you email and subscribe to our newsletter
|
Download MayerSoft.Web.Controls.Spreadsheet 1.0 |
MayerSoft.Web.Controls.Spreadsheet 1.0 review and details |
Sponsored Links
Related MayerSoft.Web.Controls.Spreadsheet
Polar Crypto Light Free 2.5
Full strength, up to 256-bit key, symmetric AES encrypt
Price:0$, Rating: 0, Downloads: 35
Full strength, up to 256-bit key, symmetric AES encrypt
Price:0$, Rating: 0, Downloads: 35
Raw Data Printer Component 2.0
Send Raw Data & Native Printer Commands (ESC Codes) To Any Printer
Price:49.95$, Rating: 0, Downloads: 729
Send Raw Data & Native Printer Commands (ESC Codes) To Any Printer
Price:49.95$, Rating: 0, Downloads: 729
Alvas.Audio 5.0
Allows .Net developers to create applications that play, record, convert sound.
Price:295$, Rating: 0, Downloads: 297
Allows .Net developers to create applications that play, record, convert sound.
Price:295$, Rating: 0, Downloads: 297
Universal Software Oscilloscope Library 2.2.0
Real-time universal oscilloscope GUI ( Real-time plot ) DLL library.
Price:0$, Rating: 43.92, Downloads: 757
Real-time universal oscilloscope GUI ( Real-time plot ) DLL library.
Price:0$, Rating: 43.92, Downloads: 757
Resource-Grabber 2.68d
Extract thousands of glyphs/images/sounds from other programs!
Price:29.00$, Rating: 0, Downloads: 633
Extract thousands of glyphs/images/sounds from other programs!
Price:29.00$, Rating: 0, Downloads: 633
Ajax-Controls.NET 1.2.0.0
Ajax-Controls.NET is designed to AJAX enable any ASP.NET applications
Price:89$, Rating: 0, Downloads: 1148
Ajax-Controls.NET is designed to AJAX enable any ASP.NET applications
Price:89$, Rating: 0, Downloads: 1148

