MayerSoft.Web.Controls.Spreadsheet 1.0
spreadsheet templates on a web page
| Details |
View: screenshot
Size: 125.02 KB
License: Commercial
OS: Windows2000,Windows2003
Price: $19.95
Publisher: MayerSoft LLC
|
Date added: 6/18/2005
Date updated: 12/2/2005
Total Downloads: 214
Downloads - Last Week: 0
|
|
MayerSoft.Web.Controls.Spreadsheet 1.0 Publisher's 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!
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
|
| Antivirus information |
|
Download3K did not scan MayerSoft.Web.Controls.Spreadsheet for viruses, adware, spyware or other badware. For your own safety, we recommend that you always have an antivirus, with virus definitions up to date, installed on your computer when downloading and installing programs from the web.
|
| Related press releases |
Aspose.Cells is an XLS Java Spreadsheet SDK for spreadsheet reporting [2007-09-24 03:28:13]
Aspose.Cells is an XLS Java Spreadsheet SDK for spreadsheet reporting without using Microsoft Excel. Other useful features include formula settings, macros, VBA, unicode, hyperlinks, pivot tables, ope...
|
|
Aspose.Excel 3.5 released! [2005-09-26 00:00:00]
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 M...
|
|
Aspose.Excel 3.4 released! [2005-08-24 00:00:00]
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 M...
|
|
Microsoft Excel like spreadsheets online [2006-02-15 00:00:00]
Convert Microsoft Excel spreadsheet into good-looking calculating web page. No plugins. No programming needed.
So many uses: as versatile as Excel!
- Create web-based online calculators
- C...
|
|
Williams Controls, Inc. Completes Successful Implementation of I-PROCESS® Engine... [2004-09-18 00:00:00]
Oregon company has completed successful implementation of engineering change automation software.
Portland, OR January 21 2004 -- Acuity Incorporated, a provider of Product Lifecycle Management soft...
|
|
Data Management Software releases a web based spreadsheet application [2005-08-15 00:00:00]
Data Management Software (http://www.damaso.org) has unveiled the early version of its interactive spreadsheet application on Monday, August 15, 2005. The new software package provides increased flex...
|
|
SpreadsheetGear Adds More Microsoft Excel Compatible Charting, Data, Formatting,... [2009-06-18 13:30:43]
LENEXA, KS, June, 2009 - Today, SpreadsheetGear LLC announced the immediate availability of SpreadsheetGear 2009. With one safe managed assembly, SpreadsheetGear 2009 enables developers to easily add...
|
|
Compile Microsoft Excel spreadsheets into Java [2005-11-02 00:00:00]
SpreadsheetConverter to Java/JSP compiles Microsoft Excel spreadsheets into Java-code.
Version 3.5 is released. More Excel functions are supported. We have improved conversion speed, and reduced siz...
|
|
ICreate releases beta version of RAD .NET controls [2005-09-02 00:00:00]
ICreate is excited to announce the beta release of some if its RAD .NET components. These components not only speedup the development of WinForm applications, they also enable you to give them a fresh...
|
|
SmartMove 1.0 for Microsoft Excel® [2007-10-18 22:44:13]
ROCHESTER, MICHIGAN, OCTOBER 16, 2007 -- PatLee Corp. announces the release of SmartMove 1.0, a user-friendly tool to make transferring data into Microsoft Excel® faster than ever.
SmartMove, power...
|
|
|
|
| Habanero |
 An Enterprise Application Framework for .Net that produces an agile application from the data layer through to the front-end. Free open source under the LGPL license, it includes ORM and UI generation to create one application for the desktop & web. |
|
| DynaPlot |
 DynaPlot is a real-time ActiveX chart control for technical applications. It features dynamic scaling of chart elements with control size, tolerance masks, built-in tools like cursors, markers, scroll, pan, zoom... |
|
| absolutePDF-Creator Easy |
 absolutePDF-Creator Easy is a easy to use ActiveX COM Control that enables you to create PDF files from within your Windows applications. Import existing PDF. Can be used with any ActiveX COM aware programming environment. |
|
| VintaSoftTwain.NET Library |
 Control a scanner or camera from your .NET application. VintaSoftTwain.NET Library allows to control the image acquisition process, use automatic documents feeder, save acquired images to disk or into SQL database, upload them to Web or FTP servers. |
|
| QuickUML Windows |
 QuickUML is a software design tool that tightly integrates a core set of UML models with code generation. A project is presented through a tabbed window of use cases, class models, object models, dictionary and code and saved as an XML file. |
|
| Vbs2Exe |
 With Vbs2Exe you can compile your scripts and batch files to standalone executables, the easy to use interface provides a simple way to protect your scripts before you distribute them to your clients. |
|
| Hex Workshop |
 Hex Workshop is a set of hexadecimal development tools for Windows that combines advanced binary editing with the ease and flexibility of a word processor. |
|
|
Software Development
