MayerSoft.Web.Controls.Spreadsheet 1.0
|
|
|
MayerSoft.Web.Controls.Spreadsheet 1.0 details
Developer:
MayerSoft LLC
Downloads:
107
License:
Commercial
Size:
0.12 MB
Price:
19.95$
Version:
1.0
Operating System:
Windows2000, Windows2003
System requirements:
Date added:
2007-12-30
Date updated:
2007-12-30
Price:
19.95$
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
Related keywords:
convert excel spreadsheet to html | excel spreadsheet | spreadsheet reports | fax numbers | visitor numbers | recovery spreadsheet | hot numbers | extract fax numbers | customer numbers | spreadsheet models | spreadsheet excel | search fax numbers | list spreadsheet | search phone numbers | hot and cold numbers | numbers icq | extract phone numbers | winning lottery numbers | image cells
Related software
GraphInquire ActiveX 1.0 - (2007-12-29)
GraphInquire is a chart for time series analysis and similar applications.
License: Shareware Size: 3.6 MB Price: 5.00$ Downloads: 71 [Download]
GraphInquire is a chart for time series analysis and similar applications.
License: Shareware Size: 3.6 MB Price: 5.00$ Downloads: 71 [Download]
Projects Explorer 1.83 - (2007-10-31)
Projects Explorer is an enterprise level problem tracking system
License: Freeware Size: 2.24 MB Price: 0.00$ Downloads: 117 [Download]
Projects Explorer is an enterprise level problem tracking system
License: Freeware Size: 2.24 MB Price: 0.00$ Downloads: 117 [Download]
SpriteCraft 3.x - (2007-12-24)
No description available!
License: Freeware Size: MB Price: 0.00$ Downloads: 93 [Download]
No description available!
License: Freeware Size: MB Price: 0.00$ Downloads: 93 [Download]
llPDFLib 3.6 - (2008-01-12)
llPDFLib is pure Object Pascal library for create PDF documents.
License: Shareware Size: 1.41 MB Price: 299.00$ Downloads: 91 [Download]
llPDFLib is pure Object Pascal library for create PDF documents.
License: Shareware Size: 1.41 MB Price: 299.00$ Downloads: 91 [Download]
Page Edit Web authoring software 4.2 - (2007-10-31)
Page Edit Web authoring software allows you to create Web pages without Html.
License: Shareware Size: 1.94 MB Price: 25.50$ Downloads: 60 [Download]
Page Edit Web authoring software allows you to create Web pages without Html.
License: Shareware Size: 1.94 MB Price: 25.50$ Downloads: 60 [Download]
Realtek HD ALC 880 Audio CODECs v 1.88 for Windows Vista
AOpen i915Ga-EFRII Bios Utility v V1.04.43
ASRock ConRoe1333-DVI/H R2.0 Bios v 1.70
Matrox Parhelia/P650/P750 1.06 Beta (Windows 2000/XP)
BTC DRW1108IM Firmware v VB030
Gigabyte GA-M55plus-S3G (rev. 3.0) Bios v F6
Albatron PX915GD Pro II Bios v R1.37
3Com OfficeConnect Cable Modem External - 3CR29210 (Windows 2000)
Intel Express BIOS Update for D845GERG2/D845GEBV2 P11 build 0019
Abit LG-80 Bios v 1.3
Albatron PX925X Pro-R Bios v R1.09a(Beta)
Epson Stylus Photo RX700 Driver v 6.5aAs for Windows Vista
AOpen EX661L SIS VGA Driver v R3.59
ECS J10IL 3G Driver v 2008/11/19
Albatron PX915G4C Pro Bios v R1.24
AOpen i915Ga-EFRII Bios Utility v V1.04.43
ASRock ConRoe1333-DVI/H R2.0 Bios v 1.70
Matrox Parhelia/P650/P750 1.06 Beta (Windows 2000/XP)
BTC DRW1108IM Firmware v VB030
Gigabyte GA-M55plus-S3G (rev. 3.0) Bios v F6
Albatron PX915GD Pro II Bios v R1.37
3Com OfficeConnect Cable Modem External - 3CR29210 (Windows 2000)
Intel Express BIOS Update for D845GERG2/D845GEBV2 P11 build 0019
Abit LG-80 Bios v 1.3
Albatron PX925X Pro-R Bios v R1.09a(Beta)
Epson Stylus Photo RX700 Driver v 6.5aAs for Windows Vista
AOpen EX661L SIS VGA Driver v R3.59
ECS J10IL 3G Driver v 2008/11/19
Albatron PX915G4C Pro Bios v R1.24

