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

» AppFace User Interface Development Kits

Want to improve your application user interface ? Need a skinnable library to create a skinnable application? AUDK is the best application skinnable solution for you! AUDK means AppFace User Interface Development Kits ,which is a WYSWYG windows software U ...

MatinSoft | 2172 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 29 | Downloads: 870

Date added: Sep 19, 2005 | » Details

» SMTP POP3 DLL

Sending Features -Send simple Text or HTML Emails using SMTP Protocol. -Supports AUTHLOGIN, plain text and POP authorisation. -Send no/single or multiple Attachments. -Send Bulk Emails or single emails at a time. Receiving Features -Receive Single Emails. ...

vb4all.net | 1724 KB | Win98,WinME,Windows2000,WinXP,Windows2003 | 39.95 | Downloads: 807

Date added: Feb 12, 2007 | » Details

» Win/CE Std Serial Comm Lib for eVB

The Windows/CE Standard Serial Communications Library for eVB (WSC4eVB) is a serial port communication library for Embedded Visual Basic (eVB) programs for the Pocket PC (PPC) and the Handheld PC (HPC). WSC4eVB includes 33 serial port functions plus XMODE ...

MarshallSoft Computing | 320 KB | Windows CE | 105 | Downloads: 1263

Date added: Sep 26, 2005 | » Details

» Vivid Report Free for C++ Builder 6

Vivid Report is a library of visual components for C++ Builder and Delphi, which provides creating printable reports of almost any complexity. Vivid Report provides perfect guaranteed printing quality and excellent productivity of designing. Version 2.0 i ...

MBLabSoft | 1995 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP | 0 | Downloads: 756

Date added: Oct 25, 2007 | » Details

» ELMathSolver .NET DLL

ELMathSolver is pure .NET library (DLL) that allows to parse string as a mathematical formula and draws chart. Library is very simple and elegance in using. You can use it in your projects written in C#, VB.NET or ASP.NET. ...

ELSoft | 397 KB | Windows2000,WinXP,Windows2003 | 0 | Downloads: 799

Date added: Feb 12, 2007 | » Details

» EACompression Zip Component for .Net

High performance zip component for your ASP.NET, Visual Basic.NET, C#, Managed C++, J# and JScript.NET applications to compress and decompress file. Many advanced features are supported like encryption, streaming and uuencoded file. Easy-to-use and featur ...

Adminsystem Software Limited | 255 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 | 59.95 | Downloads: 763

Date added: Oct 25, 2007 | » Details

» NCTDialogicVoice ActiveX DLL

NCTDialogicVoice ActiveX DLLs is a rapid application development for Dialogic voice boards. With help of NCTDialogicVoice ActiveX DLLs, you can create a variety of CTI applications including Interactive Voice Response (IVR), Voice Mail, Order Entry System ...

NCT Company | 7580 KB | Windows | 399 | Downloads: 217

Date added: Sep 26, 2005 | » Details

» CryptoText

CryptoText is a COM encryption component written in ATL3.0 for Windows 9x, NT4.0 and Windows 2000/XP. It provides simple access to the CryptoAPI in Windows from Visual Basic, Visual C++ and scripting languages (eg ASP). As well as being a standalone produ ...

TMG Development Ltd | 46 KB | Windows | | Downloads: 876

Date added: Sep 26, 2005 | » Details

» BKTraceRoute

The BKTraceRoute v3.0 .NET class collection contains TraceRoute and associated utility classes for tracing the route to one or more remote hosts either synchronously or asynchronously. The current version includes: 1. Both synchronous (blocking) and async ...

Bill Koukoutsis | 604 KB | Win98,WinME,WinXP,Windows2000 | 25.00 | Downloads: 825

Date added: Sep 19, 2005 | » Details

» WebCab Optimization for Delphi

Add refined procedures for solving and performing sensitivity analysis on uni and multi dimensional, local or global optimization problems which may or may not have constraints; to your .NET and COM Applications. Specialized Simplex Linear programming alg ...

WebCab Components | 2770 KB | Win98,Windows2000,WinXP,Windows2003,Mac OS X | 179 | Downloads: 189

Date added: Sep 19, 2005 | » Details

» Delphi Toys

Delphi Toys is WinAPI and low-level VCL components that allow you to access complex things with unusual ease. Current version of Delphi Toys contains: Hot Keys - system wide hot keys component System Mouse - mouse cursors, clipping and moving component Fi ...

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

Date added: Feb 12, 2007 | » Details

» EaseSoft DataMatrix ASP.NET Web Control

EaseSoft DataMatrix Barcode ASP.NET Web ServerControls use its internal HttpHandler to transfer barcode images directly to the client without any temporary files.It is the most efficient method to generate the barcodes dynamically.EaseSoft DataMatrix ASP ...

EaseSoft Inc. | 365 KB | Win98,WinME,Windows2000,WinXP,Windows2003,Windows CE | 499.00 | Downloads: 798

Date added: Sep 26, 2005 | » Details

» FileMenu

FileMenu is a java component. It provides the general functionality of a FileMenu that appears in almost every application. Instead of writing the code for the File menu every time, developers can use this component to get the entire functionality for jus ...

MakeLogic | 1714 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000,Windows CE,Unix,Linux,MS-DOS,AS/400,OS/2,OS/2 Warp,OS/2 Warp 4,MAC 68k,Mac PPC | 30 | Downloads: 898

Date added: Sep 19, 2005 | » Details

» PixTwix

PixTwix is an image processing ActiveX control featuring advanced selection routines, including irregular and non-contiguous selection regions, local and global magic wand functions, unlimited file based undo capabilities, loss-less and lossy rotation rou ...

Softuarium | 950 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 65 | Downloads: 807

Date added: Sep 19, 2005 | » Details

» Alvas.CDBurn

Alvas.CDBurn for .Net is a collection of 100% native CLR compliant controls written in C#. Collection allows C# and VB.Net developers to create applications that record files to the writable CD (CD-R and CD-RW). Easy to use. Package contains: CDBurner is ...

Alvas.Net | 170 KB | WinXP,Windows2000,Windows2003 | 49 | Downloads: 883

Date added: Feb 12, 2007 | » Details

» DataMatrix 2D Barcode ASP Component

Our small footprint DataMatrix ASP component is an ATL COM product which can add professional quality 2D barcode PNG format image to your web pages running on the IIS server. ...

MW6 Technologies, Inc. | 29 KB | Windows2000,WinXP | 299 | Downloads: 822

Date added: Sep 19, 2005 | » Details

» SMTP/POP3 Email Engine for Delphi

MarshallSoft SMTP/POP3 email component Delphi library (SEE4D) uses a simple API to send and receive mail, including HTML, MIME Base64 and quoted-printable encoded attachments, from within an application. Knowledge of Winsock and TCP/IP is not needed. Feat ...

MarshallSoft Computing | 413 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 105 | Downloads: 976

Date added: Feb 12, 2007 | » Details

» BKAudio

The BKAudio v2.0 class library allows you to visually add sounds to your .NET applications! The current version includes: 1. Fully commented class libraries developed in 100% CLS compliant C# code. 2. Thorough documentation in .CHM (Compiled HTML Help Fil ...

Bill Koukoutsis | 1065 KB | Win98,WinME,WinXP,Windows2000 | 32.00 | Downloads: 881

Date added: Sep 19, 2005 | » Details

» pdProgress

pdSoftware`s pdProgress progressbar control is a great replacement for the regular Windows progressbar control, featuring a stylish design with various colours in a tiny component. The control is very easy to use and gives your programs a more professiona ...

pdSoftware.biz | 63 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000,Windows2003 | 0.00 | Downloads: 815

Date added: Sep 19, 2005 | » Details

» Aspose.Network

Aspose.Network is a suit of flexible and .NET network programming components which includes not only the implementations of most of the major network protocols but also lots of utility classes to facilitate the common development tasks. Complement of Syst ...

Aspose Pty Ltd | 879 KB | WinXP,Windows2000,Windows2003 | 199 | Downloads: 809

Date added: Feb 12, 2007 | » Details

go to top

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