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

» AidAim ZipForge - Free!

Fast ZIP compression library-Delphi/C++ Builder.Special transaction system technology provides dataintegrity like a reliable database system.Performs regularly archive updates using transactions: allows canceling allmodifications at any time in case of fa ...

AidAim Software | 3435 KB | Windows | | Downloads: 799

Date added: Sep 26, 2005 | » Details

» Packet Sniffer SDK for Windows (for Microsoft VC compatible compilers)

Packet Sniffer SDK (PSSDK) is the most powerful component suite for network packet capture in Windows OS family environment. The main features of the Packet Sniffer SDK library are: No pre-installed packet drivers are required; Packet Sniffer SDK works fi ...

microOLAP Technologies | 514 KB | WinNT 4.x,WinXP,Windows2000 | 419,95 | Downloads: 797

Date added: Sep 19, 2005 | » Details

» MetaTree Component (for Delphi 5,6,7)

MetaProducts Corporation has released MetaTree Component version 1.4 for Delphi 5,6,7, a control to show hierarchical information as a graphs tree. A user can select the desired node using mouse. It looks like a flat projection of a tree on an elliptical ...

MetaProducts Corporation | 804 KB | Win95,Win98,WinME,WinXP,Windows2000 | 70 | Downloads: 723

Date added: Feb 12, 2007 | » Details

» Rebex Secure Mail for .NET

SMTP over SSL, IMAP over SSL, POP3 over SSL, S/MIME - all you need for sending, receiving and processing emails from .NET framework application along with mail signing, encrypting and signature verification. ...

Rebex | 2780 KB | Windows2000,WinXP,Windows2003,Windows Vista Starter,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise,Windows Vista Ultimate,Windows Vista Home Basic x64,Windows Vista Home Premium x64,Windows Vista Busine | 349 | Downloads: 949

Date added: Oct 25, 2007 | » Details

» Vector Graphics ActiveX

Vector Graphics ActiveX is a graphics component oriented for creating business and technology solutions. Based on COM technology it can be used by other applications to process graphic documents, analyze and visualize any kind of processes. Vector Graphic ...

Stas Semenov | 3984 KB | Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 0 | Downloads: 685

Date added: Sep 19, 2005 | » Details

» AL Platform

AL Platform provides an Add-In framework for rapid development of flexible solutions with a complex user interface. AL Platform introduces the concept of Abstract Desktop, and defines a new development methodology - Tool-Oriented Approach. ...

Agile-SYS | 1 KB | Windows2000,WinXP,Windows2003,Windows Vista Starter,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise,Windows Vista Ultimate | 0 | Downloads: 770

Date added: Feb 12, 2007 | » Details

» E-XD++MFC Library Enterprise V10.0

E-XD++ MFC Library Enterprise Edition is an MFC extension library that allows you to create the most advanced user interface in the world. It combines easy of use and very powerful feature set implemented by highly customizable collection of MFC extension ...

ucancode software | 19531 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP | 800 | Downloads: 718

Date added: Feb 12, 2007 | » Details

» ASP.NET Barcode Server Control

Easily add barcodes to ASP Dotnet web forms applications with this bar code control. Barcodes dynamically appear in the web browser as high quality JPEG images. Supports several barcode symbologies including Code 11, Code 93, Code 3 of 9, Code 128, UCC/EA ...

IDAutomation.com, Inc. | 69 KB | Windows | 199 | Downloads: 812

Date added: Sep 26, 2005 | » Details

» ELImageCompare

ELImageCompare ActiveX DLL - Powerful tool for comparing images. Intelligent algorithm allows to compare two images and returns one of the following results: images are different, similar or identical. The method of comparing of images is base on modern m ...

ELSoft | 1496 KB | Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 79 | Downloads: 729

Date added: Feb 12, 2007 | » Details

» Hex Editor ActiveX Control

The Hex Editor control allows the user to viewing and editing any sort of binary data and it has been designed to be used inside VC++, VB or Delphi applications and on web pages as wellFeatures: Multilevel undo/redo; Print; Insert/Over edit mode; Fast fin ...

ELRA-Kovatchev ET | 291 KB | Windows | 30 | Downloads: 772

Date added: Sep 26, 2005 | » Details

» PlusDock for .NET 2.0

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. | 4284 KB | Win95,Win98,WinME,WinXP,Windows2000 | 269 | Downloads: 796

Date added: Feb 12, 2007 | » Details

» ASP/UnixCrypt

ASP/UnixCrypt is a server side COM component that allows web developers to encrypt the password. It works exactly as crypt(key, salt) Unix command (one-way encryption algorithm). ...

Nonnoi Solutions | 234 KB | Windows2000,WinXP,Windows2003 | 15 | Downloads: 1247

Date added: Feb 12, 2007 | » Details

» Chilkat POP3 ActiveX Control

A POP3 / SMTP email ActiveX 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 ...

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

Date added: Sep 19, 2005 | » Details

» N-Tier Slam

VB6 based TCP/IP N-Tier application server library that supports VB6 based application servers and clients, database access, chat, sending SMTP E-mail, file transfer, and calling of sub procedures and functions at the server from a client application. Can ...

N-Tier Alchemy | 1276 KB | Windows | 49.95 | Downloads: 746

Date added: Sep 26, 2005 | » Details

» RakeHelper

Forms often contain preprinted elements as field rakes (or combs) or character rakes (or combs). Scanned document in some cases, also have horizontal or vertical lines due to the banding or folding of papers. Dealing with those artifacts is a challenging ...

Personal PC Helpers | 784 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003,Linux | 18 | Downloads: 722

Date added: Feb 12, 2007 | » Details

» Serail Port Monitor ActiveX

Serial Port Monitor ActiveX is a powerful, advanced and absolutely unique component that can be easily implemented into developers’ applications to monitor any serial port in a system. The product can be used for debugging applications that work with se ...

ELTIMA Software GmbH | 1454 KB | Win98,WinXP,Windows2000,Windows2003 | 299.95 | Downloads: 725

Date added: Feb 12, 2007 | » Details

» Encoder Wizard ActiveX

Encoder Wizard is a collection of two ActiveX (ocx) controls, Encoder Wizard and Decoder Wizard. These two controls allow you to fully support the Base64, Quoted- Printable, UUEncode, yEnc, MD5,HMAC MD5, URL, SHA-1, and Binary 2 Hex encoding methods. You ...

Seekford Solutions, inc | 5140 KB | Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 199 | Downloads: 770

Date added: Sep 19, 2005 | » Details

» Snotra Tech Oracle Data Components

Snotra Tech Oracle Data Components for .NET provide connected dataset for data-aware components like DataGrid, DataGridView and etc which is intented for Oracle database. Snotra Tech Oracle Data Components extend standard functions and features of ADO.NET ...

Snotra Tech | 9794 KB | WinNT 4.x,Windows2000,WinXP,Windows2003 | 80 | Downloads: 721

Date added: Feb 12, 2007 | » Details

» JEP

JEP is a Java library for parsing and evaluating mathematical expressions. With this package you can allow your users to enter an arbitrary formula as a string, and instantly evaluate it. JEP supports user defined variables, constants, and functions. A nu ...

Singular Systems | 1411 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003,Windows Vista Starter,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise,Windows Vista Ultimate,Windows Vista Home Basic x64,Windows Vista | 550 | Downloads: 799

Date added: Oct 25, 2007 | » Details

» Xceed Encryption Library

Xceed Encryption Library is an ActiveX component that allows Windows applications to encrypt and decrypt data using the latest industry standard strong encryption algorithms. It supports traditional secret-key encryption as well as public-key encryption, ...

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

Date added: Sep 26, 2005 | » Details

go to top

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