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

» BigSpeed File Sharing Library

BigSpeed File Sharing Library includes two ActiveX controls (client and server) that dramatically simplify and accelerate the development of private file sharing solutions over the Internet. In addition to standard FTP operations, such as upload, download ...

BigSpeed Computing Inc. | 1514 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 95 | Downloads: 790

Date added: Sep 26, 2005 | » Details

» Nevron 3DChart for ActiveX

Nevron 3DChart for ActiveX is a powerful charting tool using the OpenGL 3D engine to display 2D and 3D business, scientific and presentation charts. It supports all basic charting types with lots of different style and logic variations. All chart type com ...

Nevron LLC | 29023 KB | Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP | 399 | Downloads: 704

Date added: Feb 12, 2007 | » Details

» PDFtext

PDFtext - A dll for your pdf-files... Royalty free! With this dll you can get the complete text-content out of your pdf-files. To do this you can use three ways: As an automated text-export into a generated file. As clipboard-content. As a returning text- ...

Ingo Schmoekel | 623 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP | 45.00 | Downloads: 706

Date added: Feb 12, 2007 | » Details

» Aspose.Excel

Aspose.Excel is a .Net Excel spreadsheet reporting component. With it, you can: Create Excel spreadsheets which support formatting, functions, pictures, charts, addin and comments without utilizing Microsoft Excel.Create Excel spreadsheets via designer, A ...

Aspose Pty Ltd | 2596 KB | WinXP,Windows2000,Windows2003 | 449 | Downloads: 769

Date added: Sep 19, 2005 | » Details

» QRCode Font

MW6 QRCode Fontware makes QRCode barcode creation extremely easy for your Windows application, your appication can print QRCode barcode using font. Win32 DLL encoder and .Net Class Library encoder are available. To help you to seamlessly integrate QRCode ...

MW6 Technologies, Inc. | 228 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000,Windows CE | 599 | Downloads: 736

Date added: Sep 19, 2005 | » Details

» Instrumentation Widgets for Mobile Devices

Need professionally looking device emulators for creating professionally looking computer simulators or software interfaces for Pocket PC? Developing these components on your own and hiring a designer is likely to take a lot of time and will cost thousand ...

9Rays.Net | 651 KB | Windows CE | 266 | Downloads: 749

Date added: Sep 19, 2005 | » Details

» MSCExec for Linux

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 | 120 KB | Linux | 58.95 | Downloads: 751

Date added: Sep 19, 2005 | » Details

» Aztec 2D Barcode ASP Component

Our small footprint Aztec ASP component is an ATL COM product which can add professional quality 2D barcode PNG format image to your web pages running on the IIS server. ...

MW6 Technologies, Inc. | 27 KB | Windows2000,WinXP | 299 | Downloads: 762

Date added: Sep 19, 2005 | » Details

» Movie Player ActiveX Control

For Professional Windows Developers who need to provide video/audio playback function within their business application. Support AVI, WMV, MPEG-1, ASF, WAV, MP3, MID file playback. Fully Control Sound Volume. Snapshot from movie file. Aspect Ratio Control ...

Viscom Software | 5100 KB | Windows | 50 | Downloads: 714

Date added: Sep 26, 2005 | » Details

» SSHBlackbox (.NET)

SSHBlackbox .NET Edition is a comprehensive collection of managed components that add client-side and server-side support for SSH (Secure Shell) to your .NET Framework applications. SSHBlackbox.NET includes complete SSH protocol support and supports full ...

EldoS Corporation | 7483 KB | Win98,WinME,WinXP,Windows2000,Windows2003 | 173 | Downloads: 748

Date added: Sep 26, 2005 | » Details

» Vivid Report for Delphi 6

Vivid Report is a library of visual components for C++ Builder and Delphi, which provides creating printable reports of almost any complexity. Vivid Report provides perfect guaranteed printing quality and excellent productivity of designing. Version 2.0 i ...

MBLabSoft | 2029 KB | Win95,Win98,WinME,WinXP,WinNT 3.x,WinNT 4.x,Windows2000,Windows2003 | 99 | Downloads: 703

Date added: Sep 19, 2005 | » Details

» AddFlow for .NET

AddFlow for .NET is a .NET Windows Forms Custom control. It provides approximately the same flowcharting/diagramming features as the ActiveX version but also some new features (class derivation, OwnerDraw property, Anti-Aliasing, custom shapes, property b ...

Lassalle Technologies | 3287 KB | Win95,Win98,WinNT 4.x,Windows2000,WinXP | 499 | Downloads: 815

Date added: Feb 12, 2007 | » Details

» Voice Insert DLL

Insert Speech To Text in any Windows Application. Recognizes Full 60000 Word English/Chinese Dictation. Features Limited Dictation, Voice Commands and Passwords Enables Point`n Speak with Read Aloud Target Support. XML Scripting Input for Limited Domain G ...

Research Lab Inc | 2935 KB | Win 3.1x,Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 399 | Downloads: 719

Date added: Sep 19, 2005 | » Details

» StockChartX

For .NET, VB6, C++ and other languages: StockChartX features new charting types: 3D Candlesticks, Renko, Kagi, Three Line Break, Point & Figure, Candlevolume, Equivolume, Shaded Equivolume, Darvas Boxes,Technical Analysis and more! Now developers can ...

Modulus Financial Engineering | 1024 KB | Win 3.1x,Win95,Win98,WinME,WinXP,WinNT 3.x,WinNT 4.x,Windows2000,Unix,Linux,MS-DOS,AS/400,OS/2,OS/2 Warp,OS/2 Warp 4,MAC 68k,Mac PPC,Palm OS 1.0,Palm OS 2.0,Palm OS 2.1,Palm OS 3.0,Palm OS 3.1,Palm OS 3.2,Windows CE,OpenVMS | 0.00 | Downloads: 765

Date added: Feb 12, 2007 | » Details

» SmartToolEngine

SmartToolEngine is a good-optimized high-performance ActiveX component for creating and managing WinXP like style window menus, toolbars, popup menus and context menus with various appearance styles. Features Summary Tools Support - Automatic support of g ...

Stortingham Industires, LLC. | 8853 KB | WinXP,Windows2000 | 249 | Downloads: 716

Date added: Sep 19, 2005 | » Details

» FTP Voyager Software Development Kit

The FTP Voyager Software Development Kit (SDK) allows you to power your application`s FTP capabilities with same engine used in the FTP Voyager client. The SDK exposes FTP Voyager`s FTP capabilities through a thoroughly documented and easy to integrate DL ...

RhinoSoft.com | 7121 KB | Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 | 999.95 | Downloads: 758

Date added: Feb 12, 2007 | » Details

» Excel Viewer OCX

Excel Viewer OCX acts as an ActiveX document container for hosting Excel document in a custom form or Web page. Support Excel automation client and offer abundant sample codes. It can be easily integrated into applications written in languages that suppor ...

Web Office | 1905 KB | Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000,Windows2003 | 99 | Downloads: 450

Date added: Feb 12, 2007 | » Details

» Modeling Studio

The DInsight product suite includes Modeling Studio, native and .NET versions of KernelCAD ActiveX control, and free downloadable Model Viewer. Although DI Modeling is a standalone 3D modeling system DInsight suite is ideal as a CAD for software developer ...

DInsight | 7212 KB | Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000 | 120 | Downloads: 749

Date added: Sep 19, 2005 | » 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: 699

Date added: Sep 19, 2005 | » Details

» DF SDK

DF SDK is a Software development kit which provides an effective approach of creating patch and update modules, and integrating of the patch applying and/or building process directly into you own software product(s). Unlike other available products, DF SD ...

AgenSoft | 844 KB | Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 | 295 | Downloads: 755

Date added: Feb 12, 2007 | » Details

go to top

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