Author Archives: Laurence

Aspose.Cells for .NET V4.4 Released!

What’s New?

3208 – Allows to delete defined names from template files

3637 – Support to create an encrypted Excel file from scratch

What’s Improved?

3631 – Writes the formula calculation result back to file

3632 – Chart2image conversion enhancement

3639 – Xls2pdf feature enhancement

3640 – Support to set vertical text in text box

What’s Fixed?

3179 – Chart PlotArea setting bug 

3199 – AutoFitRow bug for some bold font 

3641 – Bug in calculating Indirect and Address function … Continue Reading

Posted in Aspose.Cells Product Family |

Aspose.Cells for Reporting Services V1.0.2.0 Released!

What’s New?
  

  •   Supported to export list
  •   Supported to export subreport


What’s Fixed?

  •   Fixed the bug when textbox value contains number format. 
  •   Fixed the bug when the RDL file contains table

Download URL:

http://www.aspose.com/Community/Files/52/aspose.cells.reporting.services/entry92511.aspxContinue Reading

Posted in Aspose.Cells Product Family |

Aspose.Cells for Reporting Services v1.0.1 Released

Introduction

 

Aspose.Cells for Reporting Service v1.0.1 includes feature  enhancement and bug fixes since

the first release.

 

What’s New?

 

  • Supported to export matrix
  • Supported to export CSV and TabDelimited file
  • Supported the background image.

  

What’s Fixed?

  • Fixed the bug when image.ImageData is null.
  • Fixed the bug when textbox value contains numberformat.
  • Fixed the bug when matrix is grouped.

  

Download URL:

http://www.aspose.com/Downloads/Aspose.Cells.Reporting.Services/Default.aspxContinue Reading

Posted in Aspose.Cells Product Family |

Aspose.Cells for Reporting Services V1.0.0 Released!

Introduction

Aspose.Cells for Reporting Services allows you to deliver native Excel reports in Microsoft SQL Server 2005 Reporting Services. Unlike the built-in renderer for Excel based reports, Aspose.Cells for Reporting Services provides an extended feature set and allows RDL reports to be converted to: Excel 97-2003 binary XLS format, SpreadsheetML or the Excel2007 XLSX format.
 
Download URL:
 http://www.aspose.com/Downloads/Aspose.Cells.Reporting.Services/Default.aspxContinue Reading
Posted in Aspose.Cells Product Family |

Aspose.Cells for .NET V4.3 Released

Introduction

This release contains new features, features enhancement and bug fixes since v4.2.  Please check following description for more detail information.

What’s New?

3136 – Support to import/export Excel2007 Data/Formattings

What’s Improved?

3155 – Support  header and footer page setup settings in xls2pdf conversion

3170 – Support CELL function in formula calculation engine 

3175 – Shape Chart2image feature in 2D Bar, Column, Line and Pie chart

What’s Fixed?

3064 – Xls2Pdf conversion exception bug

3065 – CheckBox setting problem

3066 – Conditional … Continue Reading

Posted in Aspose.Cells Product Family |

Format Worksheet Cells in the Workbook

Purpose

This article is designed to provide the developers with a detailed perceptive on how to create a workbook to input data into a worksheet and apply some formatting to the cells in the rows and columns of the worksheet using Aspose.Cells component.

In this Article

Here is a quick look what the article is all about:

Working with Worksheet Formatting

  • Using Styles to quickly Format data
  • Formatting Cells in Rows and Columns
  • Using Borders and Colors to emphasize data
Continue Reading
Posted in Aspose.Cells Product Family | Tagged ,

Convert an Excel Chart To Image

Purpose

This document is designed to provide the developers with a detailed understanding on how an excel chart can be exported as an image.

Introduction

Charts are visually appealing and make it easy for users to see comparisons, patterns, and trends in data. For instance, rather than having to analyze several columns of worksheet numbers, you can see at a glance whether sales are falling or rising over quarterly periods, or how the actual sales compare to the projected sales. … Continue Reading

Posted in Aspose.Cells Product Family | Tagged ,

Aspose.Cells for .NET v4.2 Released!

Dear Customers:

We have released Aspose.Cells for .NET v4.2!

In this new version, some important new features are added:

  • Now Aspose.Cells totally supports to manipulate charts, images and other drawing objects in template files
  • Chart2Image feature is supported.Currently only Column, Line, Pie and Bar charts are supported. And only 2D charts are supported. We will support more chart types in the future versions.
  • Xls2Pdf conversion is enhanced and optimized.
  • Formula calculation engine is enhanced and optimized.
Continue Reading
Posted in Aspose.Cells Product Family |

Aspose.Cells for .NET v4.1.2 released!

Dear Customers,

We have released Aspose.Cells for .NET v4.1.2!

  • F0008: Enhanced formula calculation engine
  • F0014: Added CheckBox.Value property
  • F0025: Added feature to convert image in Excel file to Pdf file
  • F0031: Supported more functions while reading formula from file
  • B0009: Fixed a bug about merged cell while converting to pdf file
  • B0010: Fixed a bug about StandardWidth property
  • B0011: Fixed a bug in concatenating ASCII characters between code 128-255
  • B0012: Fixed a CopyConditionalFormattings bug
  • B0013: Fixed InsertRows/InsertColumn method doesn’t update Print_Area
Continue Reading
Posted in Aspose.Cells Product Family |

Aspose.Cells for .NET V4.1.1 Released!

Dear Customers,

We have released Aspose.Cells for .NET v4.1.1!

  • Enhanced WebForm demos
  • F0007: Supported NPV function in formula calculation engine
  • F0009: Supported to read textboxes string in template files
  • F0015: Supported BIFF7 encryption in some protected files
  • F0016: Supported INDIRECT, ISBLANK, ISERROR, ISNA, ISNUMBER function in formula calculation engine
  • F0017: Supported German datetime format string
  • F0019: Supported to set active cell in a worksheet
  • B0001: Fixed a bug in Cells.MaxDataRowInColumn property
  • B0002: Fixed a bug when loading csv files with blank
Continue Reading
Posted in Aspose.Cells Product Family |