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

» Java Outlook Connector

The Java Outlook Connector (JOC) allows Java developers to access data stored in the Outlook application, like e-mails, contacts and appointments. For example, the library can be used to build synchronization tools, organize/export Outlook`s data or integ ...

Moyosoft | 1597 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 247 | Downloads: 1053

Date added: Feb 12, 2007 | » Details

» eRegistry Server

eRegistry Server is a COM component that provides advanced System Registry management functions. eRegistry Server provides Registry manipulation, scheduling and search services. The Server is completely self-contained and does not need any run-times for i ...

Lucigenic Inc. | 1200 KB | Windows | 99 | Downloads: 978

Date added: Sep 26, 2005 | » Details

» MegaPipe ActiveX

MegaPipe ActiveX is a reliable and powerful control for handling serial communication, modem operation and file-transfer (XModem Checksum, XModem CRC, XModem 1K, YModem, YModem-G, ZModem and Kermit). It can be used in any ActiveX-compliant environment lik ...

MW6 Technologies, Inc. | 954 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000,Windows CE | 699 | Downloads: 959

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

Date added: Feb 12, 2007 | » Details

» MSCUpload for Windows

MSCUpload is an Active Server File Upload component. It extentds standard Request object capabilities in handling uploaded data. MSCUpload is a perfect way for ASP applications to handle multiple uploaded files and still make another form fields easily ac ...

Miraplacid | 760 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 18.95 | Downloads: 998

Date added: Sep 19, 2005 | » Details

» Instrumentation ModelKit

Present-day business requires sharp decision-making based on information that is easy to conceive and that provides only valuable (necessary) data, filtering out information that isn`t relevant. Ideal solutions for such a task are digital dashboards, KPIs ...

Perpetuum Software | 32299 KB | Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 375 | Downloads: 950

Date added: Feb 12, 2007 | » Details

» Chilkat Zip ActiveX Compression Component

Affordable, advanced Zip ActiveX Component with many features: Open a Zip on the Web. Open and read or unzip the contents of a Zip file from a URL. Standard WinZip Password-Protection is Supported. Create or open/decrypt password-protected Zips. OpenFromM ...

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

Date added: Sep 19, 2005 | » Details

» DotNetRemotingPlusLib

Unlike standard .Net Remoting, DotNetRemoting SDK for .NET allows you to build Bidirectional network applications. Core Features : *Bidirectional synchronous and [or] asynchronous communication by sending the objects or executing methods on the server [or ...

Amplefile | 1133 KB | WinXP,Windows2000,Windows2003,Windows CE,Windows Mobile 2005,Pocket PC | 99 | Downloads: 779

Date added: Oct 25, 2007 | » Details

» Pivo DnsResolver Component

Dns Resolver is used to queries DNS servers for host information and programmatically query DNS servers for information, without having to worry about complex packet parsing. It easily returns information in a humanly readable form. It allows you to progr ...

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

Date added: Feb 12, 2007 | » Details

» Lucigenic TCP

Lucigenic TCP/IP is an advanced COM server implementation of the TCP/IP protocol. Lucigenic TCP/IP is a feature rich component that also provides implementations for the HTTP protocol, DNS resolver services and 442 bit secure sockets. Lucigenic TCP/IP is ...

Lucigenic Inc. | 1750 KB | Windows | 149 | Downloads: 987

Date added: Sep 26, 2005 | » Details

» PDF Maker

ActiveX DLL for Visual Basic to automatically create Adobe Acrobat PDF files from Excel worksheets and Word documents. ...

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

Date added: Sep 19, 2005 | » Details

» qs Barcode Code39 Reading

qs Barcode Code39 can read horizontal Code39 barcodes with 6 digits on monochrome images (windows bitmaps). qsBarcode Code39 is an easy-to-use DLL that can be from many different developer environments, such as C/C++, Java, VisualBasic or Delphi. ...

QS QualitySoft GmbH | 360 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP | 0.00 | Downloads: 1061

Date added: Sep 19, 2005 | » Details

» Chilkat ASP.NET Email 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: 945

Date added: Feb 12, 2007 | » Details

» Aspose.Component

Aspose.Component is a product suite including all individual products: Aspose.Excel, Aspose.Word, Aspose.Project, Aspose.Pdf, Aspose.Chart, Aspose.Spell, Aspose.Recurrence. If you need more than one product, you`re strongly recommended to consider a produ ...

Aspose Pty Ltd | 3000 KB | WinXP,Windows2000,Windows2003 | 648 | Downloads: 1005

Date added: Sep 19, 2005 | » Details

» BitmapCombo ActiveX Control

Key Features: 1. Ideal tool to pick picture from files, bitmaps, resources and any GDI handle. 2. A built-in visual picture file open/preview dialog. 3. Offers powerful items data management capabilities such as add, insert, delete, find, move, get/set in ...

NiceFeather Software Solutions Corp. | 2974 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 29.95 | Downloads: 884

Date added: Feb 12, 2007 | » Details

» Personal C Sharp

Personal C Sharp extremely simplifies C# programming. Allows a person with minimum programming experience to write professional programs in C# and the .NET Framework.Contains all the tools to compile and debug your programs, nothing else to buy. See a dem ...

Famsoft | 125 KB | Windows2000,WinXP,Windows2003 | 0 | Downloads: 198

Date added: Feb 12, 2007 | » Details

» Bind to EXE library

Bind to EXE is an easy-to-use delphi library that enables your applications to bind/extract files to/from an executable file at RUNTIME. It consists of two classes, TBindToEXE and TExtractFromEXE, corresponding to two working stages, i.e. binding and extr ...

Code Office, Inc. | 1587 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 49.95 | Downloads: 1027

Date added: Sep 19, 2005 | » Details

» Advanced Query Builder

Advanced Query Builder is a powerful component suite for Borland Delphi and C++ Builder intended for visual building SQL statements for the SELECT, INSERT, UPDATE and DELETE clauses. It allows you to build new queries visually and/or graphically represent ...

EMS Database Management Solutions, Inc | 9779 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 195.00 | Downloads: 984

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

Date added: Feb 12, 2007 | » Details

» Instrumentation Widgets for PDA

In recent years, Pocket PC technology has been vigorously developed. These devices are palm-sized and often equal traditional desktop computers in their functionality. Keeping-up-to-date, Perpetuum Software LLC developed Instrumentation Widgets for PDA: a ...

Perpetuum Software | 918 KB | Windows CE | 266 | Downloads: 907

Date added: Feb 12, 2007 | » Details

go to top

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