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

» Chilkat VB.NET Mail 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: 886

Date added: Sep 26, 2005 | » Details

» PDF ActiveX DLL

ActiveX DLL for Visual Basic, VBA, .NET, and ActiveX-compatible programming language to automatically create Adobe Acrobat PDF files from many different file types. ...

SkySof Software Inc. | 3000 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 99.95 | Downloads: 845

Date added: Sep 19, 2005 | » Details

» Luxena Informix Data Access Components

This component set provides interaction between VCL (Delphi/C++Builder) based applications and Informix database server. IDAC is based on the native Informix Client API. This ensures excellent performance and reliability. IDAC is very good BDE and ADO alt ...

Luxena Software Company | 1139 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 149 | Downloads: 816

Date added: Sep 19, 2005 | » Details

» Aurigma Image Uploader Dual

Image Uploader 4.0 Dual is a powerful uploading solution for your sites. It enables website developers to provide their users with a user-friendly uploading interface for multiple files. Now to upload, say, 10 files, the user doesn`t need to click 10 time ...

Aurigma Inc. | 5501 KB | 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 Premium x6 | 184 | Downloads: 823

Date added: Feb 12, 2007 | » Details

» Luxena dbExpress eXtension

dbExpress eXtension is a database-independent component set for Delphi, C++Builder and Kylix development IDEs. The set is a successor to Borland dbExpress components and is a great help to dbExpress developers. dbExpress eXtension is a unique BDE/ADO alte ...

Luxena Software Company | 607 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 99 | Downloads: 787

Date added: Sep 19, 2005 | » Details

» TX Text Control ActiveX Standard

TX Text Control ActiveX Standard is a word processing component that offers developers all the features expected in a high end word processing package in reusable component form: Supports RTF, HTML, ANSI, Unicode and many more; Tables, bullets, numbered l ...

The Imaging Source Europe GmbH | 6574 KB | Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 439.00 | Downloads: 827

Date added: Feb 12, 2007 | » Details

» NCTAudioConvert ActiveX EXE Server

NCTAudioConvert ActiveX EXE Server is a conversion tool which helps you to convert audio files of the following formats: Uncompressed WAV PCM, Compressed WAV (GSM, ADPCM, DSP and others), MP3 (including VBR), MP2, VOX (Dialogic ADPCM), RAW, WMA, G.721, G. ...

NCT Company | 3727 KB | Windows | 129 | Downloads: 202

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

Date added: Feb 12, 2007 | » Details

» Virtual Documents

Virtual Documents by Antioch Software is a document sharing and collaboration add-on that provides greater control over data sharing and is easy to use. The .NET plug-in quickly integrates into your existing business application for an instant boost in fu ...

Antioch Software | 4233 KB | Win98,Windows2000,WinXP,Windows2003,Windows Vista Home Basic,Windows Vista Business,Windows Vista Ultimate,Windows Vista Home Basic x64,Windows Vista Business x64,Windows Vista Ultimate x64 | 69.95 | Downloads: 840

Date added: Oct 25, 2007 | » Details

» Oxygen SMS7110 ActiveX Control

Oxygen SMS7110 ActiveX Control for Nokia 3***, 62**, 71** and 8*** series GSM phones allows you to send text and picture messages, read and write default SMS centre number. The control can be incorporated into any programming environment that supports Act ...

Oxygen Software | 624 KB | Windows | 199 | Downloads: 827

Date added: Sep 19, 2005 | » Details

» Sound Volume ActiveX Control

SoundVolume is tiny control sound volume ActiveX control that support control Master Volume, Wave, CD Audio, Line In, Microphone, Phone Line, PC Speaker, SW Synth volume. Control Sound Volume( Master Volume, Wave, CD Audio, LineIn, Microphone, Phone Line, ...

Viscom Software | 1180 KB | Windows | 40 | Downloads: 832

Date added: Sep 19, 2005 | » Details

» Catalyst File Transfer Control

The Catalyst File Transfer ActiveX control enables developers to easily integrate file transfer functionality within their applications. The control implements the standard protocols for sending and receiving files over the Internet and corporate intranet ...

Catalyst Development Corporation | 2408 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 295.00 | Downloads: 883

Date added: Sep 19, 2005 | » Details

» StringDB Wizard

StringDB Wizard is a multi-language localization tool, which generates our multi-language structure StringDB directly from MS Excel files. Once you have used StringDB in your application, `anyone` can change the languages and strings with our PC tool. Thi ...

SWBOX | 800 KB | Win 3.1x,Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003,Unix,Symbian | 149 | Downloads: 738

Date added: Feb 12, 2007 | » Details

» conaito VoIP SDK ActiveX

conaito VoIP SDK ActiveX for developers of VoIP audio applications and webpages, such as voice chat, conference, VoIP, providing real-time low latency multi-client audio streaming over UDP/IP networks. Includes efficient components for sound recording, pl ...

conaito Technologies | 4726 KB | Win98,WinME,Windows2000,WinXP,Windows2003,Windows Tablet PC Edition 2005,WinME,Windows Vista Starter,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise,Windows Vista Ultimate | 369 | Downloads: 744

Date added: Oct 25, 2007 | » Details

» ADEX Shares

ADEX Shares is a COM component that enables application developers of Microsoft technology to get the list of Shares and Files and their permissions. It has been developed using Microsoft ATL, providing users fast access to the file system. The ADEX Share ...

Vyapin Software Systems Private Ltd., | 893 KB | WinNT 4.x,WinXP,Windows2000 | 99 | Downloads: 952

Date added: Sep 19, 2005 | » Details

» Delphi SWF SDK

Contains pure Object Pascal library for creating Macromedia Shockwave Flash movies (SWF), without using of any external dynamic libraries. Released features: - visual objects creating (shape, button, text); - advanced objects (morphing shape, sprite); - a ...

FeatherySoft | 977 KB | Not Applicable | | Downloads: 893

Date added: Sep 19, 2005 | » Details

» Cub Editor for MS Access 97

Cub Editor is an MS Access Report formatting wizard that allows MS Access developers, or end-users to easily create or modify attractive report layouts based on existing tables or queries. Cub Editor looks and behaves like the MS Access report wizard, onl ...

Peter`s Software | 595 KB | Windows | 35.95 | Downloads: 819

Date added: Sep 26, 2005 | » Details

» Balmsoft Polyglot

Balmsoft Polyglot contains components for localization your Delphi application. It contains IDE extension for generation files with localizable items and components for applying files with localization. You can translate any localizable property in your a ...

Balmsoft | 960 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000 | 29.90 | Downloads: 839

Date added: Sep 19, 2005 | » Details

» Aspose.Pdf.Form

Aspose.Pdf.Form is a .Net Pdf document reporting component which allows developers to read all the fields of the pdf documents, including its name and value;fill the field through the specified field name; Flatten some specified field or all the fields of ...

Aspose Pty Ltd | 1946112 KB | WinXP,Windows2000,Windows2003 | 119 | Downloads: 897

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

Date added: Sep 19, 2005 | » Details

go to top

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