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

» Gastown C# Command Line Parser

The Gastown C# Command Line Parser easily and reliably handles parameters passed to your program on the command line. It allows you to automaticly handle double-quoted strings, support short and long parameter names, validate parameters, generate error me ...

Getaway Maps | 325 KB | Win95,Win98,WinME,WinXP,Windows2000,Windows2003 | 59 | Downloads: 837

Date added: Feb 12, 2007 | » Details

» BitmapCombo ActiveX Control

Key Features: 1. Ideal tool to pick picture from files, bitmaps, resources and any GDI handle. 2. A built-in visual picture file open/preview dialog. 3. Offers powerful items data management capabilities such as add, insert, delete, find, move, get/set in ...

NiceFeather Software Solutions Corp. | 2974 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 29.95 | Downloads: 786

Date added: Feb 12, 2007 | » Details

» SMTP/POP3 Email Engine for COBOL

MarshallSoft SMTP / POP3 COBOL email component library (SEE4CB) uses a simple API to send and receive mail, including HTML, MIME Base64 and quoted-printable encoded attachments, from within an application. Knowledge of Winsock and TCP/IP is not needed. Fe ...

MarshallSoft Computing, Inc. | 283 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 105 | Downloads: 1196

Date added: Sep 19, 2005 | » Details

» Lock O`Clock

The main goal of this software is to protect your workstation with password which can be different from your system password. The standard password functionality is also implemented and you can use the both features. In addition, you can allow people to l ...

Igor Kovalevsky | 345 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | | Downloads: 824

Date added: Sep 26, 2005 | » Details

» Teroid Multi Segment Display

This control emulates the LED or LCD multi segment displays commonly used on electrical and electronic items, and provides a more impressive and eye-catching alternative to the Label control. It will display upper and lower case letters, numbers, and all ...

Teroid Software Limited | 124 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 19.95 | Downloads: 816

Date added: Feb 12, 2007 | » Details

» Source Code Scanners for C++ Builder 6

Source Code Scanners is the high performance library of visual components for C++ Builder and Delphi intended for creating analyzers and parsers of source codes. It includes components of the lexical analyzers: C++, Object Pascal (Delphi), PHP, HTML, CSS1 ...

MBLabSoft | 1169 KB | Win95,Win98,WinME,WinXP,WinNT 3.x,WinNT 4.x,Windows2000,Windows2003 | 40 | Downloads: 847

Date added: Sep 19, 2005 | » Details

» Editor.NET

Editor.NET is an advanced code editor allowing integration of a highly flexible edit control in your .NET applications. It has almost all the features that can be found in the Visual Studio.NET code Editor, including customizable syntax highlighting, code ...

Quantum Whale | 2960 KB | Win98,WinME,WinXP,Windows2000 | 249 | Downloads: 941

Date added: Oct 25, 2007 | » Details

» PowerPoint to Flash SDK

PowerPoint to Flash SDK for .NET, ASP.NET and COM developer of professional PowerPoint-to-Flash solution, such as Online Collaboration, Online sharing of PowerPoint presentations, Application for presentation of PowerPoint slide shows (converted to Flash) ...

conaito Technologies | 40157 KB | WinXP,Windows2000,Windows2003,Windows Tablet PC Edition 2005,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 Vista H | 1799 | Downloads: 774

Date added: Oct 25, 2007 | » Details

» Pivo Email Validator Component

Having problems with the email addresses in your mailing list?Are you tired of getting bounce backs every time you perform a mailing? Email Validator will solve your email validation problems. Email Validator is an assembly that requires the Microsoft .NE ...

Pivo Corporation | 232 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003,Unix,Linux,MAC 68k,Mac PPC,Mac OS X,Mac Other | 0 | Downloads: 880

Date added: Feb 12, 2007 | » Details

» Office Viewer OCX

Office Viewer OCX 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. Support office automation client w ...

OfficeOCX | 1759 KB | Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000,Windows2003 | 199 | Downloads: 400

Date added: Feb 12, 2007 | » Details

» Teroid Data Grid Print Control

Teroid Data Grid Print Control is a .NET Windows Forms component providing a set of methods and properties for printing the Data Grid which comes as a standard control with the .NET Framework, and includes page setup and print preview functionality. ...

Teroid Software Limited | 122 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP | 39.95 | Downloads: 852

Date added: Feb 12, 2007 | » Details

» ELChart ActiveX DLL

ELChart library is the powerful tool that allows to create programs with various charts. Library offers flexible GDI based solution that allows you to create animated, compact and great looking charts. With ELChart you you can create various charts such a ...

ELSoft | 814 KB | Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 49 | Downloads: 835

Date added: Feb 12, 2007 | » Details

» Upload Control

A File Upload/Download Component,A forceful and attractive solution for your sites to upload thousands of files via HTTP protocal. This upload ActiveX with a user-friendly and easy-to-use uploading interface. even for untrained users ,they can use it easy ...

VersalSoft | 1509 KB | Win95,Win98,WinME,Windows2000,WinXP,Windows2003 | 99.95 | Downloads: 888

Date added: Oct 25, 2007 | » Details

» Hex Editor ActiveX Control

The Hex Editor control allows the user to viewing and editing any sort of binary data and it has been designed to be used inside VC++, VB or Delphi applications and on web pages as wellFeatures: Multilevel undo/redo; Print; Insert/Over edit mode; Fast fin ...

ELRA-Kovatchev ET | 291 KB | Windows | 30 | Downloads: 859

Date added: Sep 26, 2005 | » Details

» ActiveXLS

ActiveXLS is the .Net and Java component to read and write Microsoft Excel files 1. export, import and format MS Excel reports 2. Microsoft Excel not required 3. avoid nightmares caused by OLE/ADO 4. minimize server load 5. make your job easier 6. increas ...

ActiveXLS | 10859 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003,Mac OS X,Mac Other | 295 | Downloads: 948

Date added: Feb 12, 2007 | » Details

» Teroid Data Form

Teroid Data Form is an easy to use .NET control which dramatically reduces development times by providing an instant user interface to an ADO .NET DataTable object. Drop one onto a form and set the DataTable property either at design time or at run time a ...

Teroid Software Limited | 115 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 0.00 | Downloads: 853

Date added: Feb 12, 2007 | » Details

» MyNeoReport

MyNeoReport is a little reporting engine and designer for .Net applications, for programmers who want a tool to make reports that is really simple and doesn`t cost hundreds of dollars. It supports all OLE data providers installed on the system as data sou ...

NeoDataType | 576 KB | Win98,WinME,Windows2000,WinXP,Windows2003 | 0 | Downloads: 914

Date added: Sep 19, 2005 | » Details

» DrTaskScheduler

Use our COM component to manage your local or remote tasks from VB, WSH, C++, ASP. All you need is one dll file DrTS.dll and Task Scheduler Component from Microsoft (included in IE4). ...

DATAROAD s.r.o. | 49 KB | Windows | 29 | Downloads: 847

Date added: Sep 26, 2005 | » Details

» Oxygen SMS ActiveX Control

Oxygen SMS ActiveX Control allows you to send and receive text and picture messages, send CLI Logos, read and write default SMS centre number, get stored message total and busy count, their locations, read and delete from SMS inbox. You are able to get ph ...

Oxygen Software | 472 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000 | 399 | Downloads: 581

Date added: Sep 19, 2005 | » Details

» Pivo Ping Component

Pivo.Ping allows you to effortless enable your applications to send Internet Control Message Protocol (Ping/ICMP) packets in .NET. Programmatically ping a remote server, host, route, or any network device to see if it is up. Pivo.Ping fully supports RFC 7 ...

Pivo Corporation | 232 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003,Unix,Linux,MAC 68k,Mac PPC,Mac OS X,Mac Other | 0 | Downloads: 827

Date added: Feb 12, 2007 | » Details

go to top

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