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

» TGetDiskSerial Component

The TGetDiskSerial is a VCL component. You can use it to read the serial number of hard disk easily. As we all know, this serial number is unique in the world. So this component is of great use, for example, you can use this serial number to creat an encr ...

Devlib,Inc. | 972 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 19.95 | Downloads: 710

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

Date added: Sep 19, 2005 | » Details

» EASendMail SMTP Component (.NET Edition)

EASendMail enables your C#, VB.NET, JScript.NET, ASP.NET or other .NET framework applications to send Text/Html email based on SMTP/ESMTP protocol. It is a full-featured component which supports all operations of the SMTP/ESMTP protocol and provides many ...

Adminsystem Software Limited | 465 KB | WinXP,Windows2000 | 79.95 | Downloads: 726

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

Date added: Sep 26, 2005 | » Details

» PDF-Writer.NET

PDF-Writer.NET component is designed to provide developers with an easy-to-use tool for creating standard PDF file from ASP.NET and WinForm applications. PDF-Writer.NET hides the complex structure of PDF files behind a simple object model that allows crea ...

dbAutoTrack Ltd. | 1793 KB | Win98,WinME,Windows2000,WinXP,Windows2003 | 89 | Downloads: 718

Date added: Sep 19, 2005 | » Details

» LinesHelper

Faxed documents often contain annoying horizontal lines due to communication noise on the telephone line. Scanned document in some cases, also have horizontal or vertical lines due to the banding or folding of papers.By utilizing LinesHelper these lines c ...

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

Date added: Feb 12, 2007 | » Details

» Client/Server Comm Lib for Delphi

Client/Server Delphi comm component library for TCP/IP winsock communication across a network such as the Internet or a private network (intranet or LAN [local area net]). CSC4D uses the standard Windows API to communicate with other programs across any T ...

MarshallSoft Computing | 261 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP | 105 | Downloads: 1146

Date added: Feb 12, 2007 | » Details

» SMTP/POP3 Email Engine for FoxPro

MarshallSoft SMTP/POP3 email component Visual FoxPro library (SEE4FP) 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 need ...

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

Date added: Feb 12, 2007 | » Details

» FingerCell PC EDK for Windows

FingerCell 1.2 Embedded Development Kit for PC with MS Windows. This EDK is intended for developers, who are going to create an embedded biometric system with a server on PC with MS Windows. EDK contains these components: + FingerCell DLL (one license); + ...

Neurotechnologija | 2691 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 399 | Downloads: 713

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

Date added: Feb 12, 2007 | » Details

» DF_ECR

DF_ECR e` un Active X scritto al 100% in Visual Basic 6.0 SP5 che consente di interfacciare i tuoi programmi con i registratori di cassa più diffusi! Usando questo controllo, lo sviluppatore puo` dimenticarsi dei protocolli di ogni registratore di cassa, ...

Info2000 | 3868 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 200 | Downloads: 765

Date added: Sep 19, 2005 | » Details

» CommandBar Development Kit

CommandBar Development Kit is an extensible framework/component for Win32 platforms that provide comprehensive solution for your modern user interface needs. CommandBars provides complete run-time customization that you can use to extend its functionality ...

Slugen Corporation | 633 KB | Windows | 143 | Downloads: 812

Date added: Sep 26, 2005 | » Details

» Teroid Data Graph

Teroid Data Graph is a .NET Windows Forms control which draws a graph from any suitable ADO .NET data source. It can draw a column, line or bar graph, the data source can be a connection string, Connection object, a DataSet object, a DataTable object or a ...

Teroid Software Limited | 131 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | | Downloads: 655

Date added: Feb 12, 2007 | » Details

» Form Designer .NET

Greatis Form Designer .NET - Runtime Form Designer. Greatis Form Designer allows you move and resize any control on your form. You don`t need to prepare your form to use Form Designer. Just drop the component onto any form, assign the DesignedForm propert ...

Greatis Software | 291 KB | | | Downloads: 748

Date added: Sep 19, 2005 | » Details

» NCache

NCache is a clustered object cache for .NET that also includes a Clustered ASP.NET Session State. This Clustered Session State is much faster than the standard ASP.NET Session State and handles server-farm configuration much better. It has a better perfor ...

AlachiSoft | 15055 KB | WinXP,Windows2000,Windows2003 | 995 | Downloads: 1419

Date added: Feb 12, 2007 | » Details

» JamDTA Komponente fuer Delphi

TJamDTA is a component for Delphi and C++ Builder that allows you to build DTA / DTAUS files that contain standardized information about money tranfers (wire transfers) between German banks. ...

JAM Software | 747 KB | Win98,WinME,WinXP,Windows2000,Windows2003 | 59.95 | Downloads: 752

Date added: Feb 12, 2007 | » Details

» Aztec Font

MW6 Aztec Fontware makes Aztec barcode creation extremely easy for your Windows application, your appication can print Aztec barcode using font. Win32 DLL encoder and .Net Class Library encoder are available. To help you to seamlessly integrate Aztec Font ...

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

Date added: Sep 19, 2005 | » Details

» Virtual Serial Ports Driver XP

Virtual Serial Ports Driver XP is an advanced configuration utility, which purpose is to emulate RS232 serial ports connected via virtual null-modem cable using Virtual Serial Ports Driver, which can be easily included in your own software providing simpl ...

ELTIMA Software GmbH | 1684 KB | Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 99.95 | Downloads: 733

Date added: Sep 19, 2005 | » Details

» Intellexer Spellchecker SDK

Add spell checker capabilities to your Windows projects! With EffectiveSoft Spellchecker SDK this is easy. The development library contains a common DLL interface and interfaces for C++ and .NET with corresponding documentation and examples (C++, C#, Delp ...

EffectiveSoft | 2283 KB | Win95,Win98,WinME,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 Prem | 70 | Downloads: 763

Date added: Feb 12, 2007 | » Details

» BytesRoad.NetSuit Library

If you are looking for a free network library for the .NET platform then you may wish to look at BytesRoad.NetSuit library. This is an open source network library completely written in C#. You may find it useful if you would like to insert support for com ...

BytesRoad Software | 622 KB | Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 0 | Downloads: 769

Date added: Feb 12, 2007 | » Details

go to top

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