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

» MailBee POP3

MailBee POP3 is a powerful and easy to use COM object which enables ASP and Windows applications to receive, parse and delete mail from POP3 servers. Secure authentication, HTML mails, smart and fast MIME parser, email safety, and much more. Can be used i ...

AfterLogic | 1900 KB | Win98,WinME,WinNT 4.x,WinXP,Windows2000,Windows2003 | 69 | Downloads: 870

Date added: Sep 19, 2005 | » Details

» HTML2PDF Add-on

HTML2PDF Add-on is a library that helps you to convert HTML to PDF using PDF Creator Pilot. The add-on library can produce PDF documents using specific HTML code, text file or text buffer. It supports URL conversion, including image linking. The library i ...

Two Pilots | 1647 KB | Win95,Win98,WinME,Windows2000,WinXP,Windows2003 | 199.00 | Downloads: 815

Date added: Sep 19, 2005 | » Details

» MarshallSoft DUN Dialer for dBase

MarshallSoft Dialup Networking (DUN) Component for Visual dBase. Version 2.1, 7/1/2002. Invoke 32-bit Windows Dialup Networking (DUN) from your application code to dial up any installed Internet Service Provider (ISP). Requires 32-bit Visual dBase compile ...

MarshallSoft Computing | 214 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 55 | Downloads: 777

Date added: Sep 19, 2005 | » Details

» Active Metadata

Active Metadata is an ActiveX component to get and set additional image information. Usually these includes copyright, digital camera model, or program by which this image is made. Also you can get creation date, comments, exposure time, resolution, color ...

Avalio Inc | 1277 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 8.95 | Downloads: 879

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

Date added: Oct 25, 2007 | » Details

» 10Tec iGrid.NET

iGrid.NET is the most flexible, fast and easiest grid for the .NET Framework. It provides you with a wide range of properties and events which allow you to highly customize it for your particular task. You can use iGrid.NET either as a list view substitut ...

10Tec Company | 4438 KB | Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 199 | Downloads: 1029

Date added: Feb 12, 2007 | » Details

» MyNeoReport .Net Reporting Tool

MyNeoReport is a little reporting engine and designer for .Net applications, for programmers which want a tool to make reports that is really simple and doesn`t cost hundreds of dollars. Features: - Support for all OLEDB providers - Support both Data-Push ...

NeoDataType | 176 KB | Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 0 | Downloads: 837

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

Date added: Sep 19, 2005 | » Details

» Active Calculator Component

Support all common mathematical expressions Allow user defined variables and functions Support many predefined functions ...

Guangming Software | 1536 KB | Win98,WinME,WinXP,Windows2000,Windows2003 | 99.95 | Downloads: 891

Date added: Sep 19, 2005 | » Details

» csXImage

This ActiveX / OCX control displays, resizes, edits and joins images. It supports JPG, GIF, BMP, PNG, PCX, PSD, TIFF and WBMP files and can convert between them. Images can be exported to PDF. You can create thumbnails and change JPG compression quality t ...

Chestysoft | 1162 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 150 | Downloads: 843

Date added: Sep 19, 2005 | » Details

» Ping Wizard ActiveX

Ping Wizard lets you conduct tests on the speed of your network. Ping Wizard sends a special packet to a server, and times how long it takes to get a reply. This time is the total latency of the packets that you send when communicating with this server. I ...

Seekford Solutions, inc | 5140 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 199 | Downloads: 786

Date added: Sep 19, 2005 | » Details

» PageHelper

The page orientation of a document is defined as the printing direction of text lines. Therefore the page orientation can be in either horizontal printing mode (portrait mode) or vertical printing mode (landscape mode). The page orientation correction is ...

Personal PC Helpers | 613 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003,Linux | 18 | Downloads: 823

Date added: Feb 12, 2007 | » Details

» LinesHelper

Faxed documents often contain annoying horizontal lines due to communication noise on the telephone line. Scanned document in some cases, also have horizontal or vertical lines due to the banding or folding of papers.By utilizing LinesHelper these lines c ...

Personal PC Helpers | 781 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003,Linux | 18 | Downloads: 812

Date added: Feb 12, 2007 | » Details

» Chilkat SSL COM Component

Chilkat SSL is a free COM component that makes it extremely easy to communicate securely over a TCP socket using either the SSLv3 or TLSv1 protocols. This component is designed to be used by C++ applications, and cannot be used from Visual Basic or ASP. ...

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

Date added: Sep 19, 2005 | » Details

» Dragonfly Chart .Net

Dragonfly Chart .Net provides 2D/ 3D .Net Controls of pie chart, ring chart, bar chart, X-Y Chart and angle chart, which can be widely applied in many .Net applications such as Industrial Automation HMI applications, financial and insurance applications, ...

Dragonfly Automation Software | 6616 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 500 | Downloads: 839

Date added: Sep 19, 2005 | » Details

» HS GPSDLL Library

HsGpsDll is a Windows Dynamic Link Library which provides access to any NMEA-183 compliant GPS receiver via a serial communications port. HsGpsDll is designed for use from Visual C, Visual Basic or other programming languages. HsGpsDll allows a user appli ...

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

Date added: Feb 12, 2007 | » Details

» TaskPaneXP

TaskPaneXP is an ActiveX control that accurately emulates the task panes, or `Explorer Bars`, that are found in Microsoft Windows XP. Task panes provide a flexible way of presenting a group of related tasks to your users. This control can be setup to use ...

Teebo Software Solutions | 2353 KB | Windows | 59.95 | Downloads: 808

Date added: Sep 19, 2005 | » Details

» EZNamespaceExtensions.Net

EZNamespaceExtensions.Net is a framework for fast, painless and easy development of Windows Explorer namespace extensions in .Net. It eliminates the time-consuming, error-prone and complicated process of developing namespace extensions and enables you to ...

Sky Software | 944 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 295 | Downloads: 619

Date added: Feb 12, 2007 | » Details

» Audio Data Burner OCX

Audio Data Burner OCX 1.0 is an ActiveX control for software developers. This control can burn regular audio files (as MP3 and WMA) in the root directory of the CD. We use this control to burn MP3 and WMA CDs. This control supports many events, works on a ...

audiocdtools.com | 181 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 49 | Downloads: 781

Date added: Feb 12, 2007 | » Details

» commandLine .NET

Secure and managed .net component that executes DOS and console commands. Each command executes asynchronously and raises events containing current output, completion status, and DOS ERRORLEVEL. Users can also set timeouts, abort commands, and simulate us ...

AS-Pro Software | 133 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000,MS-DOS | 29.95 | Downloads: 895

Date added: Sep 19, 2005 | » Details

go to top

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