This ASP.NET server control creates a spreadsheet grid and enables formulas, numbers, text, labels and dates in cells. Use in financi
Search:
All categories
Business
Desktop
Development
Education
Games
Internet
Multimedia
Utilities
»
Home
»
Development
»
Miscellaneous
»
MayerSoft.Web.Controls.Spreadsheet 1.0
Company:
MayerSoft LLC
License:
Commercial
Version:
1.0
System:
Win 2000
Size:
125KB
Date Released:
July 29, 2004
Price:
$19.95
Screenshot:
Click here to see Screenshot
Downloads:
902
Homepage:
http
Date added:
Sep 22, 2005
Click here to 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!
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
NEWS
So far, nothing for that!
RECOMMENDED DOWNLOADS IN THIS CATEGORY
»
Home
»
Development
»
Miscellaneous
(10)
Select page:
[
1
]
»
Know How Library 1.0
The program Know How Library is a database where you can store your collected tips, tricks and components. With the integrated search function you are able to find the tips and components you are looking for. ...
T-online.de | 0 | Win 95/NT/2000/XP/98/ME | E17.2 | Downloads: 1410
Date added: Sep 22, 2005 |
»
Details
»
Sniff`em Non-Profit 1.1 License 1.1
Sniff`em™ is a competitively priced, performance minded Windows based Packet sniffer, Network analyzer and Network sniffer, a revolutionary new network management tool designed from the ground up with ease and functionality in mind. This License is st ...
Sniff-em.com | 0 | Win 95/NT/2000/XP/98/ME | $120 | Downloads: 1380
Date added: Sep 22, 2005 |
»
Details
»
Aspose.Chart 1.0 Winform 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 | $99 | Downloads: 1419
Date added: Sep 22, 2005 |
»
Details
»
Aspose.Spell 1.0 Winform 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 | $99 | Downloads: 1416
Date added: Sep 22, 2005 |
»
Details
»
Aspose.License 1.0 Winform License Basic Edition
Aspose.License is a .Net software licensing component. With it, you can: Check against preset license fields as well as your own custom ...
Aspose.com | 0 | Win 2000/XP | $99 | Downloads: 1392
Date added: Sep 22, 2005 |
»
Details
»
LabVIEW Touchscreen File Dialog Toolset 1.0
The VIs included in this package give the users of your LabVIEW touchscreen applications the same level of file system access that they have come to expect from non-touchscreen applications. These toolkit VIs permit users to select files and/or directory ...
Bettervi.com | 0 | Win 3.1/95Unix / Linux Macinto | $79 | Downloads: 1372
Date added: Sep 22, 2005 |
»
Details
»
LabVIEW Touchscreen File Dialogs - Upgrade 1.0
The VIs included in this package give the users of your LabVIEW touchscreen applications the same level of file system access that they have come to expect from non-touchscreen applications. These toolkit VIs permit users to select files and/or directory ...
Bettervi.com | 0 | Win 3.1/95Unix / Linux Macinto | $45 | Downloads: 1406
Date added: Sep 22, 2005 |
»
Details
»
SlyControl 2.7
SlyControl allow to run and remotely control any Windows applications, like a CDPlayer, WinAmp, TV, Radio & DVD players. You can also remotely run screen saver, log off, reboot or shutdown system. SlyControl is a useful program that lets you remotely con ...
Com.ru | 0 | Win NT/2000/XP/98/ME | E20 | Downloads: 1514
Date added: Sep 22, 2005 |
»
Details
»
PureLoad Enterprise - 7 Day Rental 3.0
PureLoad is a load testing tool that simulates hundreds of users executing requests against server based applications. Use PureLoad to verify that your application will meet the expected performance criteria. PureLoad reports quality and performance probl ...
Minq.se | 0 | Unix / Linux Win NT/2000/XP | $2000 | Downloads: 1310
Date added: Sep 22, 2005 |
»
Details
»
PureLoad Web - 7 Day Rental 3.0
PureLoad is a load testing tool that simulates hundreds of users executing requests against server based applications. Use PureLoad to verify that your application will meet the expected performance criteria. PureLoad reports quality and performance probl ...
Minq.se | 0 | Unix / Linux Win NT/2000/XP | $1200 | Downloads: 1378
Date added: Sep 22, 2005 |
»
Details
»
Cookie Editor 1.5.x
Cookie Editor is a simple, yet powerful, utility giving you full control over Internet Explorer cookies stored on your hard drive by numerous web site you have visited. You can browse cookies, see their properties, edit or delete unwanted. You will be sur ...
Proxoft.com | 0 | Win 3.1/95/NT/2000/XP/98/ME | $12 | Downloads: 1450
Date added: Sep 22, 2005 |
»
Details
»
Aspose.Chart 1.0 Winform 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 | $199 | Downloads: 1368
Date added: Sep 22, 2005 |
»
Details
»
Aspose.Chart 1.0 Winform 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 | $299 | Downloads: 1365
Date added: Sep 22, 2005 |
»
Details
»
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: 1478
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: 1415
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: 1361
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: 1425
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: 1444
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: 1411
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: 1367
Date added: Sep 22, 2005 |
»
Details
go to top
Select page:
[
1
]
2005
downloads
What Font is
|
fonts
|
free fonts
|
download fonts
|
free fonts download
|
web fonts
|
Submit Program
|
Contact us
