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

» commandLine .NET

Secure and managed .net component that executes DOS and console commands. Each command executes asynchronously and raises events containing current output, completion status, and DOS ERRORLEVEL. Users can also set timeouts, abort commands, and simulate us ...

AS-Pro Software | 133 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000,MS-DOS | 29.95 | Downloads: 921

Date added: Sep 19, 2005 | » Details

» MSCExec for Linux

MSCExec allows you to call OS command or launch an application right from your script. You can set parameters for the call and check results. ...

Miraplacid | 120 KB | Linux | 58.95 | Downloads: 863

Date added: Sep 19, 2005 | » Details

» CubeInterfaceSDK

CubeInterfaceSDK provides you with extended library of figurate windows development. The main goal of this solution is to provide you with the possibility to use figurate windows in your applications written using any existing programming language or any ...

CubeReality | 3986 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 33.89 | Downloads: 800

Date added: Feb 12, 2007 | » Details

» EMS Excel Report

EMS Excel Report component for Delphi and C++ Builder is a powerful band-oriented generator of template-based reports in MS Excel. Easy-to-use component property editors allow you to create powerful reports in MS Excel quickly, easily and intuitively unde ...

EMS Software Development | 6615 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 65.00 | Downloads: 823

Date added: Sep 19, 2005 | » Details

» DBPix

DBPix is an Image Control for easily adding imaging capabilities to database and data-driven applications. It can be used with images stored in database tables (bound or unbound) or with external image files. Key features include asynchronous decoding, lo ...

Ammara Internet Limited | 4666 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000,Windows2003 | 349 | Downloads: 901

Date added: Sep 19, 2005 | » Details

» ASP/Export2ExcelPack

ASP/Export2ExcelPack is a server side COM component that allows web developers to export from DAO or ADO recordsets into MS Excel, HTML Table, XML, TXT, CSV, SYLK and DIF. ...

Nonnoi Solutions | 458 KB | Windows2000,WinXP,Windows2003 | 35 | Downloads: 1556

Date added: Feb 12, 2007 | » Details

» Xceed FTP for .NET

FTP without hassles The Xceed FTP Library for .NET is a robust and efficient 100% managed class library that allows you to easily add FTP file transfer capabilities to your .NET and ASP.NET applications. It provides access to the complete functionality of ...

Xceed Software Inc. | 24430 KB | Win95,Win98,WinME,WinXP,WinNT 3.x,WinNT 4.x,Windows2000,Windows2003 | 199.95 | Downloads: 835

Date added: Sep 19, 2005 | » Details

» SMS22 ActiveX

SMS22 ActiveX/COM enables your application to send SMS messages from any Internet-connected PC to any cellular phone on more than 300 cellular networks worldwide using public free reliable Internet-to-Cellular SMS gateways. SMS22 ActiveX/COM works with Vi ...

Touch22 Software & Consulting | 480 KB | Windows | 49 | Downloads: 869

Date added: Feb 12, 2007 | » Details

» Chilkat Encryption .NET Component

Chilkat Crypt .NET is an advanced encryption component that offers both RSA public-key encryption with digital signatures as well as symmetric encryption algorithms including AES (Rijndael), Blowfish, and Twofish. It provides the ability to easily create ...

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

Date added: Sep 19, 2005 | » Details

» aaxIniFile

The aaxIniFile ActiveX Control is a component that gives you an easy access to any standard .ini initialization file. With this component, you can: - Open standard .ini files; - Read / Write string and numeric values; - Enumerate sections and keys This co ...

aaxComponents | 646 KB | Windows | 25 | Downloads: 827

Date added: Sep 26, 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: 896

Date added: Sep 26, 2005 | » Details

» EaseSoft PDF417 ASP.NET Web Control

EaseSoft PDF417 Barcode ASP.NET Web ServerControls use its internal HttpHandler to transfer barcode images directly to the client without any temporary files.It is the most efficient method to generate the barcodes dynamically.EaseSoft PDF417 ASP .NEt Web ...

EaseSoft Inc. | 56 KB | Win98,WinME,Windows2000,WinXP,Windows CE | 129.00 | Downloads: 806

Date added: Sep 19, 2005 | » Details

» NCTSWFProducer.NET Library

NCTSWFProducer.NET is the pure .NET class library, which allows you to create Macromedia Flash (SWF) files.With NCTSWFProducer.NET classes you can: create movies; Add frames to existing movies; Add geometrical primitives to frames (line, curve, oval, rect ...

NCT Company | 489 KB | Windows | 149 | Downloads: 236

Date added: Sep 26, 2005 | » 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: 807

Date added: Sep 19, 2005 | » Details

» Aurigma File Downloader

File Downloader is a unique mass download solution for your sites. It enables end-users to download multiple files from your site with just few clicks. Let’s see how it works by an example. Assume that you have online file gallery, and this gallery allo ...

Aurigma Inc. | 1335 KB | Win98,WinME,WinNT 4.x,Windows2000,WinXP | 149 | Downloads: 854

Date added: Feb 12, 2007 | » Details

» NCTAudioStudio ActiveX DLL

It is a package of 14 ActiveX DLLs for designing audio enabled software. With its help you will be able to build really powerful audio applications. Record, mix, play, compress, decompress, convert, transform, grab and burn music CDs on the fly, add text- ...

NCT Company | 8579 KB | Windows | 299 | Downloads: 213

Date added: Sep 26, 2005 | » Details

» Cub Editor for MS Access 2000 and 2002

Cub Editor is an MS Access Report formatting wizard that allows MS Access developers, or end-users to easily create or modify attractive report layouts based on existing tables or queries. Cub Editor looks and behaves like the MS Access report wizard, onl ...

Peter`s Software | 518 KB | Windows | 35.95 | Downloads: 873

Date added: Sep 26, 2005 | » Details

» MailBee IMAP4

MailBee IMAP4 is a powerful and easy to use COM object which enables ASP and Windows applications to search, receive and manage mail on IMAP servers. New/unread message search, envelopes, body structures, correct and fast MIME parser, mailbox and message ...

AfterLogic | 1900 KB | Win98,WinME,WinNT 4.x,WinXP,Windows2000,Windows2003 | 69 | Downloads: 822

Date added: Sep 19, 2005 | » Details

» PlusDock

Custom docking windows library, featuring floating forms, autohide panels and redockable windows. Full Office2003 theme support, integrated WYSIWYG desginer support for VS.NET, fast rendering, accurate panel transitions and full documentation. Supports ta ...

Olvio IT, Inc. | 3727 KB | Win95,Win98,WinME,WinXP,Windows2000 | 165 | Downloads: 831

Date added: Sep 19, 2005 | » Details

» MS SQL Reporting Services Barcode .NET

Barcode Professional can generate the most popular Linear and 2D Barcode Symbologies. At design-time in Visual Studio .NET, Barcode Professional shows the barcode image in the specified image format (GIF, JPEG/JPG, PNG, and BMP). Barcode Professional supp ...

Neodynamic | 540 KB | Windows2000,WinXP,Windows2003 | 169 | Downloads: 830

Date added: Sep 19, 2005 | » Details

go to top

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