Search:

» Home » Developer Tools » Components & Libraries » MayerSoft.Web.Controls.Spreadsheet

Company:	MayerSoft LLC
License:	Shareware
Version:	1
System:	Windows2000,Windows2003
Size:	125 KB
Date Released:	29-07-2004
Price:	19.95
Screenshot:	Click here to see Screenshot
Downloads:	814
Homepage:	http://mayers.us/MayerSoft/Default.aspx
Date added:	Sep 19, 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 » Developer Tools » Components & Libraries (1339)

Select page: [1] 2 3 4 5 6...

» Dragonfly Chart .Net

Dragonfly Chart .Net provides 2D/ 3D .Net Controls of pie chart, ring chart, bar chart, X-Y Chart and angle chart, which can be widely applied in many .Net applications such as Industrial Automation HMI applications, financial and insurance applications, ...

Dragonfly Automation Software | 6616 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 500 | Downloads: 811

Date added: Sep 19, 2005 | » Details

» MetaTree Component (for Delphi 5, 6, 7)

MetaTree is a control to show hierarchical information as a graphs tree. A user can select the desired node using mouse. It looks like a flat projection of a tree on an elliptical parabolic surface. The component distribution includes a sample application ...

MetaProducts Corporation | 569 KB | Windows | 70.00 | Downloads: 759

Date added: Sep 26, 2005 | » Details

» Oxygen SMS7110 ActiveX Control

Oxygen SMS7110 ActiveX Control for Nokia 3***, 62**, 71** and 8*** series GSM phones allows you to send text and picture messages, read and write default SMS centre number. The control can be incorporated into any programming environment that supports Act ...

Oxygen Software | 624 KB | Windows | 199 | Downloads: 758

Date added: Sep 19, 2005 | » Details

» Image2PDF Dynamic Link Library

The Image2PDF Dynamic Link Library is a simple utility that will convert one or more images into a PDF document. The conversion process is fully controlled through the provided Application Programming Interface and the Dynamic Link Library can be included ...

Utility Warrior | 304 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 4.99 | Downloads: 799

Date added: Sep 19, 2005 | » Details

» KeyboardControl SDK

KeyboardControl SDK allows to disable any hotkey or keystroke such as PrintScreen, Alt+Tab, Alt+F4, Ctrl+Tab, Ctrl+Alt+Del, Alt+Esc, Ctrl+F4 on Windows 95/98/Me and Windows NT/2000/XP. ...

| 530 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 299 | Downloads: 789

Date added: Sep 19, 2005 | » Details

» VeriFinger Linux SDK

VeriFinger Linux SDK is intended for most biometric system developers. It allows rapid development of the biometric application using functions from library, which ensure high reliability of the fingerprint identification, 1:1 and 1:N matching modes, comp ...

Neurotechnologija Ltd. | 155 KB | Linux | 299 | Downloads: 789

Date added: Sep 19, 2005 | » Details

» VideoEdit Pro (Encode MPEG) ActiveX Control

For Professional Windows Developers who need to provide editing video/audio files within their business application. convert video to MPEG1, MPEG2, VCD-PAL,VCD-NTSC, SVCD-PAL, SVCD-NTSC, DVD-PAL, DVD-NTSC, CUSTOM MPEG SIZE. Variable Bit rate / Constant Bi ...

Viscom Software | 5200 KB | Win98,WinME,WinXP,Windows2000 | 280 | Downloads: 758

Date added: Sep 26, 2005 | » Details

» Enhanced PictureBox ActiveX control

An enhanced PictureBox control can display a graphic from a bitmap, icon, or metafile, as well as enhanced metafile, JPEG, and animated or static Gif files. Additionally it provides information about the loaded file. It can stretch the output to fit the c ...

Inspired Creations | 94 KB | Windows | 43.95 | Downloads: 803

Date added: Sep 26, 2005 | » Details

» Shell MegaPack.Net

Shell MegaPack.Net brings drop-in Windows Explorer shell browsing functionality to your application. Consisting of a folder tree control, a file/folder list control and a drive-selection control, it mimics every Windows Explorer feature including Thumbnai ...

Sky Software | 1346 KB | Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 295 | Downloads: 588

Date added: Sep 19, 2005 | » Details

» ScroogeXHTML for Delphi(tm)

ScroogeXHTML for Delphi(tm) is a component which can convert RTF stored in files, strings or a RichEdit component to XHTML. It is fast, easy to customize and use and comes with full source code. It converts text attributes including background and highlig ...

Betasoft | 300 KB | Windows | 49 | Downloads: 790

Date added: Sep 26, 2005 | » Details

» DISLIN for Absoft Pro Fortran

DISLIN is a high-level library of subroutines and functions that display data graphically. It is intended to be a powerful and easy to use software package for programmers and scientists that does not require knowledge of hardware features. The software i ...

MPI fuer Sonnensystemforschung | 5234 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 150 | Downloads: 816

Date added: Sep 19, 2005 | » Details

» wodSFTP

The Secure File Transfer Protocol (SFTP Client) provides secure file transfer functionality over any reliable data stream, SSH in this case. It is the standard file transfer protocol for use with the SSH2 protocol. wodSFTP component implements client side ...

WeOnlyDo! Inc. | 1261 KB | Windows | 109 | Downloads: 764

Date added: Sep 26, 2005 | » Details

» VideoEdit Pro (Encode MPEG) ActiveX Control

Viscom Software | 5200 KB | Win98,WinME,WinXP,Windows2000 | 280 | Downloads: 780

Date added: Oct 25, 2007 | » Details

» MSCGzip for Windows

MSCGZip is GZip compression/decompression component. It allows you compress and decompress data and files using standard well-known Gzip data compression engine. ...

Miraplacid | 768 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 18.95 | Downloads: 773

Date added: Sep 19, 2005 | » Details

» BarCode-ActiveX

Barcode ActiveX Control.Add Barcode Printing to Access, VB, Web pages, C++, Excel etc. Simply insert the BarCode ActiveX Control into your application and specify a few properties in the properties window and your desired bar codes will be generated autom ...

RKD Software | 613 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows CE | 99.00 | Downloads: 828

Date added: Sep 26, 2005 | » Details

» MWStyleForm

A component to design your program formular under Delphi. Features: - Captionbar can be displayed left - Text of caption bar can be display with shaodw or border - You can define a backgroundpicture for Caption, Border and Content Please visit our website ...

Mostworks | 258 KB | Win98,WinME,WinNT 4.x,Windows2000,WinXP | 24 | Downloads: 722

Date added: Feb 12, 2007 | » Details

» SolFS Driver Edition SDK

With Solid File System Driver SDK your application can create a virtual disk, accessible for all or chosen processes. The data is kept in a SolFS storage. SolFS is is a virtual file system, stored in single file (or database record, file resource or just ...

EldoS Corporation | 6994 KB | WinXP,Windows2000,Windows2003 | 5400 | Downloads: 778

Date added: Feb 12, 2007 | » Details

» Bean Software Search Control

Beansoftware Search Control is ASP.NET web custom control that creates WHERE clause of SQL Query to database. It is R.A.D. tool intended for web designers and web developers to easily add searching features like product search, site search or any other da ...

Bean Software | 5 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 50 | Downloads: 819

Date added: Sep 19, 2005 | » Details

» Image2PDF Add-on

Image2PDF Add-on is a library that helps you to convert images to PDF using PDF Creator Pilot. You can apply filters, transform and rotate images, place watermarks on your images, convert entire folders of images to PDF using just a couple of methods from ...

Two Pilots | 3112 KB | Win95,Win98,WinME,Windows2000,WinXP,Windows2003 | 69.00 | Downloads: 788

Date added: Sep 19, 2005 | » Details

» Teroid Data Graph

Teroid Data Graph is a .NET Windows Forms control which draws a graph from any suitable ADO .NET data source. It can draw a column, line or bar graph, the data source can be a connection string, Connection object, a DataSet object, a DataTable object or a ...

Teroid Software Limited | 131 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | | Downloads: 733

Date added: Feb 12, 2007 | » Details

go to top

Select page: [1] 2 3 4 5 6...