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

» llPDFLibX

ActiveX Server for create Portable Document Format (PDF) files on fly.Easy way for create PDF files from your applicationMain features:Real hDC, Acroforms, Watermarks, Thumbnail, JavaScript, Encryption, Outlines, Compression, Hyperlink, Annotation, embedd ...

llionsoft | 1090 KB | Windows | 299 | Downloads: 859

Date added: Sep 26, 2005 | » Details

» xFunction for Linux

The xFunction library is the universal solution for integration of Java code with code written in other languages, superior in many aspects to Java Native Interface (JNI). With xFunction, you no longer need to implement those ugly native methods. Instead, ...

Excelsior, LLC | 101 KB | Linux | 50 | Downloads: 822

Date added: Feb 12, 2007 | » Details

» Speech Engine DLL SDK

Start recognizing voice commands in any spoken language with Research-Lab`s Isolated Words Language-Independent Speech Recognition Engine. From writing a simple voice commands recognition program to a VoiceXML PC-To-PC Interactive Voice Response, English ...

Research Lab Inc | 6146 KB | Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003,Palm OS 6.0,Windows CE,Pocket PC,Windows Mobile 2003 | 0 | Downloads: 829

Date added: Sep 26, 2005 | » Details

» DISLIN for Lahey LF95

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

Date added: Sep 19, 2005 | » Details

» Chilkat ASP Mail Component

A POP3 / SMTP email .NET component for sending and receiving email. Packed with advanced features including: full S/MIME capability for sending and receiving signed and encrypted email, MHTML for sending HTML email with embedded images and style sheets, m ...

Chilkat Software, Inc. | 2000 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 99 | Downloads: 927

Date added: Sep 19, 2005 | » Details

» ScroogeXHTML for the Java(tm) platform

ScroogeXHTML for the Javai(tm) platform is a JavaBean(tm) which can convert RTF stored in files or strings to XHTML. It is fast, easy to customize and use and comes with full source code. It converts text attributes including background and highlight colo ...

Betasoft | 150 KB | Windows | 49 | Downloads: 876

Date added: Sep 26, 2005 | » Details

» ANSMTP

ANSMTP Object is a high performance SMTP COM Object which enables your ASP/VB or other COM environment applications to send rich TEXT/HTML email based on SMTP/ESMTP protocol. It also supports CC, BCC, multiple attachments, mass mail and ESMTP authenticati ...

AdminSystem.Net - EmailArchitect | 417 KB | Windows | 39.95 | Downloads: 953

Date added: Sep 26, 2005 | » Details

» MegaPipe ActiveX

MegaPipe ActiveX is a reliable and powerful control for handling serial communication, modem operation and file-transfer (XModem Checksum, XModem CRC, XModem 1K, YModem, YModem-G, ZModem and Kermit). It can be used in any ActiveX-compliant environment lik ...

MW6 Technologies, Inc. | 954 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000,Windows CE | 699 | Downloads: 865

Date added: Sep 19, 2005 | » Details

» PlusDock

Custom docking windows library, featuring floating forms, autohide panels and redockable windows. Full Office2003 theme support, integrated WYSIWYG desginer support for VS.NET, fast rendering, accurate panel transitions and full documentation. Supports ta ...

Olvio IT, Inc. | 3727 KB | Win95,Win98,WinME,WinXP,Windows2000 | 165 | Downloads: 869

Date added: Sep 19, 2005 | » Details

» SearchBlackBox SDK

90% of the time, modern office software operates using textual data. Various pieces of text are spread everywhere on our disks, local and global networks, etc. Thousands of developers spend months trying to provide search capabilities to end-users. Some o ...

SearchBlackBox Software | 1980 KB | Win98,WinXP,WinNT 4.x,Windows2000,Windows2003 | 99 | Downloads: 967

Date added: Sep 19, 2005 | » Details

» Teroid Multi Segment Display

This control emulates the LED or LCD multi segment displays commonly used on electrical and electronic items, and provides a more impressive and eye-catching alternative to the Label control. It will display upper and lower case letters, numbers, and all ...

Teroid Software Limited | 124 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 19.95 | Downloads: 839

Date added: Feb 12, 2007 | » Details

» Lazy Mail

Lazy Mail is the easiest way for programmers to add outgoing email capabilities to their programs. Lazy Mail is completely self-contained, so there are no installation hassles, no dependence on MAPI or Outlook, no security warnings from overprotective ema ...

WS Designs | 921 KB | Win95,Win98,WinME,WinNT 3.x,WinXP,Windows2000,Windows2003 | 25.00 | Downloads: 893

Date added: Sep 19, 2005 | » Details

» Intellexer Spellchecker SDK

Add spell checker capabilities to your Windows projects! With EffectiveSoft Spellchecker SDK this is easy. The development library contains a common DLL interface and interfaces for C++ and .NET with corresponding documentation and examples (C++, C#, Delp ...

EffectiveSoft | 2283 KB | Win95,Win98,WinME,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 Prem | 70 | Downloads: 938

Date added: Feb 12, 2007 | » Details

» Rich Chart Server

Rich Chart Server generates captivating dynamic Flash charts from ASP.NET and Windows Forms applications. Use the included authoring tool to visually design a rich chart template which can include stunning animation effects, audio narration, text and imag ...

Blue Pacific Software | 5612 KB | WinXP,Windows2000,Windows2003 | 695 | Downloads: 905

Date added: Sep 19, 2005 | » Details

» monoASPUpload

monoASPUpload component is COM-component designed to easy access to data received from HTML-forms of client`s browser with attribute enctype=`multipart/form-data` when developing Active Server Pages applications. monoASPUpload component is based on Window ...

MonocerosSoft | 13 KB | Windows2000,WinXP,Windows2003 | 49 | Downloads: 910

Date added: Sep 19, 2005 | » Details

» Email Wizard ActiveX

Email Wizard Toolpack is a collection of four controls that will let you send and receive electronic mail quickly and efficiently. It is a subset of the IP Wizard Toolpack POP3 Wizard SSL allows you to receive mail from any POP3 server. It even has a spec ...

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

Date added: Sep 19, 2005 | » Details

» CoreAPI SDK

<p> Developer`s SDK for .NET platform providing Client/Server and Object Persistence functionality. Available in Personal, Professional and Enterprise Editions (from 3 to unlimited number of simultaniously connected clients). </p><p> The <b>Co ...

CoreAPI | 259 KB | Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 29.95 | Downloads: 950

Date added: Sep 19, 2005 | » Details

» Aspose.Component

Aspose.Component is a product suite including all individual products: Aspose.Excel, Aspose.Word, Aspose.Project, Aspose.Pdf, Aspose.Chart, Aspose.Spell, Aspose.Recurrence. If you need more than one product, you`re strongly recommended to consider a produ ...

Aspose Pty Ltd | 3000 KB | WinXP,Windows2000,Windows2003 | 648 | Downloads: 925

Date added: Sep 19, 2005 | » Details

» KeyboardControl SDK

KeyboardControl SDK allows to disable any hotkey or keystroke such as PrintScreen, Alt+Tab, Alt+F4, Ctrl+Tab, Ctrl+Alt+Del, Alt+Esc, Ctrl+F4 on Windows 95/98/Me and Windows NT/2000/XP. ...

| 530 KB | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 | 299 | Downloads: 891

Date added: Sep 19, 2005 | » Details

» ActiveGantt Scheduler Component

Add Scheduling capabilities to your application. An ActiveGantt control displays all types of data that can be presented in a Gantt Schedule format. An ActiveGantt control can be typically used to display appointments, tasks or other kinds of programmed a ...

The Source Code Store | 2144 KB | Win95,Win98,WinME,WinXP,Windows2000 | 480 | Downloads: 970

Date added: Sep 19, 2005 | » Details

go to top

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