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

» ZipForge

ZipForge is a fast ZIP delphi component. With this Zip component you can easily add archive functionality to your projects. ZipForge includes our new unique technology, a transaction system. This innovative solution gives you a fast and easy way of updati ...

ComponentAce LLC | 1669 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 45 | Downloads: 732

Date added: Sep 19, 2005 | » Details

» LibMaster.com NTFSpath

As you know length of path in NTFS file system may reach 32767 characters but most of functions in Windows API permit a maximum path length 260 characters. The LibMaster.com NTFSpath library allows to work with a maximum path length 32,767 characters whic ...

LibMaster.com | 187 KB | WinXP,WinNT 4.x,Windows2000,Windows2003 | | Downloads: 757

Date added: Feb 12, 2007 | » Details

» AS PROCESS WIN32 DLL

Other memory managers, as applications, give you many interesting information about running process but control is limited. Now you will have process memory manager inside your applications. You can make changer on your own or let user to make them. You w ...

AS Computer Software | 54 KB | WinXP,Windows2003 | 10 | Downloads: 767

Date added: Feb 12, 2007 | » Details

» XMLInspector

XMLInspector helps developers to quickly and lightly create stable applications with human-engineered and understandable interface. The developers may concentrate on complex object modelling as XSD schemes whereas XMLInspector automatically enables them t ...

Devrace Ltd., S.A. | 3036 KB | Win95,Win98,WinXP,Windows2000,Windows2003 | 75 | Downloads: 365

Date added: Sep 19, 2005 | » Details

» KernelCAD Pro

KernelCAD Pro includes a major part of the KernelCAD Software Suite, which allows integration of 3D modeling into any Windows application. Dynamic Object Creation and Pro level interfaces give programmatic access to all functionality otherwise available o ...

DInsight | 6920 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 95 | Downloads: 720

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

Date added: Feb 12, 2007 | » Details

» FastReport CLX

Added: - compatibility with FastReport 2.5 VCL - Bitmaps export BMP - advanced HTML export - TfrReport properties: ReportComment, ReportName, ReportAutor, ReportDate, ReportLastChange, ReportPasswordProtected, ReportPassword, Advanced ReportVersion (major ...

Alexander Tzyganenko | 2278 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Linux | 99 | Downloads: 744

Date added: Sep 19, 2005 | » Details

» Balmsoft Wizard

Balmsoft Wizard allows easily create your own wizards that conforms with `Wizard 97 specification`. Just few clicks and all pages with all default controls with right size and fonts in place. Key features - Easy-to-start - just few clicks in GUI editor an ...

Balmsoft | 1167 KB | Win95,Win98,WinME,WinXP,WinNT 3.x,WinNT 4.x,Windows2000 | 34.95 | Downloads: 778

Date added: Sep 19, 2005 | » Details

» Web Page SnapShot

The main purpose is to create a snapshot of a web page with URL. You can set image dimensions and save the image in BMP, Jpeg, GIF and PNG image formats. Also the component gets additional info about the page like Title, its text, links on the page, e-mai ...

Tonec Inc. | 1540 KB | WinXP,Windows2000 | 75.00 | Downloads: 731

Date added: Sep 19, 2005 | » Details

» Chilkat ASP Email 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: 743

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

Date added: Oct 25, 2007 | » Details

» SFTPBlackbox (ActiveX/DLL)

SFTPBlackbox (ActiveX edition) is a comprehensive collection of native components that add client-side support for SFTP (Secure File Transfer Protocol) to your Windows applications. SFTPBlackbox includes complete SSH protocol support and supports full ran ...

EldoS Corporation | 4013 KB | Win95,Win98,WinME,WinXP,WinNT 3.x,WinNT 4.x,Windows2000,Windows2003 | 199 | Downloads: 1125

Date added: Sep 26, 2005 | » Details

» EaseSoft PDF417 .NET Windows 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. | 52 KB | Win98,WinME,Windows2000,WinXP,Windows CE | 129.00 | Downloads: 755

Date added: Sep 19, 2005 | » Details

» Map Suite Desktop

Map Suite Desktop Edition is a powerful and feature-rich .NET mapping control that enables C# and VB.NET software developers to build detailed desktop mapping applications. Utilizing Microsoft`s .NET Framework, the APIs for Map Suite Desktop Edition incor ...

ThinkGeo LLC | 29093 KB | WinNT 4.x,Windows2000,WinXP,Windows2003 | 4794.00 | Downloads: 722

Date added: Feb 12, 2007 | » Details

» VB HTML Help Generator

HTML Help generator creates professional HTML Help integrated with your VB applications in seconds. Features HTML page and image generation, table of contents, index and search, images with hotspots. Names used in HTML pages can be either captions or obje ...

Code-VB | 697 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 99 | Downloads: 738

Date added: Sep 19, 2005 | » Details

» .NET Matrix Library

The Bluebit .NET Matrix Library provides classes for object-oriented linear algebra in the .NET platform. It can be used to solve systems of simultaneous linear equations, least-squares solutions of linear systems of equations, eigenvalues and eigenvector ...

Bluebit Software | 3573 KB | Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 49 | Downloads: 857

Date added: Sep 19, 2005 | » Details

» Nevron Diagram for Windows Forms

Nevron Diagram for Windows Forms is the leading diagram visualization component for Windows Forms. The component is suitable for flowcharts, network editors, organization charts, industrial control software, form layout tools and others. The rich set of s ...

Nevron LLC | 6779 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 489 | Downloads: 709

Date added: Sep 19, 2005 | » Details

» MultiPowUpload

MultiPowUpload - multiple files upload component. It is easy client-side solution that can be used to perform file uploads from a user machine to the web server. MultiPowUpload is a Macromedia Flash movie supported by most browsers and needs just Flash pl ...

Element-IT Software | 248 KB | Windows2000,WinXP,Windows2003,Unix,Linux,Mac OS X,Mac OS X 10.1,Mac OS X 10.2,Mac OS X 10.3,Mac OS X 10.4,Mac OS X 10.5 | | Downloads: 735

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

Date added: Sep 19, 2005 | » Details

» SIP Phone DLL

SIP Phone DLL does the functions like - Make and answer phone calls, Detect tone and pulse digit from the phone line, Capture Caller ID, Support blind transfer, Single Step transfer / conference, consultation transfer/conference, hold, unhold, Control of ...

Research Lab Inc | 2814 KB | Win 3.1x,Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000,Windows CE | 79 | Downloads: 709

Date added: Sep 19, 2005 | » Details

go to top

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