|
|
Home : Development : Components & Libraries
MayerSoft.Web.Controls.Spreadsheet
MayerSoft.Web.Controls.Spreadsheet Details:
| Publisher:
|
MayerSoft LLC |
| Version:
|
1.0 |
| License:
|
Commercial |
| Price:
|
$19.95 |
| Operating Systems:
|
Windows2000,Windows2003 |
| File Size:
|
0.12 MB |
| Total Views:
|
215 |
| Total Downloads:
|
0 |
| Rating:
|
 (4 out of 5 Stars) |
| Release Date:
|
7/29/2004 |
| Last Update:
|
2/26/2006 |
|
|
|
Screenshot:
|
Please click to display full view of
MayerSoft.Web.Controls.Spreadsheet screenshot.
|
MayerSoft.Web.Controls.Spreadsheet Short Description:
ASP.NET spreadsheet Cells may contain text, labels, dates, numbers or formulas.
|
MayerSoft.Web.Controls.Spreadsheet Long 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 Keywords:
asp.net server control spreadsheet mayersoft
|
|
|
MayerSoft.Web.Controls.Spreadsheet Reviews by Users
Total Reviews: 0
Total Points: 0
Submit your review
|
We deliver articles like below right to your inbox for free:
Bad fstab Boot Failure in Linux
by Jerry Tim
Sometimes when you boot your Linux based computer, you may find that your system stucks in the boot window or it aborts the boot process. In these cases, you need to restart and the system but the same situation occurs again and again. CauseThis problem generally occurs if fstab directory contains wrong or corrupted or missing information form system related mount points. In these situations the boot process aborts when the operating system tries to write log information to th...
The Coolest Way to Launch Applications
by Zach Hope
When it comes to launching applications Windows XP is not the most efficient tool ever devised. Mac OS X has an infinitely better looking solution - the Dock is one of the most beautifully illustrated and nicely animated tool bars to grace computer screens. One day I suddenly decided that I wanted a really slick way of starting applications on my PC. I started off with Object Desktop - a program that adds an almost perfect OS X Dock to the bottom of the screen. It animates perfectly and...
Tracking Software - Students Activities
by Neerja Shukla
Nowadays every university, technical institute, college's students are connecting with online educational courses through internet. Now it's doesn't matters he had missed lecture or seminar. He can attend them online within a limited interval of time from their high tech internet lab. The institutions provide this high tech facility to enhance their knowledge. But some of them use lab to spoil educational atmosphere of university, technical university or college. They are wasting their time in w...
Developers' Icon Toolkit
by Victor Ivlichev
Have you ever wanted to manage, change and make new icons? Whether you are a home user or a professional developer Aha-Soft will help you. Icon creation, modification and conversion has never been easier with two awesome software packages - Any-to-Icon and ArtIcons which prove to be two most powerful and easy-to-use tools at a very low price. Just imagine how dull computers would be if all software developers and game creators used an identical or standard icon. Fortunately, th...
IT Certification Training Solution
by Fandy Du
QuickTrainingSolution is an independent IT Certification Company that specializes in providing learning solutions. We offer helpful suggestions, materials, and tips that are aimed to save you time, and money. Our service is dedicated to helping you get certified in the most convenient way. We offer fast solution to achieve MCSE 2003 Certification</...
|
Recommended Products:
|
|
|
|
|