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

» Aspose.Office

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

Aspose Pty Ltd | 3300 KB | WinXP,Windows2000,Windows2003 | 648 | Downloads: 692

Date added: Sep 19, 2005 | » Details

» Nevron Diagram for Windows Forms

Nevron Diagram for Windows Forms is the leading diagram visualization component for Windows Forms. The component is suitable for flowcharts, network editors, organization charts, industrial control software, form layout tools and others. The rich set of s ...

Nevron LLC | 6779 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 489 | Downloads: 654

Date added: Sep 19, 2005 | » Details

» BKResizer

BKResizer gives your .NET Windows applications and controls resolution independence. BKResizer changes the size, location, and font size, scales the background and foreground images of controls as they are resized, without requiring you to write ANY code. ...

Bill Koukoutsis | 1915 KB | Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 95.85 | Downloads: 763

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

Date added: Sep 19, 2005 | » Details

» IDAutomation XML Barcode Webservice

Integrate dynamic barcoding into applications that consume Web Services with our Barcode Generator XML Webservice. The service installs on Windows Server and can be used by any application on any operating system that supports XML and SOAP (Simple Object ...

IDAutomation.com, Inc. | 1237 KB | WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 595.00 | Downloads: 722

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

Date added: Sep 19, 2005 | » Details

» QRCode 2D Barcode ActiveX

QRCode ActiveX is a powerful ATL-based barcode control generating the QRCode 2D barcode and can be used in any ActiveX-compliant environment like Word, Access, Excel, VB.Net, C#.Net, Visual Basic, Visual C++, Visual FoxPro, Delphi and C++ Builder. ...

MW6 Technologies, Inc. | 978 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows CE | 1299 | Downloads: 616

Date added: Sep 19, 2005 | » Details

» Resizer Wizard Activex for Visual Basic

Many programmers find it not only painful, but very annoying to have to add resize code to their Forms. Many times, deadline pressure makes it so that the Form has to be made Fixed(meaning the user can`t adjust the size). With customers using different re ...

Seekford Solutions, inc | 1004 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 69.00 | Downloads: 660

Date added: Sep 19, 2005 | » Details

» ELImageCompare

ELImageCompare ActiveX DLL - Powerful tool for comparing images. Intelligent algorithm allows to compare two images and returns one of the following results: images are different, similar or identical. The method of comparing of images is base on modern m ...

ELSoft | 1496 KB | Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 79 | Downloads: 655

Date added: Feb 12, 2007 | » Details

» ZylSerialPort.NET

ZylSerialPort.NET is a thread based, event driven, asynchronous serial port .NET component. Use ZylSerialPort.NET component to easily communicate with external devices on serial port connection, such as modems, bar code readers, GSM modules and others. Zy ...

Zyl Soft | 392 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 19.99 | Downloads: 614

Date added: Sep 19, 2005 | » Details

» Xceed SmartUI for .NET

Xceed SmartUI for .NET provides the visual controls you need to create user-friendly, state-of-the-art Windows Forms applications quickly and easily. It supports real themed or simulated Windows XP, Office XP and classic Windows styles. It includes menuba ...

Xceed Software Inc. | 18938 KB | Windows | $US 299.95 | Downloads: 652

Date added: Sep 26, 2005 | » Details

» Windows Std Serial Comm Lib for dBase

MarshallSoft Visual dBase serial communication component library (DLL) for serial port communications. Uses the standard Windows API to communicate with any device connected to a serial port. The Windows Serial Communications Libray includes 32 functions ...

MarshallSoft Computing | 305 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP | 105 | Downloads: 651

Date added: Sep 19, 2005 | » Details

» psSendMail

psSendMail™ is a Windows™ DLL that provides the ability to send e-mail messages. The purpose of this DLL is to make e-mail capability possible for those development environments that are capable of communicating with a DLL but cannot send e-mail directly. ...

Prestwood Software | 1077 KB | Windows | 29.95 | Downloads: 754

Date added: Sep 26, 2005 | » Details

» wodCrypt

wodCrypt is a lightweight component that provides strong encryption for your applications. It provides supports for most common crypto algorithms, such as AES ;DES ;TripleDES ;Blowfish ;Cast ;RC2 ;RC4 ;RC5 for symmetric encryption and decryption, ;RSA ;DS ...

WeOnlyDo! Inc. | 1189 KB | Windows | 129 | Downloads: 727

Date added: Sep 26, 2005 | » Details

» Aspose.Pdf.Fo

Aspose.Pdf.Fo is a .Net Pdf document component which allows developers to Convert an existing XML file (.xml) plus a style-sheet file (.xsl) to a new PDF document or a PDF file stream; Convert an existing XML XmlDocument plus a style-sheet XmlDocument to ...

Aspose Pty Ltd | 826368 KB | WinXP,Windows2000,Windows2003 | 99 | Downloads: 686

Date added: Sep 19, 2005 | » Details

» APNSoft DataGrid

ASP.NET server control with AJAX support to display data in a tabular format with options of choice, sorting and editing entries. DataGrid component has been designed in a way to reduce development time at the utmost and require no specific knowledge from ...

APNSoft | 3005 KB | Windows2000,WinXP,Windows2003,Windows Vista Business,Windows Vista Enterprise,Windows Vista Ultimate,Windows Vista Business x64,Windows Vista Enterprise x64,Windows Vista Ultimate x64 | 199 | Downloads: 780

Date added: Oct 25, 2007 | » Details

» Web Page SnapShot

The main purpose is to create a snapshot of a web page with URL. You can set image dimensions and save the image in BMP, Jpeg, GIF and PNG image formats. Also the component gets additional info about the page like Title, its text, links on the page, e-mai ...

Tonec Inc. | 1540 KB | WinXP,Windows2000 | 75.00 | Downloads: 670

Date added: Sep 19, 2005 | » Details

» TranscendSQL Report

TranscendSQL Report is a database report generator that allows you create any kind of professional report provided that you are familiar with XML and SQL queries. Besides, not only you can use it in our GUI but you can also use it in your own developed ap ...

Transcendent Technology Solution Company | 2111 KB | Windows | 29.9 | Downloads: 676

Date added: Sep 26, 2005 | » Details

» Teroid Data Graph

Teroid Data Graph is a .NET Windows Forms control which draws a graph from any suitable ADO .NET data source. It can draw a column, line or bar graph, the data source can be a connection string, Connection object, a DataSet object, a DataTable object or a ...

Teroid Software Limited | 131 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | | Downloads: 613

Date added: Feb 12, 2007 | » Details

» conaito VoIP ActiveX SDK

conaito VoIP ActiveX library for developers of VoIP audio applications, such as voice chat, conference, VoIP, providing real-time low latency multi-client audio streaming over UDP/IP networks. Includes efficient components for sound recording, playback, e ...

conaito | 767 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003 | 369 | Downloads: 670

Date added: Sep 19, 2005 | » Details

go to top

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