Submit Program | Contact us
downloads programs from a to z
This ASP.NET server control creates a spreadsheet grid and enables formulas, numbers, text, labels and dates in cells. Use in financi
Search:
 » Home » Development » Miscellaneous » MayerSoft.Web.Controls.Spreadsheet 1.0 FREE DOWNLOAD
Your download will start in 3 seconds... If not, try the following links:
Download Link 1 Report broken link
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
 « read more about MayerSoft.Web.Controls.Spreadsheet 1.0

RECOMMENDED DOWNLOADS IN THIS CATEGORY
 » Home  » Development » Miscellaneous (10) Select page: [1]
 » Aspose.Chart 1.0 Website License Basic Edition
Aspose.Chart is a .Net charting component. With it, you can: Draw 21 basic charts types including Area, Bar, Bubble, Contour, Candlestick, Cube, Curve, CurveArea, Doughnut, Gantt, HighLowClos ...
Aspose.com | 0 | Win 2000/XP | $199 | Downloads: 1943
Date added: Sep 22, 2005 |  » Details
 » Aspose.Chart 1.0 Website License Standard Edition
Aspose.Chart is a .Net charting component. With it, you can: Draw 21 basic charts types including Area, Bar, Bubble, Contour, Candlestick, Cube, Curve, CurveArea, Doughnut, Gantt, HighLowClos ...
Aspose.com | 0 | Win 2000/XP | $299 | Downloads: 1812
Date added: Sep 22, 2005 |  » Details
 » Aspose.Chart 1.0 Website License Professional Edition
Aspose.Chart is a .Net charting component. With it, you can: Draw 21 basic charts types including Area, Bar, Bubble, Contour, Candlestick, Cube, Curve, CurveArea, Doughnut, Gantt, HighLowClos ...
Aspose.com | 0 | Win 2000/XP | $399 | Downloads: 1744
Date added: Sep 22, 2005 |  » Details
 » Aspose.Chart 1.0 Webserver License Basic Edition
Aspose.Chart is a .Net charting component. With it, you can: Draw 21 basic charts types including Area, Bar, Bubble, Contour, Candlestick, Cube, Curve, CurveArea, Doughnut, Gantt, HighLowClos ...
Aspose.com | 0 | Win 2000/XP | $299 | Downloads: 1843
Date added: Sep 22, 2005 |  » Details
 » Aspose.Chart 1.0 Webserver License Standard Edition
Aspose.Chart is a .Net charting component. With it, you can: Draw 21 basic charts types including Area, Bar, Bubble, Contour, Candlestick, Cube, Curve, CurveArea, Doughnut, Gantt, HighLowClos ...
Aspose.com | 0 | Win 2000/XP | $399 | Downloads: 1865
Date added: Sep 22, 2005 |  » Details
 » Aspose.Chart 1.0 Webserver License Professional Edition
Aspose.Chart is a .Net charting component. With it, you can: Draw 21 basic charts types including Area, Bar, Bubble, Contour, Candlestick, Cube, Curve, CurveArea, Doughnut, Gantt, HighLowClos ...
Aspose.com | 0 | Win 2000/XP | $499 | Downloads: 1805
Date added: Sep 22, 2005 |  » Details
 » Aspose.Chart 1.0 Weboem License Basic Edition
Aspose.Chart is a .Net charting component. With it, you can: Draw 21 basic charts types including Area, Bar, Bubble, Contour, Candlestick, Cube, Curve, CurveArea, Doughnut, Gantt, HighLowClos ...
Aspose.com | 0 | Win 2000/XP | $399 | Downloads: 1786
Date added: Sep 22, 2005 |  » Details
 » Aspose.Chart 1.0 Weboem License Standard Edition
Aspose.Chart is a .Net charting component. With it, you can: Draw 21 basic charts types including Area, Bar, Bubble, Contour, Candlestick, Cube, Curve, CurveArea, Doughnut, Gantt, HighLowClos ...
Aspose.com | 0 | Win 2000/XP | $499 | Downloads: 1886
Date added: Sep 22, 2005 |  » Details
 » Aspose.Chart 1.0 Weboem License Professional Edition
Aspose.Chart is a .Net charting component. With it, you can: Draw 21 basic charts types including Area, Bar, Bubble, Contour, Candlestick, Cube, Curve, CurveArea, Doughnut, Gantt, HighLowClos ...
Aspose.com | 0 | Win 2000/XP | $599 | Downloads: 1755
Date added: Sep 22, 2005 |  » Details
 » Aspose.Spell 1.0 Website License Basic Edition
Aspose.Spell is a .Net multilingual spell checking component. With it,  you can: Check spelling in 12 languages, including Danish(DK), Dutch(NL), English(U ...
Aspose.com | 0 | Win 2000/XP | $199 | Downloads: 1854
Date added: Sep 22, 2005 |  » Details
 » Aspose.Spell 1.0 Winform License Standard Edition
Aspose.Spell is a .Net multilingual spell checking component. With it,  you can: Check spelling in 12 languages, including Danish(DK), Dutch(NL), English(U ...
Aspose.com | 0 | Win 2000/XP | $199 | Downloads: 2285
Date added: Sep 22, 2005 |  » Details
 » Aspose.Spell 1.0 Winform License Professional Edition
Aspose.Spell is a .Net multilingual spell checking component. With it,  you can: Check spelling in 12 languages, including Danish(DK), Dutch(NL), English(U ...
Aspose.com | 0 | Win 2000/XP | $299 | Downloads: 1849
Date added: Sep 22, 2005 |  » Details
 » Aspose.Spell 1.0 Website License Standard Edition
Aspose.Spell is a .Net multilingual spell checking component. With it,  you can: Check spelling in 12 languages, including Danish(DK), Dutch(NL), English(U ...
Aspose.com | 0 | Win 2000/XP | $299 | Downloads: 1843
Date added: Sep 22, 2005 |  » Details
 » Aspose.Spell 1.0 Website License Professional Edition
Aspose.Spell is a .Net multilingual spell checking component. With it,  you can: Check spelling in 12 languages, including Danish(DK), Dutch(NL), English(U ...
Aspose.com | 0 | Win 2000/XP | $399 | Downloads: 1841
Date added: Sep 22, 2005 |  » Details
 » Aspose.Spell 1.0 Webserver License Basic Edition
Aspose.Spell is a .Net multilingual spell checking component. With it,  you can: Check spelling in 12 languages, including Danish(DK), Dutch(NL), English(U ...
Aspose.com | 0 | Win 2000/XP | $299 | Downloads: 1818
Date added: Sep 22, 2005 |  » Details
 » Aspose.Spell 1.0 Webserver License Standard Edition
Aspose.Spell is a .Net multilingual spell checking component. With it,  you can: Check spelling in 12 languages, including Danish(DK), Dutch(NL), English(U ...
Aspose.com | 0 | Win 2000/XP | $399 | Downloads: 1827
Date added: Sep 22, 2005 |  » Details
 » Aspose.Spell 1.0 Webserver License Professional Edition
Aspose.Spell is a .Net multilingual spell checking component. With it,  you can: Check spelling in 12 languages, including Danish(DK), Dutch(NL), English(U ...
Aspose.com | 0 | Win 2000/XP | $499 | Downloads: 1788
Date added: Sep 22, 2005 |  » Details
 » Aspose.Spell 1.0 Weboem License Basic Edition
Aspose.Spell is a .Net multilingual spell checking component. With it,  you can: Check spelling in 12 languages, including Danish(DK), Dutch(NL), English(U ...
Aspose.com | 0 | Win 2000/XP | $399 | Downloads: 1707
Date added: Sep 22, 2005 |  » Details
 » Aspose.Spell 1.0 Weboem License Standard Edition
Aspose.Spell is a .Net multilingual spell checking component. With it,  you can: Check spelling in 12 languages, including Danish(DK), Dutch(NL), English(U ...
Aspose.com | 0 | Win 2000/XP | $499 | Downloads: 1833
Date added: Sep 22, 2005 |  » Details
 » Aspose.Spell 1.0 Weboem License Professional Edition
Aspose.Spell is a .Net multilingual spell checking component. With it,  you can: Check spelling in 12 languages, including Danish(DK), Dutch(NL), English(U ...
Aspose.com | 0 | Win 2000/XP | $599 | Downloads: 1866
Date added: Sep 22, 2005 |  » Details
go to top Select page: [1]
What Font is | fonts | free fonts | download fonts | free fonts download | web fonts |