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:	953
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...

» SharpZipLib

#ziplib (pronounced SharpZipLib) is a free, open-source compression library for the .NET Framework. Data can be handled using the following formats: · Zip: This format archives multiple files into one file and compresses the results. Uses the deflate alg ...

ComponentSpot | 1255 KB | Win95,Win98,WinME,WinXP,WinNT 3.x,WinNT 4.x,Windows2000,Windows2003,Windows CE | | Downloads: 996

Date added: Sep 19, 2005 | » Details

» Chilkat Digital Certificates Component

Chilkat Certificate makes it easy to get information about the security certificates that are stored on your computer. It also allows you to easily add certificates to a certificate store, remove certificates from a store, or find a certificate that shoul ...

Chilkat Software, Inc. | 1000 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 0 | Downloads: 1032

Date added: Sep 19, 2005 | » Details

» dtControls

dtControls is a control library packaged as a single OCX control. Version 1.0 offers four useful controls (with more planned) in a single package: dtErrorProvider, dtLinkLabel, dtINILib, and dtTips ...

Digerati Technologies, LLC | 436 KB | Windows | 18.95 | Downloads: 891

Date added: Sep 26, 2005 | » Details

» RemoteUpdate2 ActiveX Control

Allow your customers to check for updated versions of your apps through the web! With Remote Update ActiveX Control you can quick and easily add the "Check for Updates" feature in your applications. Then, all users of your applications around th ...

Manitools Software | 573 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 79.00 | Downloads: 897

Date added: Sep 19, 2005 | » Details

» PDF417 2D Barcode ActiveX

MW6PDF417 2D barcode control implements the standard PDF417 and it is easy for you to create two dimensional, multi-row PDF417 barcode in Word, Excel, Access, Visual Basic and VC++. ...

MW6 Technologies, Inc. | 969 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows CE | 199 | Downloads: 893

Date added: Sep 19, 2005 | » Details

» PocketChart

PocketChart is a component for the .NET compact framework. It helps you create and present workflow, flowchart and process diagrams, database entity-relationship diagrams, organizational, hierarchy and relationship charts, network schemes, graphs and tree ...

MindFusion Limited | 435 KB | Windows CE | 500 | Downloads: 956

Date added: Sep 26, 2005 | » Details

» FreeDB OCX

FreeDB OCX 1.0 is an ActiveX control for software developers. This control can get the information about Audio CD from the internet, including the album name, artist name and tracks names. This control allows you to set the server name, port and other pro ...

audiocdtools.com | 161 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 39 | Downloads: 839

Date added: Feb 12, 2007 | » Details

» ! Chilkat SMTP / POP3 Components

A POP3 / SMTP ActiveX mail component for sending and receiving email. Packed with advanced features including: full S/MIME capability for sending and receiving signed and encrypted email, MHTML for sending HTML email with embedded images and style sheets, ...

Chilkat Software, Inc. | 2000 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 99 | Downloads: 1509

Date added: Sep 26, 2005 | » Details

» WebCab Probability and Stat for Delphi

Add Statistics, Discrete Probability, Standard Probability Distributions, Hypothesis Testing, Correlation and Linear Regression functionality to your .NET, COM, and XML Web service Applications. Statistics Module Incorporates topic from data presentation ...

WebCab Components | 5859 KB | Win98,WinNT 4.x,Windows2000,WinXP,Windows2003 | 179 | Downloads: 315

Date added: Sep 19, 2005 | » Details

» Catchysoft Report Generator Pro

Catchysoft Report Generator Pro is a flexible and inexpensive report generating library that utilizes ActiveX (also known as COM) technology. Therefore the reporting capabilities can be used from any programming language that can use ActiveX components. T ...

CatchySoft.com | 428 KB | Win95,Win98,WinME,WinXP,WinNT 3.x,WinNT 4.x,Windows2000,Windows2003 | 29 | Downloads: 923

Date added: Feb 12, 2007 | » Details

» Virtual Serial Port Driver XP4

Virtual Serial Port Driver XP4 creates two pure virtual serial ports in your system which are virtually connected to each other. For other Windows applications, virtual ports will be seen exactly as two real serial ports connected via null-modem cable. Yo ...

ELTIMA Software GmbH | 1505 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000 | 111.95 | Downloads: 880

Date added: Sep 19, 2005 | » Details

» DC Num2Text

Num2Text convert numerical values into words in 4 languages<br> For example, the numerical value 7431285.46 would be translated into Seven millions , four hundreds and thirty one thousands , two hundreds and eighty five dollars . ...

EgyFirst Software , inc | 481 KB | Win98,WinME,WinXP,WinNT 4.x,Windows2000 | 149 | Downloads: 913

Date added: Feb 12, 2007 | » Details

» Source Code Scanners for C++ Builder 6

Source Code Scanners is the high performance library of visual components for C++ Builder and Delphi intended for creating analyzers and parsers of source codes. It includes components of the lexical analyzers: C++, Object Pascal (Delphi), PHP, HTML, CSS1 ...

MBLabSoft | 1169 KB | Win95,Win98,WinME,WinXP,WinNT 3.x,WinNT 4.x,Windows2000,Windows2003 | 40 | Downloads: 914

Date added: Sep 19, 2005 | » Details

» Xceed Backup Library

The Xceed Backup Library is an ActiveX control that allows Windows applications to automatically perform scheduled or on-demand backup and restore operations on their data files. The library can backup to local drive(s), remote drives, and removable media ...

Xceed Software Inc. | 21034 KB | Windows | 249.95 | Downloads: 911

Date added: Sep 19, 2005 | » Details

» Nevron Chart for Windows Forms

Nevron Chart for Windows Forms is the leading charting component for Windows Forms applications. The component delivers rich charting functionality suitable for presentation, scientific, financial and business charts. This combined with the presentation â ...

Nevron LLC | 10198 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 489 | Downloads: 841

Date added: Sep 19, 2005 | » Details

» Movie Player Pro ActiveX OCX SDK

For Professional Windows Developers who need to provide video/audio media playback function within their business application. powerful media player activex. Support Mov, M4a, Mp4 with aac audio, 3gp with amr audio, Avi, Wmv (window media video), asf, RM ...

Viscom Software | 53 KB | Win98,Windows2000,WinXP | 150 | Downloads: 915

Date added: Oct 25, 2007 | » Details

» PDF Chart Creator Dynamic Link Library

The PDF Chart Creator Dynamic Link Library is a simple utility that will create charts from data as a PDF document. The conversion process is fully controlled through the provided Application Programming Interface and the royalty free Dynamic Link Library ...

Utility Warrior | 238 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 89.99 | Downloads: 657

Date added: Feb 12, 2007 | » Details

» DeskewHelper

Deskew is the preprocessing operation of removing skew from images (especially bitmaps created using a scanner). Skew is an artifact that can occur in scanned images because of the camera being misaligned, imperfections in the scanning or surface, or simp ...

Personal PC Helpers | 614 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003,Linux | 18 | Downloads: 865

Date added: Feb 12, 2007 | » Details

» Active Metadata

Active Metadata is an ActiveX component to get and set additional image information. Usually these includes copyright, digital camera model, or program by which this image is made. Also you can get creation date, comments, exposure time, resolution, color ...

Avalio Inc | 1277 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 8.95 | Downloads: 1039

Date added: Sep 19, 2005 | » Details

» 2D / 3D DXF Import .NET

DXF Import .NET is an easy-to-use API for reading AutoCAD DXF in C# and VB.NET applications. It is completely programmed in C# and supports the following entities: 3dFace Arc Attdef Block BlockRecord Circle Dimension Ellipse Insert Layer Line LWPolyline M ...

CADSoftTools | 934 KB | Win95,Win98,WinXP,Windows2000,Windows2003 | 245 | Downloads: 1353

Date added: Feb 12, 2007 | » Details

go to top

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