Home | Software Development | Other Software Developement | MayerSoft.Web.Controls.Spreadsheet

MayerSoft.Web.Controls.Spreadsheet 1.0

 MayerSoft.Web.Controls.Spreadsheet 1.0 details
 Developer:
 MayerSoft LLC
 Downloads:
  51
 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

  MayerSoft.Web.Controls.Spreadsheet  EXCELENT AWARD 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:

Related software

Word-2-CHM Converter 3.0.1.167 - (2006-10-20)
A tool that can convert your Word documents into CHM help or CHM e-book.
License: Shareware Size: 1.71 MB Price: 79.00$ Downloads: 27 [Download]
Hex Editor ActiveX Control 1.1 - (2007-12-29)
Edit as bin/octal/dec/text; Undo/Redo; Insert/Over; Print;Clipboard;Color coding
License: Shareware Size: 0.29 MB Price: 30.00$ Downloads: 92 [Download]
QuickUML Windows 2.0.1 - (2006-10-06)
QuickUML is a software design tool that supports core UML models.
License: Demo Size: 7.90 MB Price: 295.00$ Downloads: 27 [Download]
SDE for JBuilder (ME) for Linux 3.3 Modeler Edition - (2006-07-07)
JBuilder UML modelling plug-in: UML diagrams, MS Visio integration, ...
License: Commercial Size: 91.54 MB Price: 99.00$ Downloads: 49 [Download]
Enhanced PictureBox ActiveX control 2.0 - (2007-08-26)
An enhanced PictureBox ActiveX control can display image files and animation.
License: Demo Size: 0.09 MB Price: 43.95$ Downloads: 66 [Download]
Home | New | Submit | Link to us | Contact Copyright © RoxySoft.com [0.261 s]
eXTReMe Tracker