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

» Timers OCX

The Timers control is a set of timers that expand on the timer control supplied with Visual Basic. The Timer control supplied with Visual Basic counts in milliseconds, up to about 65 seconds, this suite of timer controls allow over 32,000 hours to be time ...

April16 ActiveX Components | 3 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 2 | Downloads: 525

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

Date added: Sep 19, 2005 | » Details

» KeyTrap

Block Ctrl-Alt-Delete in Windows 2000 and Windows XP... (who said that it could not be done?) KeyTrap is a programmer`s tool for Microsoft Windows that allows you to trap key presses and optionally block them. KeyTrap offers a rigorous key trapping soluti ...

ITB CompuPhase | 528 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP | 190.00 | Downloads: 948

Date added: Sep 19, 2005 | » Details

» ShellBrowser Components for ActiveX

The ShellBrowser component set gives a programmer easy access to the Win32 shell functionality. The JamShellList, JamShellTree and JamShellCombo components look and behave exactly like the corresponding parts of the Explorer. All componments support the p ...

JAM Software | 3606 KB | Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 89.95 | Downloads: 847

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

Date added: Sep 19, 2005 | » Details

» Report Sharp-Shooter Express

Report Sharp-Shooter Express is the first, free reporting engine of such high class. The component is designed for .NET Framework 1.1 and 2.0 and provides vast capabilities for designing professional and multi-functional reports in Windows Forms applicati ...

Perpetuum Software | 32541 KB | Win98,WinME,WinXP,Windows2000,Windows2003 | 0.00 | Downloads: 868

Date added: Feb 12, 2007 | » Details

» HS TFTP C Source Library

HS TFTP is a software library in C (supplied with full source code) which implements Trivial File Transfer Protocol (TFTP) over UDP socket layer according to RFC 1350. Support for client and server side for both file get and put are provided. Optional 102 ...

Hillstone Software | 340 KB | Win95,Win98,WinME,WinXP,WinNT 3.x,WinNT 4.x,Windows2000,Windows2003 | 0 | Downloads: 894

Date added: Feb 12, 2007 | » Details

» PDF Creator Pilot

The library for creating PDF files from Visual Basic, ASP, Delphi, Visual C++, VBScript. PDF Creator Pilot includes detailed documentation together with the step-by-step tutorials. Key features: Extended set of methods and properties for easy PDF-file gen ...

Two Pilots | 4250 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP | 299.00 | Downloads: 903

Date added: Sep 19, 2005 | » Details

» Virtual Serial Port ActiveX CE

Virtual Serial Port ActiveX CE is a powerful ActiveX Control for Embedded platforms that allows your software to create custom additional virtual serial ports in Windows CE system and fully control them from within your own program. Virtual serial ports y ...

ELTIMA GmbH | 829 KB | Windows CE,Pocket PC | 99.95 | Downloads: 862

Date added: Sep 19, 2005 | » Details

» FlashPlayerControl .NET

FlashPlayerControl is a .NET component that enhances Macromedia Flash Player ActiveX features. It does not use its own engine to display movies, but instead provides a wrapper around official swflash.ocx/flash.ocx code. It is thus possible to avoid certai ...

Softanics | 380 KB | Win95,Win98,WinME,WinXP,WinNT 3.x,WinNT 4.x,Windows2000,Windows2003 | 99 | Downloads: 849

Date added: Sep 19, 2005 | » Details

» Office Viewer ActiveX Control

Office Viewer ActiveX Control enables your application to display and interact with Microsoft Office files such as Word, Excel, PowerPoint, Project and Visio. Simply place the OCX on your form, you can have all the office functions. Offer some custom prop ...

Office Viewer | 645 KB | Win 3.1x,Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000,Windows2003 | 79.95 | Downloads: 453

Date added: Feb 12, 2007 | » Details

» Small

A quick and little scripting language, specifically designed to extend applications. Features include a small footprint, quick execution of the P-code and a good interface to `native` functions. These features make Small a good scripting language for game ...

ITB CompuPhase | 3350 KB | Win 3.1x,Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Unix,Linux,MS-DOS,Mac PPC,Mac OS X,Windows CE | 0.00 | Downloads: 910

Date added: Sep 19, 2005 | » Details

» VLPropertyList

Visualize and manipulate multi-level categorized properties with this property browser control. It provides a compact, easy to use visual interface for editing a variety of data types including text, number, date, font, color, file name, folder, value lis ...

Viklele Consulting | 1912 KB | Windows | 149 | Downloads: 887

Date added: Sep 26, 2005 | » Details

» DC Image Button

Image Button is a COM based component that allows you to assign changable button icons for each state , where mouse over , mouse leave and mouse down<br> there is no need to change icons manually for every button if you want to change the applicatio ...

EgyFirst Software , inc | 929 KB | Win98,WinME,WinXP,WinNT 4.x,Windows2000 | 29 | Downloads: 865

Date added: Feb 12, 2007 | » Details

» 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: 929

Date added: Sep 26, 2005 | » Details

» AppFace UI Development Kits

AppFace UI Development Kits(AUDK),skin your software with four lines code ! Supported VB,VC,Delphi,BCB,DotNet.You can make your own characterful skin with the WYSWYG SkinTool quickly! It can save a mass of time and energy for users to the design the softw ...

MatinSoft | 2169 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 29 | Downloads: 1042

Date added: Sep 19, 2005 | » Details

» db4o for .NET

db4o (database for objects) is the open source object database for .NET. It is a fast, lean and easy to use database for native .NET objects. It is free software available under the GPL but also under an optional commercial license. It can persist any nat ...

db4objects, Inc. | 292 KB | Win 3.1x,Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003,Linux,Windows CE,Windows Mobile 2003 | 0 | Downloads: 142

Date added: Sep 19, 2005 | » Details

» ASP/Export2Access

ASP/Export2Access is a server side COM component that allows web developers to export from DAO or ADO recordsets into MS-Access (MDB) file. ...

Nonnoi Solutions | 376 KB | Windows2000,WinXP,Windows2003 | 35 | Downloads: 1798

Date added: Feb 12, 2007 | » Details

» MSCGzip for Linux

MSCGZip is GZip compression/decompression component. It allows you compress and decompress data and files using standard well-known Gzip data compression engine. ...

Miraplacid | 145 KB | Linux | 58.95 | Downloads: 938

Date added: Sep 19, 2005 | » Details

» StarBurn SDK

Rocket Division Software`s StarBurn SDK (Software Development Kit) is world most advanced CD/DVD Burning, Grabbing and Mastering Toolkit. Features are: All MMC compatible CD/DVD recorders (CD-R/W, DVD-R/W, DVD+R/W and DVD-RAM) are supported UDF file syste ...

RocketDivision.Com | 2275 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 2000 | Downloads: 850

Date added: Sep 19, 2005 | » Details

go to top

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