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

» Aztec 2D Barcode ASP Component

Our small footprint Aztec 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. | 27 KB | Windows2000,WinXP | 299 | Downloads: 1045

Date added: Sep 19, 2005 | » Details

» WebCab Functions for Delphi

Add refined numerical procedures to either construct a function of one or two variables from a set of points (i.e. interpolate), or solve an equation of one variable; to your .NET, COM, and XML Web service Applications. The interpolation procedures provid ...

WebCab Components | 2929 KB | Win98,Windows2000,WinXP,Windows2003,Mac OS X | 107 | Downloads: 274

Date added: Sep 19, 2005 | » Details

» VeriFinger Extended SDK

VeriFinger Extended SDK contains interfaces for some of the major fingerprint scanners and a set of COM/ActiveX components, created especially for rapid development of client/server application using functions from VeriFinger DLL or library, which ensure ...

Neurotechnologija Ltd. | 2536 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 999 | Downloads: 1023

Date added: Sep 19, 2005 | » Details

» My Command Button ActiveX

Add appealing visual styles to your applications in all Windows versions with this very quick and powerful button. All new default styles (Windows XP, Office 2003, Visual Studio 2005, 3D standard, Flat, Explorer) and themes are supported (blue, olive, sil ...

Namtuk | 456 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 59 | Downloads: 973

Date added: Sep 19, 2005 | » Details

» MegaChart

MegaChart is an ActiveX (COM) component that allows to dynamically create professional looking charts of all common types (2d & 3d bars, pies, lines, stacked bars etc.) with just a few lines of code on your favorite language. Chart images can be exported ...

MegaChart | 534 KB | Windows | 50 | Downloads: 1039

Date added: Sep 19, 2005 | » Details

» Macros

Macros - Help Desk Reply Automation and Macro Software. Macros allows you to store your commonly typed information and recall it instantly using hotkeys. (EG. F1, F2 etc...) it is the ultimate time saving tool for your help desk support staff, ideal for a ...

Information Packaging | 975 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 29.95 | Downloads: 1026

Date added: Feb 12, 2007 | » Details

» SlidingMenu

SlidingMenu is about Creative Layers. Using HTML inline tags to build up stacks of layers like eg. the VS.NET IDE Toolbox, SlidingMenu builds on the power of .Net templates to hide the DHTML and JavaScript difficulties moving the focus to the Creative Vis ...

Menulab | 351 KB | Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 0 | Downloads: 927

Date added: Sep 19, 2005 | » Details

» Themed .NET Wizard

Themed Wizard allows you to rapidly create wizard style interfaces in your .NET 2.0 WinForm application. With twelve included themes, designer navigation, and smart tags; Themed Wizard will make your WinForm application stand out from the crowd. ...

Kellerman Software | 6078 KB | Win98,WinME,WinXP,Windows2000,Windows2003 | 89.95 | Downloads: 936

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

Date added: Sep 19, 2005 | » Details

» NewsWidget

NewsWidget is a control for Visual Studio 2005 that allows developers to provide news and updates via RSS in their Windows forms applications. NewsWidget provides an easy way to stay in touch with your users and customers from a Windows application. The p ...

Innovux, Inc. | 472 KB | WinXP,Windows2003 | 0 | Downloads: 1006

Date added: Feb 12, 2007 | » Details

» RTextPrinter for .NET

This is an assembly used to print reports in text mode. This results in a FAST and LIGHT WEIGHTED printing solution for your .NET application. It support all major printer control command sets (HP-PCL, EPSON-ESC, IBM-Proprinter). Most printer are normally ...

J4L Components | 244 KB | WinNT 4.x,Windows2000,WinXP,Windows2003 | 50 | Downloads: 915

Date added: Feb 12, 2007 | » Details

» Client/Server Comm Lib for C/C++

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

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

Date added: Feb 12, 2007 | » Details

» CalendarGo Bundle Professional

DailyCalendar and Resource Scheduler are calendaring components for .NET. Written in managed C# they are seamlessly integrated with Visual Studio.NET. With a minimum of programmer`s work they provide a .NET application with Outlook-like calendars. Both Da ...

ComponentGo | 1196 KB | Win98,WinME,Windows2000,WinXP | 199 | Downloads: 1026

Date added: Sep 19, 2005 | » Details

» SocketTools Enterprise Edition

The Enterprise Edition offers the best of both worlds for the corporate developer who needs visual controls for rapid application development, as well as the power and flexibility of dynamic-link libraries for developing core application systems, and supp ...

Catalyst Development Corporation | 12971 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP | 895.00 | Downloads: 1010

Date added: Sep 19, 2005 | » Details

» PictureBox ActiveX Control With Inbuilt Zoom and Rotate

Picturebox ActiveX Control with inbuilt Zoom and Rotate functions. Relieves developers of writing seperate code for zoom and rotate fuctions. Also has inbuilt scroll bars to take care of increase in size due to zoom/rotate. Scrollbars appear and disappear ...

Abhiram Softwares Pvt Ltd | 746 KB | Win98,WinNT 4.x,WinXP,Windows2000 | 29.99 | Downloads: 1004

Date added: Sep 19, 2005 | » Details

» WebPic Deluxe

WebPic Deluxe is an image processing ActiveX control. It reads over 20 and writes 10 file formats. The control features powerful image processing functions such as cropping, rotation, resizing, resampling, screen capture, gamma and color channel correctio ...

Softuarium | 724 KB | Windows | 60 | Downloads: 913

Date added: Sep 26, 2005 | » Details

» COMM-DRV/Lib Standard Edition

Professional serial communication library - DLL for Windows & MSDOS libraries. Supports ZModem, YModem, XModem file transfer protocols, Hayes compatible modems, Microsoft Visual C/C++, Borland C/C++, Access, Visual Basic, Professional Basic, QuickBasic, & ...

WCSC (Willies Computer Software Co) | 7658 KB | Windows,Dos | 99.95 | Downloads: 1281

Date added: Sep 26, 2005 | » Details

» DataMatrix 2D Barcode .Net Control

MW6 DataMatrix .Net Windows From can create the professional 2D barcode image for your .Net applications, you can save the barcode as different image format files. It is easy to print barcode using the PrintDocument Control provided by the .Net Framework ...

MW6 Technologies, Inc. | 847 KB | Windows2000,WinXP | 199 | Downloads: 978

Date added: Sep 19, 2005 | » Details

» VbSMS

VbSMS is designed to Send SMS messages through GSM phones connected to your PC/server by Infrared, Bluetooth or data cable. Samples provided for Visual Basic, Visual C# .NET. VbSMS can be incorporated into any programming environment that supports ActiveX ...

YpgSoft | 327 KB | Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 149-590 | Downloads: 1004

Date added: Sep 26, 2005 | » Details

» InterBase Data Access Components

InterBase Data Access Components (IBDAC) is a VCL/VCL .NET/CLX component library for fast direct access to InterBase, Firebird, and Yaffil servers from Delphi, C++Builder, and Kylix. IBDAC is heavily performance- and stress-tested to provide the fastest a ...

Core Lab Software Development | 3913 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000,Windows2003,Windows Media Center Edition 2005,Windows Vista Starter,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise,Windows Vista Ultimate,Windows | 99.95 | Downloads: 1378

Date added: Oct 25, 2007 | » Details

go to top

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