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

» QRCode 2D Barcode .Net Control

MW6 QRCode .Net Control can create the professional 2D barcode image for your .Net applications, you can save the barcode as different image format files. It is easy to print barcode using the PrintDocument Control provided by the .Net Framework (See the ...

MW6 Technologies, Inc. | 976 KB | Windows2000,WinXP | 1299 | Downloads: 743

Date added: Sep 19, 2005 | » Details

» Windows Std Serial Comm Lib for Xbase++

MarshallSoft Xbase++ serial communication component library (DLL) for serial port communications. Uses the standard Windows API to communicate with any device connected to a serial port. Includes 32 functions plus modem control, ANSI emulation, ASCII/XMOD ...

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

Date added: Sep 19, 2005 | » Details

» Arclab Email Toolbox

Incorporate email send (SMTP/ESMTP) capability into your application or script. Arclab Email Toolbox is a COM-based component for use with Visual Basic, Visual C++, Access, Excel, ASP, VBscript and other COM compatible containers. It fully supports rich t ...

ARCLAB SOFTWARE TECHNOLOGIES | 142 KB | Windows2000,WinXP,Windows2003 | 49 | Downloads: 923

Date added: Sep 19, 2005 | » Details

» Image ActiveX - Image Viewer CP Pro

Convert PSD, BMP, GIF, JPG, PNG, ICO, TIF image files to true color PDF file. Convert multipage TIF to multipage true color PDF. Support Lightness, Brightness, Contrast, Diffuse, Emboss, FocalBW, Gamma, InvertColor, Monochrome, Noise, SharpenEdge adjustme ...

Viscom Software | 6084 KB | Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP | 100 | Downloads: 750

Date added: Feb 12, 2007 | » Details

» Control Panel Applet Generator

Create Control Panel applets without any programming. The Control Panel Applet Generator helps developers quickly create Control Panel Applets, without having to worry about the complicated programming. You create the configuration application that will b ...

Manitools Software | 1039 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 19.90 | Downloads: 800

Date added: Sep 19, 2005 | » 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: 765

Date added: Feb 12, 2007 | » Details

» PDF In-The-Box ActiveX

PDF In-The-Box is an ActiveX control for creating PDF files programmatically. It writes native PDF format with no intermediate file. No third-party software needed. No need to know anything about the PDF format structure. Your applications based on PDF In ...

Synactis | 1477 KB | Win95,Win98,WinNT 4.x,Windows2000,WinXP,Windows2003 | 195 | Downloads: 782

Date added: Feb 12, 2007 | » Details

» 2D / 3D CAD Import .NET

CAD Import .NET is an easy-to-use API for reading AutoCAD DWG and DXF in C#, VB.NET, J# and Delphi .NET applications. It is completely programmed in C# and supports the following entities: 3dFace Arc Attdef Block BlockRecord Circle Dimension Ellipse Hatch ...

CADSoftTools | 2702 KB | Win95,Win98,WinXP,WinNT 4.x,Windows2000,Windows2003,Pocket PC,Windows Mobile 2003 | 49 | Downloads: 1252

Date added: Feb 12, 2007 | » Details

» Timers OCX

The Timers control is a set of timers that expand on the timer control supplied with Visual Basic. The Timer control supplied with Visual Basic counts in milliseconds, up to about 65 seconds, this suite of timer controls allow over 32,000 hours to be time ...

April16 ActiveX Components | 3 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 2 | Downloads: 465

Date added: Sep 19, 2005 | » Details

» FreeReport 2.32

FreeReport is reporting tool component. It consists of report engine, designer and preview. Its capabilities comparable with in QuickReport 3, ReportBuilder 3.52. It written on 100% Object Pascal and can be installed in Delphi 2/3/4/5/6 and C++Builder 1/3 ...

FastReport Software | 908 KB | Windows | | Downloads: 823

Date added: Sep 26, 2005 | » Details

» FlashPlayerControl .NET

FlashPlayerControl is a .NET component that enhances Macromedia Flash Player ActiveX features. It does not use its own engine to display movies, but instead provides a wrapper around official swflash.ocx/flash.ocx code. It is thus possible to avoid certai ...

Softanics | 380 KB | Win95,Win98,WinME,WinXP,WinNT 3.x,WinNT 4.x,Windows2000,Windows2003 | 99 | Downloads: 776

Date added: Sep 19, 2005 | » Details

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

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

Date added: Oct 25, 2007 | » Details

» Context Menu Extension DLL

The Context Menu Extension DLL is a easiest way to add Windows Explorer context menu extension (like WinZip) into your own application. This menu will appear every time users click right mouse button over file(s) or folder(s) inside Windows Explorer windo ...

SoftMajor | 378 KB | Windows | 69 | Downloads: 769

Date added: Sep 26, 2005 | » Details

» Window Information

Window Information - Window Information Component Window Information (TWindowInformation component) allows you to find any window in the system and analyze it with VCL-friendly TWindow class which allow to access any window data with simple VCL-friendly p ...

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

Date added: Feb 12, 2007 | » Details

» Web Page SnapShot

The main purpose is to create a snapshot of a web page with URL. You can set image dimensions and save the image in BMP, Jpeg, GIF and PNG image formats. Also the component gets additional info about the page like Title, its text, links on the page, e-mai ...

Tonec Inc. | 1540 KB | WinXP,Windows2000 | 75.00 | Downloads: 823

Date added: Sep 19, 2005 | » Details

» Chilkat .NET Mail 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: 834

Date added: Sep 19, 2005 | » Details

» ZipForge

ZipForge is a fast ZIP delphi component. With this Zip component you can easily add archive functionality to your projects. ZipForge includes our new unique technology, a transaction system. This innovative solution gives you a fast and easy way of updati ...

ComponentAce LLC | 1669 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 45 | Downloads: 827

Date added: Sep 19, 2005 | » Details

» HIME: Huge Integer Math and Encryption

HIME stands for Huge Integer Math and Encryption library. It is a collection of functions for Windows programmers that allows to implement RSA public key encryption, AES (Rijndael) and ArcFour (RC4) secret key encryption and digital signatures using the S ...

DevOTechS | 513 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP | 32.00 | Downloads: 494

Date added: Sep 19, 2005 | » Details

» VideoCap Pro Video OCX ActiveX

Capture Video from capture card, tv tuner, dv cam, dvd player to AVI or WMV 9, WMV8 file format. Draw overlay bitmap on live video or save to video file. User define transparent color, alpha value. Draw overlay time stamp (18 different date formats) on li ...

Viscom Software | 48 KB | Windows2000 | 150 | Downloads: 775

Date added: Feb 12, 2007 | » Details

go to top

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