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

» tssNetResolve

tssNetResolve is an ActiveX / COM component that makes converting between IP addresses and host names easy. With a single method call, you can convert both to and from either format. No winsock control or messy socket APIs required! The download comes wit ...

Teebo Software Solutions | 14 KB | Windows | 0 | Downloads: 863

Date added: Sep 26, 2005 | » Details

» ASP Painter .NET

ASPPainter .NET can be used to create new and edit existing images. It has a large number of painting functions to draw lines, bars, rectangles, polygons, ellipses, arcs, pie charts, to draw text and fill images. You can load and save images from/to files ...

ASPPainter.Com | 1363 KB | WinXP,Windows2000 | 34.90 | Downloads: 1007

Date added: Sep 19, 2005 | » Details

» Aspose.PDF.Kit

Aspos.Pdf.Kit is a .Net Pdf document manipulating component which allows developers to Edit the existing pdf documents, such as appending and inserting pages, concatenating two pdf documents, splitting one file into two sub-files; Show and change the meta ...

Aspose Pty Ltd | 2272 KB | WinXP,Windows2000,Windows2003 | 399 | Downloads: 854

Date added: Sep 19, 2005 | » 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: 223

Date added: Sep 26, 2005 | » Details

» PBEmail 2006 ActiveX Edition

Award-winning PBEmail™ 2006 ActiveX Edition is an Email Component ActiveX DLL. It can send emails without any SMTP server configuration by the user. PBEmail detects the recipient`s SMTP server and sends each email directly, bypassing any SMTP server!: N ...

Perfection Bytes Inc. | 4915 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 199 | Downloads: 775

Date added: Feb 12, 2007 | » Details

» ContourCube ActiveX

ContourCube is a high-performance OLAP component for interactive reporting and data analysis. It offers embeddable OLAP technology for all Windows and web applications based on relational data. Application powered with ContourCube allows users to create n ...

Contour Components | 9600 KB | Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 600 | Downloads: 930

Date added: Sep 19, 2005 | » Details

» Internet Walker

Component emulates the usage of Internet Explorer browser by the end user. By passing from one page to another, it is possible to imitate web-site usage and obtain information displayed in a web-browser window. For each page you can make screenshot, cut n ...

Avalio Inc | 1308 KB | WinXP,Windows2000 | 299 | Downloads: 827

Date added: Sep 26, 2005 | » 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: 884

Date added: Sep 19, 2005 | » Details

» Gagnon-Harper Chart

This .NET charting control offers a nearly infinite number of ways to analyze your data. You no longer have to place data sets side-by-side to compare them; the Gagnon-Harper Chart allows you to place unlimited data atop one another for immediate comparis ...

Cristal Technologies, Inc | 18658 KB | Windows2000,WinXP,Windows2003 | 529.00 | Downloads: 856

Date added: Sep 19, 2005 | » Details

» ADEX Schedule

ADEX Schedule is a COM component that encapsulates the functionality of TaskScheduler. It enables application developers of Microsoft technology to add, delete and manage tasks in the TaskScheduler. It has been developed using Microsoft ATL, providing use ...

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

Date added: Sep 19, 2005 | » Details

» PE Bundle

PEBundle is a utility that physically attaches win32 DLLs and other files to executables by one of two methods. The advanced bundling technique allows for some DLLs to be bound to the executable without ever writing the DLL back to the disk. The other, si ...

Collake Software | 239 KB | Win95, Win98 | 19 | Downloads: 852

Date added: Sep 19, 2005 | » Details

» EGI

EGI 4.0 is an advanced frame animation engine for games and multi-media applications. EGI uses an enhanced FLIC file format. The engine can be used with any program/environment that can call a DLL. EGI provides transparent animations (move an animation ov ...

ITB CompuPhase | 4127 KB | Windows | 170.00 | Downloads: 932

Date added: Sep 26, 2005 | » Details

» Windows API hooking SDK

Windows API hooking SDK helps you hooking Windows APIs or functions in other Dlls, and replace the API function or Dlls` function to your own function, That is to say, intercepts Win32 functions and re-writing target function to easily custom and extend e ...

James Chen | 238 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 198 | Downloads: 865

Date added: Sep 19, 2005 | » Details

» Chilkat Zip Compression .NET Class

Affordable, advanced Zip .NET Component with many features: Open a Zip on the Web. Open and read or unzip the contents of a Zip file from a URL. Standard WinZip Password-Protection is Supported. Create or open/decrypt password-protected Zips. OpenFromMemo ...

Chilkat Software, Inc. | 2000 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 149 | Downloads: 823

Date added: Sep 19, 2005 | » Details

» Topcoder AutoGen for Arena C++

TopCoder Arena is a famous online competition for programmers to demonstrate their talent in algorithm and programming. There are many talent people participated in it, and the competition time is not enough at all for most participators. You have to tran ...

BossEye Inc. | 128 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | | Downloads: 796

Date added: Feb 12, 2007 | » Details

» NeuroSolutions

This installation program includes evaluation versions of three products for neural network design and development: NeuroSolutions, NeuroSolutions for Excel and the Custom Solution Wizard. NeuroSolutions is a highly graphical neural network development to ...

NeuroDimension, Inc. | 33322 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 195 | Downloads: 869

Date added: Sep 19, 2005 | » Details

» ASP/Export2ExcelPack

ASP/Export2ExcelPack is a server side COM component that allows web developers to export from DAO or ADO recordsets into MS Excel, HTML Table, XML, TXT, CSV, SYLK and DIF. ...

Nonnoi Solutions | 458 KB | Windows2000,WinXP,Windows2003 | 35 | Downloads: 1562

Date added: Feb 12, 2007 | » Details

» DataMatrix 2D Barcode Win32 DLL

Our DataMatrix Win32 DLL can create device independent 2D barcode image for your applications, you can save the barcode as either BMP or WMF image file or copy barcode WMF image to clipboard. ...

MW6 Technologies, Inc. | 893 KB | Windows2000,WinXP | N/A | Downloads: 926

Date added: Sep 19, 2005 | » Details

» Balloon Tooltips .NET

Balloon Tooltips .NET is a powerful .NET component that allows you to create cool customized tooltips for your controls! Some advantages that Balloon Tooltips .NET has over conventional tooltips: multi-line text; balloon style interface; icons, sound, for ...

SkySof Software Inc. | 276 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 9.95 | Downloads: 875

Date added: Feb 12, 2007 | » Details

» ClearImage Barcode 1D Pro

Develop high performance, automatic bar code recognition applications to rapidly and accurately read bar codes from camera, scan or fax images (TIFF, JPG, color and grayscale). ClearImage 1D Barcode Pro offers outstanding performance, quickly recognizing ...

Inlite Research | 4500 KB | Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 325.00 | Downloads: 857

Date added: Sep 19, 2005 | » Details

go to top

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