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

» Modeling Studio

The DInsight product suite includes Modeling Studio, native and .NET versions of KernelCAD ActiveX control, and free downloadable Model Viewer. Although DI Modeling is a standalone 3D modeling system DInsight suite is ideal as a CAD for software developer ...

DInsight | 7212 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 120 | Downloads: 683

Date added: Sep 19, 2005 | » Details

» Chilkat POP3 .NET Component

A POP3 / SMTP email .NET 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, m ...

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

Date added: Sep 19, 2005 | » Details

» monoASPUpload

monoASPUpload component is COM-component designed to easy access to data received from HTML-forms of client`s browser with attribute enctype=`multipart/form-data` when developing Active Server Pages applications. monoASPUpload component is based on Window ...

MonocerosSoft | 13 KB | Windows2000,WinXP,Windows2003 | 49 | Downloads: 660

Date added: Sep 19, 2005 | » Details

» Easy Compression Library

With Easy Compression Library you can add advanced compression and encryption functionality to your projects as quickly and easily as never before. Based on new original One-Stream technology, this toolkit has everything you need to compress and encrypt f ...

ComponentAce LLC | 1078 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000 | 145 | Downloads: 690

Date added: Sep 19, 2005 | » Details

» Best ComboBox

ActiveX ComboBox control with extended features including auto-completing text, complete control of colors, ability to automatically add text, etc. ...

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

Date added: Sep 19, 2005 | » Details

» Pivo FTP Component

The Pivo FTP component is a fully featured, easy to use implementation of the FTP protocol for .NET, ASP.NET and COM based applications. Fully compliant with RFC 959 and related RFCs, the component has been thoroughly tested with all popular FTP servers. ...

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

Date added: Feb 12, 2007 | » Details

» ASP.NET ImageDraw

ImageDraw is a server control which generates real-time, on-the-fly images for ASP.NET Web Applications. ImageDraw allows you to use all the potential of GDI+ in your ASP.NET Web Applications. You can use ImageDraw to deliver real-time dynamically generat ...

Neodynamic | 1892 KB | Windows2000,WinXP,Windows2003 | 39 | Downloads: 715

Date added: Sep 19, 2005 | » Details

» EaseSoft Barcode .Net Control

EaseSoft Linear Barcode .Net Windows Forms Control is 100% managed C# code product which can add professional quality barcode image to your windows application .You can save the barcode as different image format files (BMP,EMF,GIF,JPEG,PNG,TIFF,WMF). It i ...

EaseSoft Inc. | 376 KB | WinME,Windows2000,WinXP,Windows CE | 399.00 | Downloads: 638

Date added: Sep 19, 2005 | » Details

» Word ActiveX Control

Word OCX is a powerful ActiveX Control with over one hundred useful functions to send data from Visual Basic to a Word document, spell check Visual Basic objects and database tables, create labels in Word, create HTML documents and much more using COM tec ...

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

Date added: Sep 19, 2005 | » Details

» FeedForDev

FeedForDev VCL Control and ActiveX components makes it simple to communicate with users from within your software application! Integrate components into your application, to communicate with users. Use standard RSS feeds and provide users. All you have to ...

NotePage, Inc. | 1435 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 39.95 | Downloads: 705

Date added: Feb 12, 2007 | » Details

» ASP.NET Barcode Professional

Barcode Professional can generate the most popular Linear and 2D Barcode Symbologies. At design-time Barcode Professional Designer shows the barcode image in the specified image format (GIF, JPEG/JPG, PNG, and BMP) to render and it works in most popular D ...

Neodynamic | 1171 KB | Windows2000,WinXP,Windows2003 | 199 | Downloads: 709

Date added: Sep 19, 2005 | » Details

» XShow

XShow v4.0 is an ActiveX control designed to create transition effects between images. The control offers choice of over 100 transition effects. The following image formats are supported: BMP, JPG, JPEG, GIF, PNG, EMF, WMF, DIB, PCD, PCX, PSD (single laye ...

| 757 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 30 | Downloads: 685

Date added: Sep 19, 2005 | » Details

» tssHookDisc

tssHookDisc is a ActiveX/COM component that provides notifications whenever it detects a disc insertion or removal into any CD/CDR/DVD drive. When a disc is inserted/removed, you will notified using two events. You also are told which drive is being utili ...

Teebo Software Solutions | 1106 KB | Windows | 24.95 | Downloads: 636

Date added: Sep 26, 2005 | » Details

» Windows Std Serial Comm Lib for Visual Basic

MarshallSoft Visual Basic serial communication library component (DLL) for serial port communications from VB or VB.NET programs. WSC4VB uses the standard Windows API to communicate with any device connected to a serial port. Includes 32 functions plus mo ...

MarshallSoft Computing | 394 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP | 105 | Downloads: 601

Date added: Sep 19, 2005 | » Details

» Aspose.Report

Aspose.Report is a .Net Report Component which allows developers to break down a report design process into different section so that business analysts, developers or DBA can work on different parts, for instance, a developer could use SQL editor to compo ...

Aspose Pty Ltd | 1946112 KB | WinXP,Windows2000,Windows2003 | 149 | Downloads: 643

Date added: Sep 19, 2005 | » Details

» UCCDraw ActiveX Control V3.0

UCCDraw ActiveX Control is an ActiveX control that allows creation and editing of Visio-style charts from within your application. Allows you to create flow charts, vector drawings, raster images and more with the ability to include hyperlinks and various ...

ucancode software | 5000 KB | Windows | 0 | Downloads: 673

Date added: Sep 26, 2005 | » Details

» Aspose.Mime

Aspose.Mime is a pure C#, fully managed, robust and reliable component, allowing you to parse email messages in your applications. Aspose.Mime allows you to absolutely avoid using of unmanaged code in your aplications, increase reliability and decrease co ...

Aspose Pty Ltd | 638 KB | WinXP,Windows2000,Windows2003 | 234 | Downloads: 712

Date added: Sep 19, 2005 | » Details

» DISLIN for Borland C++ 5.5

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 | 5137 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 0 | Downloads: 628

Date added: Sep 19, 2005 | » Details

» ANPOP POP3 Component Build

ANPOP is a high performance and easy-to-use POP3 component. It enables your ASP, VB, VC++, C#, VB.NET, ASP.NET, VBS, Jscript, WScript, Delphii or other COM environment application to retrieve email from email server using the POP3 protocol and parse email ...

Adminsystem Software Limited | 772 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 59.95 | Downloads: 706

Date added: Sep 19, 2005 | » Details

» Enhanced AniGif ActiveX control

An enhanced AniGif ActiveX control can display a graphic from animated or static Gif files and provides extended information about the animation. It can stretch the output to fit the control`s size or it can be Autosized to fit the graphic`s dimensions. S ...

Inspired Creations | 139 KB | Windows | 41.95 | Downloads: 675

Date added: Sep 26, 2005 | » Details

go to top

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