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

» BarCode .NET Control

BarCode .NET Control enables you to add barcode functionality to an application, developed in any .NET environment. Versions for NET 1.0 and 2.0 are available. The control is reliable and comprehensive, so it will benefit any developer, who wants his appl ...

RKD Software | 449 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows CE | 99.00 | Downloads: 961

Date added: Oct 25, 2007 | » Details

» Pivo InI Component

INI component reads and writes Windows style INI files. It provides a comprehensive set of functions making INI files a powerful way to store application settings. There are three common ways to store program information on the hard disk: in the Windows r ...

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

Date added: Feb 12, 2007 | » Details

» Barcode ActiveX Control

Barcode ActiveX Control. Add Barcode Printing to Access, VB, Web pages, C++, Excel etc. Simply insert the BarCode ActiveX Control into your application and specify a few properties in the properties window and your desired bar codes will be generated auto ...

VBC Software | 704 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 149 | Downloads: 953

Date added: Sep 19, 2005 | » Details

» SMTP OCX

The SMTP OCX is a an Advanced Active-X Control which integrates RAS and SMTP mail protocols into one easy to manage solution. The SMTP OCX allows you to send Email via any RFC compliant SMTP server which supports SMTP mail relaying. SMTP (Simple Mail Tran ...

vb4all.net | 1305 KB | Win98,WinME,Windows2000,WinXP,Unix | 19.95 | Downloads: 860

Date added: Feb 12, 2007 | » Details

» Aztec 2D Barcode ActiveX

Aztec ActiveX is a powerful ATL-based barcode control generating the Aztec 2D barcode and can be used in any ActiveX-compliant environment like Word, Access, Excel, VB.Net, C#.Net, Visual Basic, Visual C++, Visual FoxPro, Delphi and C++ Builder. ...

MW6 Technologies, Inc. | 963 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows CE | 199 | Downloads: 926

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

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

Date added: Sep 19, 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: 913

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

Date added: Feb 12, 2007 | » Details

» R9 MPEG2 SDK Encoder Plus Pack

Reactor9 MPEG-1/MPEG-2 SDK Encoder Plus Pack provides high quality framework for developing MPEG- 1/VCD/MPEG-2/SVCD/DVD video/audio encoder and multiplexer applications. 100% ISO standard compliant, very fast and easy to use. Library is available as stati ...

Maya Studio Ltd. | 1239 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Linux | 2250 | Downloads: 997

Date added: Feb 12, 2007 | » Details

» UploadEncrypt

Protect and unlock files on your web site with these easy to use .NET components. Includes web server license and comprehensive help file with sample code covering C#, Visual Basic and ASP.NET. ...

Imagio Technology Ltd. | 95 KB | Windows | 99 | Downloads: 912

Date added: Sep 26, 2005 | » Details

» DRAFTPRINT

DOS, DRAFT PRINT , VB COMPONENT ...

ACCURATE INFO SOLUTION | 5 KB | Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP | 3.5 | Downloads: 892

Date added: Sep 19, 2005 | » Details

» NeuroSolutions for MATLAB

The NeuroSolutions for MATLAB neural network toolbox is a valuable addition to MATLAB`s technical computing capabilities allowing users to leverage the power of NeuroSolutions (www.neurosolutions.com) inside MATLAB and Simulink. The toolbox features 15 ne ...

NeuroDimension, Inc. | 8853 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 795 | Downloads: 863

Date added: Sep 19, 2005 | » Details

» OCR Image to Ascii Utility

Convert your scanned images to text files or word documents with OCRTools; a FreeWare OCR (Optical Character Recognition) application that is completly FREE. OCRTools also offers a Royalty-Free developer toolkit that you may use to add OCR to your custom ...

File Innovations | 9765 KB | 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 Home Premium x64,Windows Vi | 39.00 | Downloads: 928

Date added: Feb 12, 2007 | » Details

» Absolute Color Picker ActiveX Control

Absolute Color Picker ActiveX Control is a component that includes two dialogs: color selection dialog and gradient filling dialog. The component is easy to use and implement in your projects. You will save time, money and get excellent results! Our compo ...

ELTIMA Software GmbH | 5355 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 29.95 | Downloads: 1015

Date added: Sep 19, 2005 | » Details

» Data-Reports.NET

Data-Report.NET is a reporting component designed for ASP.NET & WinForm .NET It is written in 100% managed C# and is 100% integrated with Visual Studio .NET IDE. We have designed Data-Reports.Net on strict guidelines of best reporting practices, Visua ...

dbAutoTrack Ltd. | 1857 KB | Win98,WinME,Windows2000,WinXP,Windows2003 | 385.66 | Downloads: 1014

Date added: Sep 19, 2005 | » Details

» Lock O`Clock

The main goal of this software is to protect your workstation with password which can be different from your system password. The standard password functionality is also implemented and you can use the both features. In addition, you can allow people to l ...

Igor Kovalevsky | 345 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | | Downloads: 868

Date added: Sep 26, 2005 | » Details

» Aspose.Cells for .NET

Aspose.Cells is of the .NET components offered by Aspose for spreadsheet reporting in a desktop or web server environment without using Microsoft Excel. Main features include; Conditional formatting and Pivot table creation by API. Opening Excel files to ...

Aspose Pty Ltd | 8898 KB | Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 599 | Downloads: 870

Date added: Feb 12, 2007 | » Details

» DISLIN for Portland Group pgf77/pgf90

DISLIN is a high-level library of subroutines and functions that display data graphically. It is intended to be a powerful and easy to use software package for programmers and scientists that does not require knowledge of hardware features. The software i ...

MPI fuer Sonnensystemforschung | 5300 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 150 | Downloads: 1240

Date added: Sep 19, 2005 | » Details

» Dragonfly Chart .Net

Dragonfly Chart .Net provides 2D/ 3D .Net Controls of pie chart, ring chart, bar chart, X-Y Chart and angle chart, which can be widely applied in many .Net applications such as Industrial Automation HMI applications, financial and insurance applications, ...

Dragonfly Automation Software | 6616 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 500 | Downloads: 928

Date added: Sep 19, 2005 | » Details

go to top

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