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

» My Screen Capture

This control let you capture screen in 5 ways (Full screen, Active window, predefined region, manual region and specific window) and getting instant result in memory. Some options are availables to save the screen on disk and/or send it to clipboard. Easy ...

Namtuk | 442 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 49 | Downloads: 797

Date added: Sep 26, 2005 | » Details

» PDFDoc Scout

Library for royalty-free PDF generation in VB, C#,.NET, C++, ASP and ASP.NET - Full set of methods and properties to add and manage text, Unicode text, images, annotations, outlines, controls (for `acroforms`) and javascript actions; - Fonts embedding (TT ...

ByteScout | 2873 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 299 | Downloads: 861

Date added: Feb 12, 2007 | » Details

» EaseSoft PDF417 Barcode .NET Control

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

EaseSoft Inc. | 344 KB | Win98,WinME,Windows2000,WinXP,Windows CE | 399.00 | Downloads: 835

Date added: Sep 19, 2005 | » Details

» NCTAudioEditor ActiveX DLL

NCTAudioEditor ActiveX DLL is a visual audio files editor. It can be used to build applications, which allow the end-user to perform various operations with audio data such as displaying a waveform image of an audio file, filtering, applying various audio ...

NCT Company | 5297 KB | Windows | 499 | Downloads: 282

Date added: Sep 26, 2005 | » Details

» WebCab Optimization (J2SE Edition)

Refined procedures for solving and performing sensitivity analysis on uni and multi dimensional, local or global optimization problems which may or may not have linear constraints. Specialized Linear programming algorithms based on the Simplex Algorithm a ...

WebCab Components | 5428 KB | Windows2000,WinXP,Windows2003,Unix,Linux,Mac OS X | 199 | Downloads: 299

Date added: Sep 19, 2005 | » Details

» InterBase Data Access Components

InterBase Data Access Components (IBDAC) is a VCL/VCL .NET/CLX component library for fast direct access to InterBase, Firebird, and Yaffil servers from Delphi, C++Builder, and Kylix. IBDAC is heavily performance- and stress-tested to provide the fastest a ...

Core Lab Software Development | 3913 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000,Windows2003,Windows Media Center Edition 2005,Windows Vista Starter,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise,Windows Vista Ultimate,Windows | 99.95 | Downloads: 1248

Date added: Oct 25, 2007 | » Details

» SFTPBlackbox (.NET)

SFTPBlackbox .NET Edition is a comprehensive collection of managed components that add add client-side and server-side support for SFTP (Secure File Transfer Protocol) to your .NET Framework applications. SFTPBlackbox.NET includes complete SSH protocol su ...

EldoS Corporation | 7483 KB | Win98,WinME,WinXP,Windows2000,Windows2003 | 199 | Downloads: 860

Date added: Sep 26, 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: 754

Date added: Feb 12, 2007 | » 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: 835

Date added: Sep 26, 2005 | » Details

» Managed extensions for VCL

Managed extensions for VCL is the best components suite for .Net interop for Delphi and C++ Builder. Managed VCL can: * Create .Net objects from assemblies not registered for COM, using assembly name or location, and loading .Net assemblies from streams; ...

Viatcheslav V. Vassiliev | 3213 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 250 | Downloads: 754

Date added: Sep 19, 2005 | » Details

» Packet Sniffer SDK for Windows

Packet Sniffer SDK is a library set for packet capture and network analysis for all Win32 platforms. The main features of the Packet Sniffer SDK library are: Any pre-installed packet drivers are not required; Support of 1GBit networks; Support of all mode ...

microOLAP Technologies LTD | 3084 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 499.95 | Downloads: 833

Date added: Feb 12, 2007 | » Details

» MyNeoReport .Net Reporting Tool

MyNeoReport is a little reporting engine and designer for .Net applications, for programmers which want a tool to make reports that is really simple and doesn`t cost hundreds of dollars. Features: - Support for all OLEDB providers - Support both Data-Push ...

NeoDataType | 176 KB | Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 0 | Downloads: 855

Date added: Feb 12, 2007 | » Details

» EMS Excel Report

EMS Excel Report component for Delphi and C++ Builder is a powerful band-oriented generator of template-based reports in MS Excel. Easy-to-use component property editors allow you to create powerful reports in MS Excel quickly, easily and intuitively unde ...

EMS Software Development | 6615 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 65.00 | Downloads: 817

Date added: Sep 19, 2005 | » Details

» XD++MFC Library Professional Edition 8.0

XD++ MFC Library Professional 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 | 0 | Downloads: 772

Date added: Sep 19, 2005 | » Details

» .NET Communication Library

Microsoft’s .NET Framework class library doesn’t support certain common communication protocols, for example, the NNTP and POP3 protocols. Although still in its infancy, Smilla’s .NET Communication Library is attempting to fill the gap. By using Smi ...

Component Spot | 800 KB | Win 3.1x,Win95,Win98,WinME,WinXP,WinNT 3.x,WinNT 4.x,Windows2000,Windows2003 | 0.00 | Downloads: 1052

Date added: Sep 19, 2005 | » Details

» Folder Size COM Component

The com component will quickly tell you how much disk space a folder is taking up, this also includes subfolders under the root folder, ideal for web sites that serve document/image content. Example .asp code included simple ASP example of usage:- Set Obj ...

Traction Software | 933 KB | Windows | 49.95 | Downloads: 818

Date added: Sep 26, 2005 | » Details

» Manage Registry ActiveX Control

Manage Registry ActiveX Control is an ActiveX registry control that gives developers easy and complete access to the power of registry programming. Whenever the program developer considers to store own application`s settings and options, he turns his atte ...

ELTIMA Software GmbH | 1208 KB | Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 79.95 | Downloads: 766

Date added: Feb 12, 2007 | » Details

» StarBurn SDK

Rocket Division Software`s StarBurn SDK (Software Development Kit) is world most advanced CD/DVD Burning, Grabbing and Mastering Toolkit. Features are: All MMC compatible CD/DVD recorders (CD-R/W, DVD-R/W, DVD+R/W and DVD-RAM) are supported UDF file syste ...

RocketDivision.Com | 2275 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 2000 | Downloads: 790

Date added: Sep 19, 2005 | » Details

» PGPBlackbox (.NET)

PGPBlackbox .NET Edition is a comprehensive collection of managed components that add PGP support to your .NET Framework applications. PGPBlackbox supports full range of PGP operations, including * File encryption, signing, compression * PGP key generatio ...

EldoS Corporation | 7483 KB | Win98,WinME,WinXP,Windows2000,Windows2003 | 159 | Downloads: 828

Date added: Feb 12, 2007 | » Details

» CSMail Developer Edition

A suite of ActiveX/COM objects providing SMTP, POP3 and MIME support for application developers. The library is suitable for use in Visual Basic, C++, Delphi and scripting languages such as ASP, VBScript/JScript and VBA. The library has built in support f ...

Codestone Ltd | 1953 KB | Windows | 79.95 | Downloads: 872

Date added: Sep 26, 2005 | » Details

go to top

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