Thursday, May 29, 2014

Control Text Direction in Shapes including Spreadsheet Comments in Android Apps

What’s new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android v8.0.0. There are some valuable features in this month’s release. Aspose.Cells for Android 8.0.2 provides getter & setter attributes for the TextDirection method in the Shape class. The API now lets developers control the direction of the text in shapes including the spreadsheet comments. The setTextDirection method accepts a value from the constants TextDirectionType, and applies the text direction as Left to Right, Right to Left or to Context. Another notable enhancement has been made to the HtmlLoadOptions class by exposing the Boolean ConvertFormulasData attribute. Setting this property to true when using the setConvertFormulasData method allows the API to interpret any string value starting with character “=” as a formula. Aspose.Cells for Android 8.0.2 has provided fixes for several important issues, such as rendering & manipulating charts, converting Excel to PDF format and rendering and manipulating PivotTables. This release includes plenty of improved features and bug fixes as listed below
  • Support custom theme for shape properties
  • Set Rendering Hints for Images while Exporting Spreadsheets to HTML
  • Fixed issue for Chart with gradient colors and now rendered correctly
  • Range referring issue is resolved and now referring to correct area
  • WorkbookRender.toPrinter() method now properly print picture
  • Pivot Column Grand problem is resolved while rendering XLTX to PDF
  • Cell alignment issues are resolved in the rendered PDF file
  • Converting Excel file with large number of columns into PDF file
  • AutoFitColumns is now working when used with different font settings
  • Cursor still move to last column after using Cells.DeleteColumn() to delete it is now fixed
  • Generated EMFshape is not same as the original is now fixed
  • Excel bookmarks are now generated when converted to PDF
Other most recent bug fixes are also included in this release

Overview: Aspose.Cells for Android
Aspose.Cells for Android is a MS Excel spreadsheet component that allows programmer to develop android applications for reading, writing & manipulate Excel spreadsheets (XLS, XLSX, XLSM, SpreadsheetML, CSV, tab delimited) and HTML file formats without needing to rely on Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, custom charts, spreadsheet formatting, drawing objects like images, OLE objects & importing or creating charts.


Thursday, May 8, 2014

Identity Corrupt Excel Files & Memory Optimization for Worksheets in Android Apps

What’s new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android v7.0.0. Aspose.Cells for Android provided memory optimization settings for newly created worksheets by exposing the setMemorySetting method for the Workbook.Settings class. The previously provided approach was useful for minimizing the overall memory cost while working with existing large Microsoft Excel spreadsheets containing huge datasets. With release 7.0.0, we have enhanced this feature for existing worksheets by exposing a similar method for the Cells class. Now you may use setMemorySetting method provided by the Cells class to cope with the memory issues for situations where large data sets have to be built in memory. The setMemorySetting method accepts a parameter of type MemorySetting with the default value NORMAL. In order to properly utilize this newly introduced feature, memory optimization settings have to be explicitly specified for existing worksheets. Please check the detailed technical article on how to optimize the memory while working with large data sets from our documentation. We have also enhanced the CellsException class to identify potentially damaged or corrupted files when loaded with the Workbook constructor. With the new enhancements integrated, Aspose.Cells for Android API now throws an error of type CellsException whenever it encounters a damaged file. Aspose.Cells for Android 7.0.0 has also provided fixes for several important issues. For example, problems with converting Excel files to PDF format, rendering & manipulating charts, retrieving & removing OLE objects. Moreover, we have improved the overall performance as well as the accuracy of results for the formula calculation engine when working with Excel formulas. This release includes plenty of improved features and bug fixes as listed below
  • Search license according to cells jar or application jar's position
  • How to identify corrupt excel file (2007)
  • .PPT converted to empty Pdf by Aspose.Cells
  • Missing characters resolved when converting from XLSX to PDF
  • Calculation formulas
  • OleObjectCollection.removeAt() now properly remove the OLE object
  • Text is grabbling fixed in resultant PDF when text overflows a cell
  • Memory issues  are resolved when using Aspose.Cells
  • Picture format changes to default values after opening and saving xlsm file
  • setCreateCalcChain(true) – Cells are now updated
  • Border and wrap text issue is fixed
  • Legend of chart and title of Y axis are now corrected in the output image
  • hashCode calculation issues are fixed and does match for the cells
Other most recent bug fixes are also included in this release.

Overview: Aspose.Cells for Android

Aspose.Cells for Android is a MS Excel spreadsheet component that allows programmer to develop android applications for reading, writing & manipulate Excel spreadsheets (XLS, XLSX, XLSM, SpreadsheetML, CSV, tab delimited) and HTML file formats without needing to rely on Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, custom charts, spreadsheet formatting, drawing objects like images, OLE objects & importing or creating charts.

Identity Corrupt Excel Files & Memory Optimization for Worksheets in Android Apps

What’s new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for Android v7.0.0. Aspose.Cells for Android provided memory optimization settings for newly created worksheets by exposing the setMemorySetting method for the Workbook.Settings class. The previously provided approach was useful for minimizing the overall memory cost while working with existing large Microsoft Excel spreadsheets containing huge datasets. With release 7.0.0, we have enhanced this feature for existing worksheets by exposing a similar method for the Cells class. Now you may use setMemorySetting method provided by the Cells class to cope with the memory issues for situations where large data sets have to be built in memory. The setMemorySetting method accepts a parameter of type MemorySetting with the default value NORMAL. In order to properly utilize this newly introduced feature, memory optimization settings have to be explicitly specified for existing worksheets. Please check the detailed technical article on how to optimize the memory while working with large data sets from our documentation. We have also enhanced the CellsException class to identify potentially damaged or corrupted files when loaded with the Workbook constructor. With the new enhancements integrated, Aspose.Cells for Android API now throws an error of type CellsException whenever it encounters a damaged file. Aspose.Cells for Android 7.0.0 has also provided fixes for several important issues. For example, problems with converting Excel files to PDF format, rendering & manipulating charts, retrieving & removing OLE objects. Moreover, we have improved the overall performance as well as the accuracy of results for the formula calculation engine when working with Excel formulas. This release includes plenty of improved features and bug fixes as listed below
  • Search license according to cells jar or application jar's position
  • How to identify corrupt excel file (2007)
  • .PPT converted to empty Pdf by Aspose.Cells
  • Missing characters resolved when converting from XLSX to PDF
  • Calculation formulas
  • OleObjectCollection.removeAt() now properly remove the OLE object
  • Text is grabbling fixed in resultant PDF when text overflows a cell
  • Memory issues  are resolved when using Aspose.Cells
  • Picture format changes to default values after opening and saving xlsm file
  • setCreateCalcChain(true) – Cells are now updated
  • Border and wrap text issue is fixed
  • Legend of chart and title of Y axis are now corrected in the output image
  • hashCode calculation issues are fixed and does match for the cells
Other most recent bug fixes are also included in this release.

Overview: Aspose.Cells for Android

Aspose.Cells for Android is a MS Excel spreadsheet component that allows programmer to develop android applications for reading, writing & manipulate Excel spreadsheets (XLS, XLSX, XLSM, SpreadsheetML, CSV, tab delimited) and HTML file formats without needing to rely on Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, custom charts, spreadsheet formatting, drawing objects like images, OLE objects & importing or creating charts.