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

» Chilkat SMTP ActiveX Component

A POP3 / SMTP email ActiveX 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: 875

Date added: Sep 19, 2005 | » Details

» Delphi SWF SDK

Contains pure Object Pascal library for creating Macromedia Shockwave Flash movies (SWF), without using of any external dynamic libraries. Released features: - visual objects creating (shape, button, text); - advanced objects (morphing shape, sprite); - a ...

FeatherySoft | 977 KB | Not Applicable | | Downloads: 889

Date added: Sep 19, 2005 | » Details

» Intech SMTP

ITSmtp is a full-featured ActiveX control that includes automatic compression and encryption capabilities for attachments. The installation package comes complete with SDK documentation and application samples for VB, Scripting, and C. ...

Integration Technologies | 343 KB | Windows | 59.95 | Downloads: 909

Date added: Sep 26, 2005 | » Details

» File Search

File Search - File and Folder Search Component File Search (TFileSearch component) allows you find any file or folder on your disk - just set the required attributes, file and folder masks (wildchars are supported), choose the root folder and call the Sea ...

Greatis Software | 1527 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | | Downloads: 854

Date added: Oct 25, 2007 | » Details

» Internet Content Filter ActiveX

Get a quick control over unauthorized browsing in your company. Prevention is better than cure. Of all the viruses and ad-wares that keep popping-up, the best way to avoid them and improve your system performance, is cut the roots from which they arise. I ...

Research Lab Inc | 2087 KB | Win 3.1x,Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 79 | Downloads: 772

Date added: Sep 19, 2005 | » Details

» EZTwain Pro Toolkit

EZTwain is designed to provide robust scanning and image-input through TWAIN, with a minimum effort by the programmer. Adding basic TWAIN support can be done with one function call, but even the most complex TWAIN project will be simplified and shortened ...

Dosadi | 3402 KB | Win95,Win98,WinME,Windows2000,WinXP,Windows2003 | 100 | Downloads: 867

Date added: Sep 19, 2005 | » Details

» Neodeck Tool Tip Control

The free Neodeck Software Tool Tip control looks like the XP tool tip and allows you to display interactive help to your users. You can program the control to do whatever you want, from databound lists inside of it to appering anywhere on your form using ...

Neodeck Software | 30 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 0 | Downloads: 778

Date added: Sep 19, 2005 | » Details

» RSP CD-DA Extraction OCX

ActiveX OCX to list , test and extract audio or data from CD units and save as wav PCM files - Ability to test the CD hardware - Ability to extract audio ( or data! ) and save as PCM wav file - Ability to report information about the CD units hardware - A ...

RSP Software | 366 KB | Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 50 | Downloads: 808

Date added: Sep 19, 2005 | » Details

» WebCab Optimization (J2EE Edition)

Refined procedures for solving and performing sensitivity analysis on uni and multi dimensional, local or global optimization problems which may or may not have linear constraints. Specialized Linear programming algorithms based on the Simplex Algorithm a ...

WebCab Components | 6201 KB | Windows2000,WinXP,Windows2003,Unix,Linux,Mac OS X | 249 | Downloads: 261

Date added: Sep 19, 2005 | » Details

» Pivo InI Component

INI component reads and writes Windows style INI files. It provides a comprehensive set of functions making INI files a powerful way to store application settings. There are three common ways to store program information on the hard disk: in the Windows r ...

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

Date added: Feb 12, 2007 | » Details

» NetAhead Search Controls

Add dynamic searching to your asp.net 2.0 data webpages with visual controls. With dynamic searching you extent the search options dramatically. You also reduce the data resultset and speed up your data webpages. NetAhead Dynamic SearchControls enables yo ...

JLRC CO ApS | 140 KB | Windows2000,WinXP,Windows2003 | 129 | Downloads: 889

Date added: Feb 12, 2007 | » Details

» GrFinger Biometric SDK Trial

GrFinger SDK is a groundbreaking fingerprint recognition Software Development Kit (SDK) that allows you to integrate biometrics in a wide variety of applications. Thanks to its support for dozens of programming languages, richness of code samples, and its ...

Griaule Technology | 15575 KB | Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 45 | Downloads: 841

Date added: Feb 12, 2007 | » Details

» DISLIN for Borland C++ 5.5

DISLIN is a high-level library of subroutines and functions that display data graphically. It is intended to be a powerful and easy to use software package for programmers and scientists that does not require knowledge of hardware features. The software i ...

MPI fuer Sonnensystemforschung | 5137 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 0 | Downloads: 818

Date added: Sep 19, 2005 | » Details

» Magic CD/DVD Burner (C/C++ Library)

Magic CD/DVD Burner (C/C++ Library) is developed to fulfill the requirement of Data CD/DVD burning needs. The latest technologies are used to get the maximum output and to meet the future needs. Magic CD/DVD Burner Includes all the features required by th ...

Binary Magic | 1033 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 250 | Downloads: 1006

Date added: Sep 19, 2005 | » Details

» csNetUpload

This is an ASP.NET class that saves files uploaded through an HTTP post. It can save to disk or export the files as a byte array or a MemoryStream. The code runs on the server and requires no dependent code in the client. It is suitable for use with HTTP ...

Chestysoft | 388 KB | Windows2000,WinXP,Windows2003 | 50 | Downloads: 811

Date added: Feb 12, 2007 | » Details

» EMS QuickExport

EMS QuickExport Component Suite for Borland Delphi and C++ Builder will allow you to save your data in the most popular office programs formats for the future viewing, modification, printing or web publication. You can export data into MS Access, MS Excel ...

EMS HiTech | 6978 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000 | 59.00 | Downloads: 799

Date added: Sep 19, 2005 | » Details

» Chilkat Xml Parser Component

Chilkat XML offers a high-performance alternative to the standard XML DOM for creating, navigating, and manipulating XML documents. The Chilkat XML parser is faster and less memory intensive, and the API is much simpler. There is only one interface, which ...

Chilkat Software, Inc. | 1000 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 0 | Downloads: 863

Date added: Sep 19, 2005 | » Details

» RV-Media Jpeg2000 SDK

The RV-Media Jpeg2000 SDK is software development kit intended to enable programmers and prosumers to develop applications based on Jpeg2000 standart. SDK contains implementation of Jpeg2000 decoder and encoder(in future versions), Image Processing Librar ...

RV-Media Ltd | 1516 KB | WinNT 4.x,Windows2000,WinXP,Windows2003 | 0 | Downloads: 748

Date added: Feb 12, 2007 | » Details

» Aspose.Report

Aspose.Report is a .Net Report Component which allows developers to break down a report design process into different section so that business analysts, developers or DBA can work on different parts, for instance, a developer could use SQL editor to compo ...

Aspose Pty Ltd | 1946112 KB | WinXP,Windows2000,Windows2003 | 149 | Downloads: 853

Date added: Sep 19, 2005 | » Details

» XLReportCom

XLReportCom is a solution that generates reports using Microsoft Excel. Using Microsoft Excel and XLReportCom, you can create all kinds of reports quickly and easily. XLReportCom includes an ActiveX DLL and an executable file that can be used to develop y ...

LJZsoft | 858 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 249.95 | Downloads: 816

Date added: Feb 12, 2007 | » Details

go to top

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