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

» tssTrayNotify

tssTrayNotify in an ActiveX / COM component that places a clickable icon in the system tray, while providing a popup `balloon` style tool tip that instantly provides visual feedback for your users. This makes an ideal replacement for informational message ...

Teebo Software Solutions | 1228 KB | Windows | 24.95 | Downloads: 893

Date added: Sep 26, 2005 | » Details

» CadLib

DXF 3D .NET library with the following features: - Imports ascii and binary DXF files (DXF versions 12-14, 15 (2000)). - Exports ascii and binary DXF files (DXF versions 12-14, 15 (2000)) from code. - Views DXF files (3D wire frames drawn with GDI+). - Ut ...

Wout Ware | 3764 KB | Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP | 525 | Downloads: 984

Date added: Feb 12, 2007 | » Details

» SocketTools Secure Enterprise Edition

The SocketTools Secure Enterprise Edition is a collection of components that supports secure data connections over the Internet or a local network. Included are File Transfer Protocol (FTPS), Simple Mail Transfer Protocol (SMTPS), Hypertext Transfer Proto ...

Catalyst Development Corporation | 12971 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 1895.00 | Downloads: 961

Date added: Sep 19, 2005 | » Details

» IDAutomation ASP Barcode Server Component for IIS

Easily add dynamic server-side barcodes to web applications. The ASP Barcode Server Component for IIS is a server side component used to add bar codes to webpages hosted on Microsoft IIS through ASP (Active Server Pages). This implementation is compatible ...

IDAutomation.com, Inc. | 1443 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 299.00 | Downloads: 877

Date added: Sep 19, 2005 | » Details

» LASsie (Light Application Security) for MS Access

LASsie (Light Application Security) is a Microsoft Access Add-In that enhances your Access application with a simplified user security system. Intended as an alternative to Access’ built-in security, LASsie offers a less complicated way to secure forms, r ...

Peter De Baets | 770 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 35.95 | Downloads: 900

Date added: Sep 19, 2005 | » Details

» MSCCrypto for Linux

MSCCrypto is COM component for Active Server Pages and stand-alone applications. It includes collection of the best encryption and hashing algorithms: - RSA public key algorithm (512/1024/2048 bits key size) - AES symmetric block algorithm (128/192/256 bi ...

Miraplacid | 225 KB | Linux | 161 | Downloads: 891

Date added: Sep 26, 2005 | » Details

» Calendar ActiveX Control

Ability to navigation to pervious and future months, as well as the ability to select a particular month to view. Allow user to define display area. Allow user to define the style of calendar (Background / Highlight /Text color/Font Name). Allow user inpu ...

Viscom Software | 1124 KB | Win98,WinME,WinXP,Windows2000 | 60 | Downloads: 892

Date added: Sep 19, 2005 | » Details

» Chilkat Java XML Toolkit

Java XML toolkit for parsing and creating XML. Advanced API for XML compression, XML encryption, and handling XML binary content. Fully internationalized to handle any language / character encoding. ...

Chilkat Software, Inc. | 2000 KB | Windows2000,WinXP,Windows2003 | 0 | Downloads: 946

Date added: Feb 12, 2007 | » Details

» MailBee MessageCensor

MailBee MessageCensor is a COM object to censor and filter e-mail or html. It provides features to filter html-formatted messages for unwanted content such as scripts and embedded objects. MessageCensor can also work in cooperation with MailBee POP3 or SM ...

iForum, LLC | 0 KB | Windows | 49 | Downloads: 902

Date added: Sep 19, 2005 | » Details

» ASP.NET Mobile Barcode Professional

Barcode Professional is a server control which can generate the most popular Linear and 2D Barcode Symbologies. After specifying a Value to encode, choosing a Barcode Symbology, and setting its properties, Barcode Professional will render the barcode imag ...

Neodynamic | 2344 KB | Windows2000,WinXP,Windows2003 | 59 | Downloads: 1013

Date added: Sep 19, 2005 | » Details

» Aspose.Format

Aspose.Format is a product suite including all individual products:Aspose.Excel, Aspose.Word,Aspose.Pdf, Aspose.PowerPoint, Aspose.Project. If you need more than one product, you`re strongly recommended to consider a product suite. Buying a product suite ...

Aspose Pty Ltd | 9310 KB | WinXP,Windows2000,Windows2003 | 675 | Downloads: 1027

Date added: Sep 19, 2005 | » Details

» ASP/Encrypt

ASP/Encrypt is a server side COM component that allows web developers to strong encrypting and decrypting of text and files. Supports the latest industry-standard strong encryption and hashing algorithms including: Blowfish, Cast 128, Cast 256, Rijndael, ...

Nonnoi Solutions | 322 KB | Windows2000,WinXP,Windows2003 | 40 | Downloads: 1301

Date added: Feb 12, 2007 | » Details

» DISLIN for Salford FTN95

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

Date added: Sep 19, 2005 | » Details

» Image Viewer CP Pro TIF PDF ActiveX OCX

Convert PSD, BMP, GIF, JPG, PNG, ICO, TIF image files to true color PDF file. Convert multipage TIF to multipage true color PDF. Support Lightness, Brightness, Contrast, Diffuse, Emboss, FocalBW, Gamma, InvertColor, Monochrome, Noise, SharpenEdge adjustme ...

Viscom Software | 6083 KB | Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP | 100 | Downloads: 1136

Date added: Feb 12, 2007 | » Details

» My Screen Capture ActiveX

This control let you capture screen in 5 ways (Full screen, Active window, predefined region, manual region and specific window) and getting instant result in memory. Some options are availables to save the screen on disk and/or send it to clipboard. Easy ...

Namtuk | 2367 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 49 | Downloads: 871

Date added: Sep 19, 2005 | » Details

» MSCExec for Windows

MSCExec allows you to call OS command or launch an application right from your script. You can set parameters for the call and check results. ...

Miraplacid | 688 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 0 | Downloads: 886

Date added: Sep 19, 2005 | » Details

» C++ Editor

C++ Editor - the text editor for C++ programmers. The editor have color syntax highlighting and all basic characteristics of standard editor of IDE (Integrated Development Environment). Editor`s main purpose is to edit source code files outside IDE with m ...

UA1ZCL Tools | 254 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 15 | Downloads: 958

Date added: Sep 19, 2005 | » Details

» FlyTreeView for ASP.NET

FlyTreeView for ASP.NET is a dynamic treeview control. Native ASP.NET control, features visual designers, native .net DataBinding to any ADO.NET source (DataSet, DataReader, arrays, and IList implementations, etc.), full ASP.NET viewstate support, highly ...

9Rays.Net | 583 KB | WinXP,Windows2000,Windows2003 | 59.50 | Downloads: 983

Date added: Sep 19, 2005 | » Details

» Active Server Image

Powerful graphics component to create server side professionally looking charts for Microsoft ASP. Fast, Flexible, Easy to Use, ASI is a charting and graphing component for web servers and for embedding in applications. By supporting UTF8 (Unicode) text s ...

eMarkSoft Inc. | 1634 KB | Windows | 229.00 | Downloads: 872

Date added: Sep 26, 2005 | » Details

» Audio Play And Record OCX

This activeX let you play multiple instance of any audio file and/or stream and record audio from any input. It let you to record from any source, even from the speaker, play multi audio file at the same, controlling volume, speed, bass, treble,..., of ea ...

Station Media | 1463 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 59 | Downloads: 993

Date added: Sep 19, 2005 | » Details

go to top

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