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

» Polar Crypto Component

Polar Crypto Component gives your Windows applications the functionality of unbreakable encryption. It enables you to build your own security systems instantly, or to easily integrate it into your existing systems, enhancing their security and performance ...

Polar | 25030 KB | Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000,Windows2003 | 239 | Downloads: 950

Date added: Oct 25, 2007 | » Details

» BKResizer

BKResizer gives your .NET Windows applications and controls resolution independence. BKResizer changes the size, location, and font size, scales the background and foreground images of controls as they are resized, without requiring you to write ANY code. ...

Bill Koukoutsis | 1915 KB | Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 95.85 | Downloads: 1075

Date added: Sep 19, 2005 | » Details

» ! Chilkat SMTP / POP3 Components

A POP3 / SMTP ActiveX mail 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, ...

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

Date added: Sep 26, 2005 | » Details

» Aspose.Project

Aspose.Project is a .Net Project document reporting component. With it, you can: Read, change and save existing and create new Microsoft Project documents which support tasks and dependent tasks, resources assignment, all standard properties of tasks and ...

Aspose Pty Ltd | 964 KB | WinXP,Windows2000,Windows2003 | 216 | Downloads: 988

Date added: Sep 19, 2005 | » Details

» EaseSoft PDF417 Barcode .NET Control

EaseSoft PDF417 .Net Windows Forms Control is 100% managed C# code product which can add professional quality 2D barcode image to your windows application .You can save the barcode as different image format files (BMP,EMF,GIF,JPEG,PNG,TIFF,WMF). It is eas ...

EaseSoft Inc. | 344 KB | Win98,WinME,Windows2000,WinXP,Windows CE | 399.00 | Downloads: 954

Date added: Sep 19, 2005 | » Details

» OLAP ModelKit

OLAP ModelKit is the first OLAP component for .NET completely written in managed code. This component has an XP Themed appearance and an ability to use any .NET data sources (including ADO.NET and IList). The flexibility of the product is additionally ext ...

9Rays.Net | 2253 KB | Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 300 | Downloads: 973

Date added: Sep 19, 2005 | » Details

» ASP.NET Barcode Professional

Barcode Professional can generate the most popular Linear and 2D Barcode Symbologies. At design-time Barcode Professional Designer shows the barcode image in the specified image format (GIF, JPEG/JPG, PNG, and BMP) to render and it works in most popular D ...

Neodynamic | 1171 KB | Windows2000,WinXP,Windows2003 | 199 | Downloads: 1009

Date added: Sep 19, 2005 | » Details

» Registry Pro

Registry Pro is an activeX control that gives developers easy and complete access to the power of registry programming. Works with VB, VBA and all other ActiveX and COM DLL supporting languages. Includes a detailed help file, comprehensive example program ...

Evans Programming | 1765 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 49.95 | Downloads: 814

Date added: Sep 19, 2005 | » Details

» 3DChart

The 3DChart component is a powerful charting tool using the OpenGL 3D engine to display 2D and 3D business, scientific and presentation charts. It supports all basic charting types with lots of different style and logic variations. All chart type combinat ...

Nevron LLC | 29024 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 399 | Downloads: 1068

Date added: Sep 19, 2005 | » Details

» Aspose.ASPXpand

Aspose.ASPXpand is a ASP.Net component that provides a set of DHTML functions to make development easier. Aspose.ASPXpand gives you a chance to bring to ASP.Net what you had in desktop development! Microsoft did a wonderful job of marrying web development ...

Aspose Pty Ltd | 1216 KB | WinXP,Windows2000,Windows2003 | 108 | Downloads: 1020

Date added: Sep 19, 2005 | » Details

» PlotLab VC++

PlotLab is a set of Visual C++ components for very easy and fast Data Visualization. The library includes: Scope - scientific chart component for plotting multi-channel data. Waterfall - l data plotting component, especially suitable for FFT results. The ...

Mitov Software | 9091 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 190 | Downloads: 961

Date added: Feb 12, 2007 | » Details

» qs Barcode Code39 Reading

qs Barcode Code39 can read horizontal Code39 barcodes with 6 digits on monochrome images (windows bitmaps). qsBarcode Code39 is an easy-to-use DLL that can be from many different developer environments, such as C/C++, Java, VisualBasic or Delphi. ...

QS QualitySoft GmbH | 360 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP | 0.00 | Downloads: 1048

Date added: Sep 19, 2005 | » Details

» Hide My Folders ActiveX

Hide My Folders ActiveX is a robust ActiveX Control that lets developers hide any file or folder in Windows system. You don`t need to dive into hazy world of low-level file access functions. Once files or folders are hidden they cannot be accessed, search ...

ELTIMA Software GmbH | 1354 KB | WinXP,Windows2000,Windows2003 | 199.95 | Downloads: 889

Date added: Sep 19, 2005 | » Details

» Virtual Serial Port Driver XP4

Virtual Serial Port Driver XP4 creates two pure virtual serial ports in your system which are virtually connected to each other. For other Windows applications, virtual ports will be seen exactly as two real serial ports connected via null-modem cable. Yo ...

ELTIMA Software GmbH | 1505 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000 | 111.95 | Downloads: 907

Date added: Sep 19, 2005 | » Details

» ELPhotoX ActiveX DLL

ELPhotoX is ActiveX DLL which encapsulates most important image processing routines. With ELPhotoX library you can load and save image files, convert image files into different image formats, apply various adjustments, photographic effects and filters to ...

ELSoft Group | 0 KB | Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 84 | Downloads: 1025

Date added: Sep 19, 2005 | » Details

» ScroogeXHTML for the Java(tm) platform

ScroogeXHTML for the Javai(tm) platform is a JavaBean(tm) which can convert RTF stored in files or strings to XHTML. It is fast, easy to customize and use and comes with full source code. It converts text attributes including background and highlight colo ...

Betasoft | 150 KB | Windows | 49 | Downloads: 949

Date added: Sep 26, 2005 | » Details

» .NET Web Components

A package of three Web components: a Shopping Cart, a Chat, and a Forum specially created for web developers. The products are based on the cutting-edge Microsoft. NET technology and provide better performance than their ASP analogues. The components are ...

SoftAura, Inc. | 1290 KB | Windows | 99.95 | Downloads: 1151

Date added: Sep 26, 2005 | » Details

» X360 Multiple Video Player ActiveX OCX

X360 Multiple Video Player ActiveX Control helps application developers to control multiple video files playback simultaneously. It helps programmer to create up to 10 video files playback at the same time. Each layer plays a video and supports several pr ...

X360 Software | 907 KB | Win98,WinME,Windows2000,WinXP | 139.90 | Downloads: 819

Date added: Feb 12, 2007 | » Details

» SocketTools Secure Library Edition

The SocketTools Secure Library Edition includes standard Windows dynamic link libraries (DLLs) which can be used in a wide variety of programming languages such as Visual Studio.NET, Visual C++, Visual Basic and Delphi. The SocketTools Library Edition API ...

Catalyst Development Corporation | 10422 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 695.00 | Downloads: 962

Date added: Sep 19, 2005 | » Details

» nBit Easy FTP DLL

An FTP Component as an ActiveX DLL for software developers. Manage remote files from your applications with ease. Integrates easily into any development environment that support ActiveX DLLs. Upload files, Download files, delete files , create and remove ...

nBit Information Technologies | 2176 KB | Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 39.95 | Downloads: 927

Date added: Sep 19, 2005 | » Details

go to top

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