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

» eDocEngine ActiveX/.NET

Gnostice eDocEngine is a generic electronic document creation component suite for Microsoft Visual Studio, Microsoft Visual Studio .NET, Borland Delphi 8 .NET and Borland C++Builder. eDocEngine enables you to create rich electronic documents in over 18 po ...

Gnostice Information Technologies Private Limited | 955 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 299 | Downloads: 1265

Date added: Sep 19, 2005 | » Details

» RSP Advanced Compressor OCX

ActiveX OCX to compress files with an advanced compression format - Ability to compress and uncompress files using an advanced compression format - It can compress better than gzip, zlib , zip or bzip2 - The compression engine is loaded dynamically in the ...

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

Date added: Sep 19, 2005 | » Details

» MarshallSoft DUN Dialer for Xbase++

MarshallSoft Dialup Networking (DUN) Component for Xbase++. Version 2.1, 7/02/2002. Invoke 32-bit Windows Dialup Networking (DUN) from your Xbase++ application code to dial up any installed Internet Service Provider (ISP). Requires Alaska Xbase++ compiler ...

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

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

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

Date added: Feb 12, 2007 | » Details

» TAS Professional 7 Powered by CAS

TAS Professional is designed to be a complete application development tool for graphical operating systems. It provides application building tools for the programmer new to application development, as well as the seasoned developer demanding professional ...

Computer Accounting Solutions | 50411 KB | Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 199 | Downloads: 805

Date added: Sep 19, 2005 | » Details

» Best ComboBox

ActiveX ComboBox control with extended features including auto-completing text, complete control of colors, ability to automatically add text, etc. ...

SkySof Software Inc. | 352 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 49.95 | Downloads: 906

Date added: Sep 19, 2005 | » Details

» Pivo Ping Component

Pivo.Ping allows you to effortless enable your applications to send Internet Control Message Protocol (Ping/ICMP) packets in .NET. Programmatically ping a remote server, host, route, or any network device to see if it is up. Pivo.Ping fully supports RFC 7 ...

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

Date added: Feb 12, 2007 | » Details

» ZylIdleTimer.NET

ZylIdleTimer.NET is .NET component which helps you to take actions after a specified system-wide (related to the whole system) idle time or to check the time interval of user inactivity. System Idle time is the time interval of full user inactivity. In th ...

Zyl Soft | 72 KB | Windows2000,WinXP,Windows2003 | 19.99 | Downloads: 814

Date added: Sep 19, 2005 | » Details

» FlexiMIS

FlexiMIS component compliments the power of SQL and Excel with its own power. It takes the connection string, SQL query(ies) and header string as inputs and generates a properly formated, multi-sheet, interlinked Excel workbook as a report. The report can ...

Pra-Vi Services | 448 KB | Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000,Windows2003 | 999 | Downloads: 858

Date added: Feb 12, 2007 | » Details

» IP2stats ActiveX

IP2stats ActiveX, Identify the country origins of your visitors in real time. -Display Country name, population, currency, and continent. -Redirect user based on country. -Web log stats and analysis. -Filter access from specific countries. -Decrease credi ...

IP2stats.com | 630 KB | Win95,Win98,WinME,WinXP,Windows2000 | 29.95 | Downloads: 795

Date added: Sep 19, 2005 | » Details

» SMS ActiveX COMponent

ActiveX DLL that allows you to control SMS messaging through your compatible Nokia mobile phone. You can send, receive and manipulate your SMS messages, logos and melodies from any ActiveX enabled environment - ASP script, windows application, windows scr ...

Mondor | 336 KB | Windows | 49.50 | Downloads: 798

Date added: Sep 26, 2005 | » Details

» TX Text Control ActiveX Standard

TX Text Control ActiveX Standard is a word processing component that offers developers all the features expected in a high end word processing package in reusable component form: Supports RTF, HTML, ANSI, Unicode and many more; Tables, bullets, numbered l ...

The Imaging Source Europe GmbH | 6574 KB | Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 439.00 | Downloads: 829

Date added: Feb 12, 2007 | » Details

» Aztec 2D Barcode ASP.Net Component

Our lightweight Aztec ASP.Net component is 100% managed C# code product which can add professional quality 2D barcode image to your ASP.Net web pages running on the IIS server. ...

MW6 Technologies, Inc. | 17 KB | Windows2000,WinXP | 299 | Downloads: 832

Date added: Sep 19, 2005 | » Details

» DC Form Flipper

Form Flipper is a COM based component that allows you to Support Eastern Language , we support right to left application by changing alignment to right and orientation by flip form horizontally 180 ...

EgyFirst Software , inc | 1019 KB | Win98,WinME,WinXP,WinNT 4.x,Windows2000 | 10 | Downloads: 768

Date added: Feb 12, 2007 | » Details

» HsCipherSDK Encryption Library

HsCipherSDK is an Encryption Library providing an API to a suite of symmetric key cryptographic algorithms and one way hash digital signature algorithms. The library includes the following block and stream cipher modules: * AES (Advanced Encryption Standa ...

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

Date added: Feb 12, 2007 | » Details

» VeriLook SDK for Linux

VeriLook SDK for Linux. It allows rapid development of the biometric application using functions from VeriLook library, which ensure high reliability of the face identification, 1:1 and 1:N matching modes, multiple faces` processing, comparison speed up t ...

Neurotechnologija | 319 KB | Linux | 429 | Downloads: 847

Date added: Sep 19, 2005 | » Details

» Adonet Oracle Data Components

Snotra Tech Adonet Oracle Data Components for .NET provides special dataset which is intented for Oracle database. Snotra Tech Adonet Oracle Data Components extend standard functions and features of ADO.NET components and provide extra features those help ...

Snotra Tech | 2969 KB | 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 | 60 | Downloads: 899

Date added: Oct 25, 2007 | » Details

» BigSpeed Peer-to-Peer SDK

BigSpeed Peer-to-Peer SDK is a set of two COM components (Agent and Hub) that lets you set up a virtual private peer-to-peer (P2P) network for secure file sharing and messaging. The transfered data are scrambled using on-the-fly 128-bit AES encryption, wi ...

BigSpeed Computing Inc. | 1591 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 0.00 | Downloads: 813

Date added: Feb 12, 2007 | » Details

» SocketTools Scripting Edition

SocketTools Scripting Edition consists of Component Object Model (COM) libraries designed primarily for use in scripting languages such as VBScript, JavaScript and PHP. While the interface to the Scripting Edition components is similar to the ActiveX cont ...

Catalyst Development Corporation | 6945 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 395.00 | Downloads: 844

Date added: Sep 19, 2005 | » Details

go to top

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