MayerSoft.Web.Controls.Spreadsheet

download home page
developer:MayerSoft LLC
license:Commercial
version:1.0
size in Kb:125
price:$19.95
 
platform: Windows, Windows XP
downloads:31
our rating: n/a
popularity:
847/2027313
link error:Report


Rate me

Description:   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! FAQWhat 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+200System.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 exampleInitialization of a spreadsheetUsing 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


More Downloads Related to MayerSoft.Web.Controls.Spreadsheet

Server - Control - Spreadsheet - Mayersoft

Djuggler Enterprise Data Juggler automates repetitive Web & data tasks without programming code. Use it to create sophisticated scripts for collecting data from the Web, filling Web forms, transforming text files, XML, CSV and database data. The easy-to-use drag-and-drop interface creates scripts that can be deployed as stand-alone ...

Alvas.Controls Alvas.Controls (Windows.Forms) is a collection of 100% native CLR compliant controls written in C#.Collection allows C# and VB.Net developers to create applications with adaptable interface. Requirements: .Net Framework v1.0 or later Recommended: .Net Framework with Visual Studio .Net 7.0 or later Part of Alvas.SuiteProduct features: ...

JDataGrid Spreadsheet Edition JDataGrid provides a data grid, support some features such as row header, cell attributes, cell merge and split, undo and redo, find and replace, spell check, file input and export, print and print preview.

MayerSoft.Web.Controls.NewsScroller Two asp.net server controls: NewsScroller scrolls content in a box, and Display shows content with transitions. Declarative or code-behind content. Display and NewsScroller controls (2 in 1)MayerSoft.Web.Controls.Display MayerSoft.Web.Controls.NewsScroller MayerSoft.Web.Controls.DisplayThis is the Display control MayerSoftNews Scroller infoEasy to use!Just drop it on your web form and ...

Stimulsoft Reports.Web with Source Code Stimulsoft Reports.Web is reporting tool designed to create and render reports in Web. You can create reports. You can display reports. You can print reports. You can export reports. Stimulsoft Reports.Web will provide the complete cycle of report building, starting with report templates and ending ...

Stimulsoft Reports Designer.Web with Source Code Stimulsoft Reports Designer.Web - is the first report designer that allows you to edit reports completely in Web. There is no need to install .Net Framework, ActiveX components or other special plug-ins on your client's machine. All you need is a Web Browser. Stimulsoft Reports ...

Vax VoIP activeX SDK VAX VoIP activeX is the easiest way to add PC-to-PC voice chat and text chat over the LAN, WAN or Internet in your applications and Web pages. You can add many new voice and text chat related features and discover just how much better your ...

HyperPublish - Web CD product catalog Professional and comprehensive CD / Web catalog creation software. Create catalogs of your goods products and services easily. Descriptions, prices, pictures, order form / shopping cart, built-in search feature. Fully custom: can build from scratch or import from database / CSV, with automatic categories, subcategories, ...

myDBR Web Reporting myDBR is an innovative web reporting solution for MySQL and Microsoft SQL Server with support for latest smartphones (Android, iPhone, and Symbian). myDBR reporting solution brings unparalleled speed of authoring even the most complex reports. By automating most of the work needed on traditional reporting ...

Great Engine Web DB Browser The true thin client database develop tools,It support VS.NET and J2EE Run on IIS, Apache, Tomcat and WebLogic, JBoss etc Include ASP, ASP.NET, PHP ,JSP and Oracle iSQL*Plus Support Oracle, MS SQL Server 2000/2005, Informix, Sybase, MySQL and Access.

MayerSoft.Web.Controls.NewsScroller Two asp.net server controls: NewsScroller scrolls content in a box, and Display shows content with transitions. Declarative or code-behind content. Display and NewsScroller controls (2 in 1)MayerSoft.Web.Controls.Display MayerSoft.Web.Controls.NewsScroller MayerSoft.Web.Controls.DisplayThis is the Display control MayerSoftNews Scroller infoEasy to use!Just drop it on your web form and ...

Outlook Extractor Don't waste your valuable time! Extract all email addresses from Microsoft Outlook. Choose your folders, everything is easy and automatic!Both From: and To: addresses are extracted, including multiple recipients, with NO DUPLICATES! You get a clean mailing list, saved in a simple text file which ...


Latest Downloads from MayerSoft.Web.Controls.Spreadsheet publisher MayerSoft LLC

MayerSoft.Web.Controls.NewsScroller Two asp.net server controls: NewsScroller scrolls content in a box, and Display shows content with transitions. Declarative or code-behind content. Display and NewsScroller controls (2 in 1) MayerSoft.Web.Controls.Display...

New software

Popular software

Current software picks