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

» PDF OCX

ActiveX control for Visual Basic to automatically create Adobe Acrobat PDF files from Excel worksheets, Access reports, Word documents, text files, and image files. ...

SkySof Software Inc. | 1000 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 49.95 | Downloads: 895

Date added: Sep 26, 2005 | » Details

» Print Preview OCX

A Print Preview OCX for Visual Basic 6. The control gives you full control over design with methods to add new pages, change from portrait to landscape, change fonts, sizes and add effects such as underline and bold. Methods for adding set headings. Draw ...

Gary Newell | 385 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 2 | Downloads: 888

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: 990

Date added: Sep 26, 2005 | » Details

» Aztec 2D Barcode ActiveX

Aztec ActiveX is a powerful ATL-based barcode control generating the Aztec 2D barcode and can be used in any ActiveX-compliant environment like Word, Access, Excel, VB.Net, C#.Net, Visual Basic, Visual C++, Visual FoxPro, Delphi and C++ Builder. ...

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

Date added: Sep 19, 2005 | » Details

» 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: 1022

Date added: Sep 19, 2005 | » Details

» RADvolution Designer - Professional

Rapidly build applications without coding and with a high level of maintainability. Layout engine ----------------- Ever dreamed of a correct layout at once? Just by dropping controls? Without any layout panels? Just imagine: no more hassle with aligning, ...

DevelopGuidance | 4674 KB | WinNT 4.x,Windows2000,WinXP,Windows2003 | | Downloads: 894

Date added: Sep 19, 2005 | » Details

» AddFlow for .NET

AddFlow for .NET is a .NET Windows Forms Custom control. It provides approximately the same flowcharting/diagramming features as the ActiveX version but also some new features (class derivation, OwnerDraw property, Anti-Aliasing, custom shapes, property b ...

Lassalle Technologies | 3287 KB | Win95,Win98,WinNT 4.x,Windows2000,WinXP | 499 | Downloads: 1032

Date added: Feb 12, 2007 | » Details

» 3D Control Magic for .NET

3D Control Magic for .NET is the ultimate 3D control component developed with the purpose of replacing some of the old fashioned Windows flat controls in applications written with Visual Studio.NET 3D Control Magic is not only an enhanced alternative Push ...

MultiMedia Soft | 4037 KB | Win98,WinME,WinXP,Windows2000 | 199 | Downloads: 1059

Date added: Sep 19, 2005 | » Details

» RADvolution Designer - Standard Edition

The easy way to design and maintain professional .NET forms in no-time. Ever dreamed of a correct layout at once? Just by dropping controls? Without any layout panels? Just imagine: no more hassle with aligning, tab orders and anchors! And still have tota ...

DevelopGuidance | 4674 KB | WinNT 4.x,Windows2000,WinXP,Windows2003 | | Downloads: 937

Date added: Sep 19, 2005 | » Details

» Window Image Capture

Develop your own window image capture tools to capture any active window or inactive window ( hidden windows or background windows) image and save it to the BMP file or JPEG file. The most powerful feature is capability to capture the background window im ...

Dragonfly Automation Software | 936 KB | Windows | 39.00 | Downloads: 957

Date added: Sep 26, 2005 | » Details

» DC Image Button

Image Button is a COM based component that allows you to assign changable button icons for each state , where mouse over , mouse leave and mouse down<br> there is no need to change icons manually for every button if you want to change the applicatio ...

EgyFirst Software , inc | 929 KB | Win98,WinME,WinXP,WinNT 4.x,Windows2000 | 29 | Downloads: 928

Date added: Feb 12, 2007 | » Details

» WebCab Probability and Stat (J2SE Ed.)

Offers functionality from Basic Statistics, Discrete Probability, Standard Probability Distributions, Hypothesis Testing, Correlation and Linear Regression. Statistics Module The Statistics module incorporates evaluation procedures of standard quantitativ ...

WebCab Components | 7617 KB | Win98,Windows2000,WinXP,Windows2003,Unix,Linux | 199 | Downloads: 282

Date added: Sep 19, 2005 | » Details

» Report Sharp-Shooter Express

Report Sharp-Shooter Express is the first, free reporting engine of such high class. The component is designed for .NET Framework 1.1 and 2.0 and provides vast capabilities for designing professional and multi-functional reports in Windows Forms applicati ...

Perpetuum Software | 32541 KB | Win98,WinME,WinXP,Windows2000,Windows2003 | 0.00 | Downloads: 908

Date added: Feb 12, 2007 | » Details

» Registration Creator ActiveX v4.0

Registration Creator is our latest software licensing control. With few lines of code, you can protect your software with cutting-edge technology from hackers, crackers and the occasional friend-to-friend software sharing. Registration Creator gives your ...

D & L Comuting, Inc. | 10935 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 129.95 | Downloads: 835

Date added: Sep 19, 2005 | » Details

» Aspose.ASPXpand

Aspose.ASPXpand is a ASP.Net component that provides a set of DHTML functions to make development easier. Aspose.ASPXpand gives you a chance to bring to ASP.Net what you had in desktop development! Microsoft did a wonderful job of marrying web development ...

Aspose Pty Ltd | 1216 KB | WinXP,Windows2000,Windows2003 | 108 | Downloads: 1017

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: 1383

Date added: Feb 12, 2007 | » Details

» VLButtonBar

VLButtonBar is a versatile navigation control. It can be deployed as outlook bar, vertical menu, visual basic styled toolbox, etc. It allows arranging buttons in groups, each identified by its header. Buttons have associated icon and text. Gradient filled ...

Viklele Consulting | 1788 KB | Windows | 149 | Downloads: 1003

Date added: Sep 26, 2005 | » Details

» EZShellExtensions.Net

EZShellExtensions.Net is a set of components for fast, painless and easy development of Windows shell extensions. EZShellExtensions eliminates the time-consuming, error-prone and complicated process of developing shell extensions using an innovative yet s ...

Sky Software | 944 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 95 | Downloads: 736

Date added: Feb 12, 2007 | » Details

» Command22 ActiveX

All COM objects included into the Command22 package are used for running the console application or MS DOS commands from inside your application without bringing up the command prompt (MS DOS) window and providing your application with methods to control ...

Touch22 Software & Consulting | 612 KB | Windows | 18 | Downloads: 1021

Date added: Sep 26, 2005 | » Details

» UploadEncrypt

Protect and unlock files on your web site with these easy to use .NET components. Includes web server license and comprehensive help file with sample code covering C#, Visual Basic and ASP.NET. ...

Imagio Technology Ltd. | 95 KB | Windows | 99 | Downloads: 952

Date added: Sep 26, 2005 | » Details

go to top

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