• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Junilu Lacar
  • Liutauras Vilda
  • Paul Clapham
  • Jeanne Boyarsky
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
  • Jesse Duncan
  • Frits Walraven
  • Mikalai Zaikin

Apply 3D Chart Effects with Enhanced Formula Calculation Engine

Ranch Hand
Posts: 714
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 "dd.mm.yyyy"
- 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
    Bookmark Topic Watch Topic
  • New Topic