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

» Personal C Sharp

Personal C Sharp extremely simplifies C# programming. Allows a person with minimum programming experience to write professional programs in C# and the .NET Framework.Contains all the tools to compile and debug your programs, nothing else to buy. See a dem ...

Famsoft | 125 KB | Windows2000,WinXP,Windows2003 | 0 | Downloads: 199

Date added: Feb 12, 2007 | » Details

» Pivo DnsResolver Component

Dns Resolver is used to queries DNS servers for host information and programmatically query DNS servers for information, without having to worry about complex packet parsing. It easily returns information in a humanly readable form. It allows you to progr ...

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

Date added: Feb 12, 2007 | » Details

» Xceed Backup Library

The Xceed Backup Library is an ActiveX control that allows Windows applications to automatically perform scheduled or on-demand backup and restore operations on their data files. The library can backup to local drive(s), remote drives, and removable media ...

Xceed Software Inc. | 21034 KB | Windows | 249.95 | Downloads: 969

Date added: Sep 19, 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: 967

Date added: Oct 25, 2007 | » Details

» Registry Pro

Registry Pro is an activeX control that gives developers easy and complete access to the power of registry programming. Works with VB, VBA and all other ActiveX and COM DLL supporting languages. Includes a detailed help file, comprehensive example program ...

Evans Programming | 1765 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 49.95 | Downloads: 876

Date added: Sep 19, 2005 | » Details

» DISLIN for Portland Group pgf77/pgf90

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 | 5300 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 150 | Downloads: 1344

Date added: Sep 19, 2005 | » Details

» llPDFLib

llPDFLib is pure Object Pascal library for create PDF documents. This library doesn`t use any DLL or external third-party software to generate PDF files. Library includes TPDFDocument component with properties and methods like Delphi`s TPrinter but design ...

llionsoft | 1447 KB | Win95,Win98,WinME,WinXP,Windows2000 | 299 | Downloads: 945

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

Date added: Sep 19, 2005 | » Details

» Wiseworx XButton .NET

Windows XP Theme Compliant - The .NET XButton component features Windows® XP Theme Technology that gives your application buttons the exact Windows® XP style themes, without manifest files. Image display over Themed Button - One of the problems with Micro ...

| 3510 KB | WinXP | 39.95 | Downloads: 1020

Date added: Sep 19, 2005 | » Details

» EquTranslator

It`s a fast equation parser/evaluator with parse-tree builder and user-friendly interface for parsing and calculation a run-time defined math expression. The math expressions is represented as string in a function style F(x1, x2,..., xn) =f(x1, x2,..., xn ...

Easy Math Solution | 270 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 75 | Downloads: 997

Date added: Sep 19, 2005 | » Details

» OpenDDPT

The physic of the real world can be formulated into mathematical form using differential equations. Differential equation and systems of differential equations are the natural language trough we can describe any real devices like electronic circuit, autom ...

Centi Riccardo | 2235 KB | Apple Mac OS,Linux,Solaris,MacOS,Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 0 | Downloads: 940

Date added: Oct 25, 2007 | » Details

» SkICMP ActiveX Control

SkICMP ActiveX Control is a lightweight and powerful ICMP (Ping and Traceroute) ActiveX control that can be used for network diagnosing, troubleshooting, and monitoring. SkICMP ActiveX Control can be used from any 32-bit Windows development environment, i ...

Magneto Software, Inc. | 1153 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 295.00 | Downloads: 977

Date added: Sep 19, 2005 | » Details

» Kellerman .NET Logger

Kellerman Logger is an easy to use, high performance logging framework for .NET 2.0 with the ability to log to multiple destinations. Kellerman Logger is faster and easier to use than Log4Net. The logger`s ability to log messages with a single line of cod ...

Kellerman Software | 1461 KB | Win98,WinME,WinXP,Windows2000,Windows2003 | 99.95 | Downloads: 998

Date added: Feb 12, 2007 | » Details

» PractiX Suite

Create class leading interactive visual interfaces for your .net applications. PractiX - Component suite for .Net contains PractiX Schedule control for .NET and PractiX StyleCannon for .NET. The PractiX Schedule control is a fully configurable Outlook sty ...

Practisoft | 2579 KB | Win98,WinNT 4.x,Windows2000,WinXP,Windows2003,Windows Vista Starter,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise,Windows Vista Ultimate,Windows Vista Home Basic x64,Windows Vista Home Premium x64,Wind | 179.00 | Downloads: 971

Date added: Oct 25, 2007 | » Details

» Remote Update ActiveX Control

Allow your customers to check for updated versions of your apps through the web! With Remote Update ActiveX Control you can quick and easily add the "Check for Updates" feature in your applications. Then, all users of your applications around th ...

Manitools Software | 395 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 59.95 | Downloads: 982

Date added: Sep 19, 2005 | » Details

» Vivid Report Free for C++ Builder 5

Vivid Report is a library of visual components for C++ Builder and Delphi, which provides creating printable reports of almost any complexity. Vivid Report provides perfect guaranteed printing quality and excellent productivity of designing. Version 2.0 i ...

MBLabSoft | 1928 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP | 0 | Downloads: 925

Date added: Feb 12, 2007 | » Details

» QRCode 2D Barcode ASP Component

Our small footprint QRCode 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. | 32 KB | Windows2000,WinXP | 799 | Downloads: 941

Date added: Sep 26, 2005 | » 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: 413

Date added: Feb 12, 2007 | » Details

» Chilkat S/MIME .NET Component

An S/MIME .NET assembly that provides the ability to S/MIME encrypt or digitally sign files or data. It can also decrypt and validate / authenticate S/MIME messages, data, or files. This component also provides general MIME message building and decomposit ...

Chilkat Software, Inc. | 1500 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 149 | Downloads: 1253

Date added: Sep 19, 2005 | » Details

» qs Barcode Code39 Reading

qs Barcode Code39 can read horizontal Code39 barcodes with 6 digits on monochrome images (windows bitmaps). qsBarcode Code39 is an easy-to-use DLL that can be from many different developer environments, such as C/C++, Java, VisualBasic or Delphi. ...

QS QualitySoft GmbH | 360 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP | 0.00 | Downloads: 1080

Date added: Sep 19, 2005 | » Details

go to top

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