MayerSoft.Web.Controls.Spreadsheet screenshot. free demo.   
 Example: Virtual CD • Top 1000
• Smart reviews

Home > Software > MayerSoft.Web.Controls.Spreadsheet 1.0 > Screenshot

MayerSoft.Web.Controls.Spreadsheet 1.0

This ASP.NET server control creates a spreadsheet grid and enables formulas, numbers, text, labels and dates in cells. Use in financial calculators or

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)
        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

Similar software:
  • ASP.NET Barcode Web Server Control 8.2 — Add barcodes easily with this web control for ASP.NET web applications. Barcodes dynamically appear in the web browser as high-quality images. Supports Linear and 2D types including Code 128, UPC-EAN, Code 39, Intelligent Mail, PDF417 and DataMatrix.
Find all software similar on MayerSoft.Web.Controls.Spreadsheet 1.0

Similar smart reviews:
  • ProxyInspector for ISA Server 2.6g Appropriate Control — When things get about the corporate Internet usage and traffic control, there always a lot of the loose talks: Either the management needs to control every kilobyte of data transfer and every connection or employees can have certain level of freedom? The answer to this question varies from one organization to another and depends on many factors…
  • Server Control Tower. PA Server Monitor — “How’s my server doing?” “What’s going on with it now?” “Hope, I haven’t missed anything important.” — These are the most typical things server administrators are concerned with. In order to not miss anything important, some of them never leave their seats. (Or, if there are…
Find all smart reviews similar on MayerSoft.Web.Controls.Spreadsheet 1.0

Home > Software > MayerSoft.Web.Controls.Spreadsheet 1.0 > Screenshot

See software by tags:
Book cover design templates
Icon database application
Affiliate commission
see also:
Dog Training Ebook
Type Accents
See software by tags:

Copyright © 2001—2016 3d2f