This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Blatant Advertising and the fly likes Apply 3D Chart Effects with Enhanced Formula Calculation Engine Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Other » Blatant Advertising
Bookmark "Apply 3D Chart Effects with Enhanced Formula Calculation Engine" Watch "Apply 3D Chart Effects with Enhanced Formula Calculation Engine" New topic

Apply 3D Chart Effects with Enhanced Formula Calculation Engine

sherazam khan
Ranch Hand

Joined: Mar 10, 2010
Posts: 279
What is new in this release?

The long awaited version of Aspose.Cells for .NET 4.9.0 has been released. It includes many new features like support is added for MS Excel 2010 Sparklines feature, implementation of 3D effects for MS Excel 2007 Charts and calculation of formulas that exceed MS Excel 2003 row/column limitation etc. This release includes plenty of new and improved features as listed below

- Calculates formulas that exceed Excel2003 row/column limitation
- Supports MS Excel 2010 Sparklines.
- Implements 3D effects on charts
- Removes Duplicate values
- Supports Allow Users to Edit Ranges
- The Formula Calculation Engine is enhanced
- Detects and removes connections to external data
- Sets linked picture in xlsx file
- Includes ICustomTypeDesciptor as data source of smart markers
- External linked source data in Chart to Image feature is supported
- MS Excel 2007 external page setup options in xls file are supported
- Specifies HTML content as the cell's value or comment's note
- 112 fixes and other enhancements.
- Adds new date formats: "M/d/yy", "MM/dd/yyyy" and ""
- Sets error message in the cell’s title when validation is failed at client side
- Gets column name for a cell at client side
- Saves Excel files to stream or loads Excel files from stream
-Supports new functions: INDEX, LOOKUP, MATCH
- 8 fixes and other enhancements.
- Sets "MM/DD/YYYY" and "M/D/YYYY" date formats with Format Cells dialog box
- Imports CSV file format
- Supports formulas: LOOKUP, MATCH

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for .NET documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Populate Data first by row then by column:
- Format Worksheet Cells in a Workbook:

Overview: Aspose.Cells for .NET

Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects and importing or creating charts. You can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, SpreadsheetML, PDF and all file formats from Excel 97 to Excel 2007.

More about Aspose.Cells for .NET

- Homepage of Aspose.Cells for .NET:
- Product Overview of Aspose.Cells for .NET:
- Online documentation of Aspose.Cells for .NET:
- Demos of Aspose.Cells for .NET:
- Post your technical questions/queries to Aspose.Cells for .NET Forum :
- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for .NET blog :

Contact Information
Suite 119, 272 Victoria Avenue
Chatswood, NSW, 2067
Aspose - The .NET and Java component publisher
Phone: 888.277.6734
Fax: 866.810.94651
It is sorta covered in the JavaRanch Style Guide.
subject: Apply 3D Chart Effects with Enhanced Formula Calculation Engine
Similar Threads
Create Large XLSX Files Using LightCells APIs & Check Empty Columns
Reading HTML/ODS Files & More Enhanced Options for Copying Worksheets
Interrupt Component While Working With Large File & Chart to Image
Render Charts in Excel to PDF & Advanced Conditional Formatting
Aspose.Cells Now Fully Support MS Excel 97 to 2003 & 2007 Formats