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

» Stampa Reports System

Stampa Reports System is a professional solution for quick and easy generation of .NET, ASP.NET and PDF reports. Create easy-embeddable reports ready to be called from within your .NET application and filled with appropriate display data. ...

Dynamica | 818 KB | Win98,WinME,Windows2000,WinXP,Windows2003 | 35 | Downloads: 708

Date added: Feb 12, 2007 | » Details

» Chilkat SSL COM Component

Chilkat SSL is a free COM component that makes it extremely easy to communicate securely over a TCP socket using either the SSLv3 or TLSv1 protocols. This component is designed to be used by C++ applications, and cannot be used from Visual Basic or ASP. ...

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

Date added: Sep 19, 2005 | » Details

» ViewPDF OCX

ViewPDF OCX is an ActiveX component which enables your application to display and interact with PDF files. Simply place the control on your form, set the Path property, and you are all set! ViewPDF OCX is identical to Adobe Acrobats PDF Reader program. ...

SkySof Software Inc. | 1505 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 199.95 | Downloads: 654

Date added: Sep 19, 2005 | » Details

» ScDemo

This is a demo of a SDK witch allows you to include linear, PDF417 and DataMatrix barcode recognition features in your own programs. It reads black-white, gray and color TIFF, PNG, JPG and BMP images and detects the most important linear barcode types and ...

Stecos Softwares | 795 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003,Linux | 0 | Downloads: 675

Date added: Oct 25, 2007 | » Details

» SocketWrench .NET Edition

The SocketWrench .NET Edition is a managed code class that simplifies the task of developing TCP/IP networking applications in Visual Studio .NET using any of the available programming languages such as Visual Basic and C#. SocketWrench is ideal for the d ...

Catalyst Development Corporation | 2699 KB | Windows2000,WinXP,Windows2003 | 195.00 | Downloads: 672

Date added: Oct 25, 2007 | » Details

» A.M.L. - Lite Edition : Advanced Media Library

The Elefun Company has released A.M.L. - a Advanced Multimedia Library. This Multimedia Library is intended for games` and multimedia applications` developers. A.M.L. is an effective multimedia library, capable of playing practically all audio formats, mi ...

EleFun Multimedia | 150 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000 | 9.95 | Downloads: 721

Date added: Sep 19, 2005 | » Details

» aaxBattery

The aaxBattery ActiveX Control is a component that gives you the state of the battery on your laptop/notebook computer. With this component, you can: - Get the battery life in percent and time; - Get the charging status of the battery; - Get the AC Line s ...

aaxComponents | 661 KB | Windows | 25 | Downloads: 691

Date added: Sep 26, 2005 | » Details

» ASP Printer COM

Print your documents, files and data from ASP pages, HTML pages or from any other programming language using just a single line of code! ASP Printer COM is a 32-bit ActiveX COM component (DLL) that enables you to print almost anything from within your ASP ...

VBGold Software | 2291 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 39.95 | Downloads: 714

Date added: Feb 12, 2007 | » Details

» SohoCalendar

SohoCalendar has been implemented in order to provide ASP.NET developers with an easy yet visual way to select date and/or time in web forms and applications. Both inline and popup approaches supported. Transparency, built-in localization and other featur ...

Softaholic.com | 462 KB | WinXP,Windows2000 | 19 | Downloads: 655

Date added: Sep 19, 2005 | » Details

» RChart for .NET

Windows and web .NET control for charting. The assembly has been developed in c# and supports more then 18 types of charts and combinations of them. It can be used in a windows or in a web application and supports interactive features like zoom, scroll, t ...

J4L Components | 351 KB | Win95,Win98,WinNT 4.x,Windows2000,Unix,Linux,Windows CE | 30 | Downloads: 624

Date added: Feb 12, 2007 | » Details

» NMath Stats

NMath Stats contains a data table class with functions for computing descriptive statistics, such as mean, variance, standard deviation, percentile, median, quartiles, geometric mean, harmonic mean, RMS, kurtosis, skewness, and many more; PDF, CDF, invers ...

CenterSpace Software | 4000 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows CE | 495 | Downloads: 714

Date added: Sep 19, 2005 | » Details

» ASP/Export2Access

ASP/Export2Access is a server side COM component that allows web developers to export from DAO or ADO recordsets into MS-Access (MDB) file. ...

Nonnoi Solutions | 376 KB | Windows2000,WinXP,Windows2003 | 35 | Downloads: 1491

Date added: Feb 12, 2007 | » Details

» System Mouse

System Mouse - Mouse Cursors, Clipping and Moving Component System Mouse (TSystemMouse component) allows you to get and set the mouse position, move mouse cursor into any control or window, change and restore any system default cursor and clip the mouse m ...

Greatis Software | 1527 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | | Downloads: 615

Date added: Feb 12, 2007 | » Details

» HS X.25 C Source Library

HS X.25 is a software library in C (supplied with full source code) which implements ITU-T recommendation X.25 - Interface between Data Terminal Equipment (DTE) and Data Circuit-terminating Equipment (DCE) for terminals operating in the packet mode and co ...

Hillstone Software | 344 KB | Win 3.1x,Win95,Win98,WinME,WinXP,WinNT 3.x,WinNT 4.x,Windows2000,Windows2003,Windows CE | 0 | Downloads: 686

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

Date added: Sep 19, 2005 | » Details

» Client/Server Comm Lib for Visual Basic

Client / Server communication control for VB (and VB.NET) is a TCP/IP communication component DLL library. CSC4VB uses the standard Windows API to communicate with other programs (written using CSC) across any TCP/IP network such as the Internet or intran ...

MarshallSoft Computing, Inc. | 206 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 105 | Downloads: 1077

Date added: Sep 19, 2005 | » Details

» AidAim CryptoPressStream

CryptoPressStream is a streaming compression and encryption library. It provides transparent access to compressed or encrypted data stored in the stream object. All stream objects are 100% compatible with TStream and have some advanced functionality like ...

AidAim Software LLC | 1062 KB | Win95,Win98,WinME,WinXP,WinNT 3.x,WinNT 4.x,Windows2000,Windows2003 | 95 | Downloads: 761

Date added: Sep 19, 2005 | » Details

» Poom .Net

Poom .Net introduces an easy way for you to work with Appointments, Contacts and Tasks features of Pocket Outlook. Now you have ideal assistant to build application onto Pocket Outlook functionality. The Poom .Net has all the features you will need to pro ...

Handy Labs | 630 KB | Windows CE | 37.95 | Downloads: 757

Date added: Sep 19, 2005 | » Details

» Pivo Whois Component

Whois Tool is a client utility that communicates with WHOIS servers located around the world to obtain domain registration information. Whois is a protocol for submitting a query to a database for determining the owner of a domain name, an IP network, or ...

Pivo Corporation | 232 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003,Unix,Linux,MAC 68k,Mac PPC,Mac OS X,Mac Other | 0 | Downloads: 639

Date added: Feb 12, 2007 | » Details

» Maverick.NET

Maverick.NET is a lightweight professional API for the Microsoft .NET framework. The product is written using 1000% managed C#, is compatible with all versions of the framework and supports SSH1, SSH2, SFTP and SCP. No external dependencies are required. ...

3SP Ltd | 4947 KB | Not Applicable | 570 | Downloads: 661

Date added: Feb 12, 2007 | » Details

go to top

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