Aspose.Cells for Java Changelog

What's new in Aspose.Cells for Java 8.1.0

Jun 6, 2014
  • Enhancements:
  • Restrict the API to use the fonts directory specified using CellsHelper.setFontDir method
  • lines of diagram are not crisp/sharp
  • Get display color defined in custom number format
  • Bugs:
  • Some colors are shown just before column in one table
  • Images are missing in resultant PDF when spreadsheet is converted on Ubuntu
  • Gridlines and Font settings are missing in the output HTML
  • Unable to set print quality of worksheets
  • PrintCopies are preserved for XLS format but not for XLSX format
  • Exceptions:
  • Saving Pivottable as mht
  • CellsException: Map size (0) must be >= 1
  • Public API and Backwards Incompatible Changes:
  • The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for Java. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.
  • Obsoletes BuiltInDocumentPropertyCollection.Bytes/Characters/CharactersWithSpaces/Lines/Paragraphs properties
  • Those properties are written for Word and PowerPoint, Excel will omit them.
  • Adds Cell.StringValueWithoutFormat property
  • Gets cell's value as string without any format.
  • Adds HtmlSaveOptions.ExportHiddenWorksheet property
  • Indicating whether export the hidden worksheet content when saving html file. The default value is true.

New in Aspose.Cells for Java 8.0.0 (Mar 27, 2014)

  • Major Features:
  • Memory usage option can be used for performance consideration.
  • When building workbook with large cells data set, MemorySetting.MEMORY_PREFERENCE option may optimize memory usage for cells data to decrease the memory cost.
  • Other Improvements and Changes:
  • New Features:
  • Get Starting Row/Column and Ending Row/Column indexes for a page of worksheet
  • Support for Show Formulas MS Excel feature
  • Aspose.Cells and Maven dependencies
  • Set the creation time in the generated PDF
  • Enhancements:
  • Typo in method name - SeriesCollection.setSecondCategoryData
  • Custom Series DataLabel Separator
  • Cell.DisplayStringValue did not calculate accurately for spaces determined by column width and '*' in style's custom
  • Bugs:
  • setExportActiveWorksheetOnly change align of table in HTML
  • Background image isn't copied to destination workbook when calling Workbook.copy
  • Text inside an image appears to be Mirrored while saving an excel workbook as PDF
  • Some words are separated when saving to PDF
  • Table autofilter does not work in xls format but works fine in xlsx format
  • When export to HTML, cells covered by image loses background color
  • Background image path is not correct
  • Vertical text issue
  • Formatting issue of shapes/controls in Excel to PDF conversion
  • Incorrect wrapping of Axis Labels when converting XLSX to PDF
  • DateTime columns incorrectly read from CSV with European locale
  • Image output mirrored while transforming an excel worksheet into PDF
  • Apose.Cells: embedded sigma plot chart not rendered correctly to PDF/images
  • Incorrect wrapping of Axis Labels when converting XLSX to PDF
  • Data is not correct in the output pdf
  • Cell.getDependents(true) issue - Cells from other sheets that shouldn't be in the list
  • CellsException: null at Workbook.calculateFormula(false)
  • Background image path is not correct
  • Export Shapes to html with error background color
  • XLSX to HTML: Problem with hideColumn producing Null values in HTML
  • Recalculation cell's formula
  • Exceptions:
  • com.aspose.cells.CellsException: Invalid cell name
  • - NullpointerException when saving a book
  • CellsException: Overflow in String to int conversion. String value: #N/A.
  • CellsException: Shape to image Error!
  • Public API and Backwards Incompatible Changes:
  • The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for Java. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.
  • Obsoletes AutoFilter.FilterColumnCollection property
  • Uses AuotFilter.FilterColumns instead.
  • Adds Worksheet.ShowFormulas property
  • Indicates whether showing formulas or value of the formulas.
  • Adds PdfSaveOptions.CreatedTime property
  • Gets and sets the time of generating the pdf document.
  • Adds FileFormatType.Ooxml enum
  • Represents encrypted office open xml file(such as xlsx, docx,pptx, etc).
  • Adds LoadOptions.MemorySetting property and WorkbookSettings.MemorySetting property
  • From this version we provide memory usage option for user for performance consideration. The default option MemorySetting.NORMAL is applied for all versions. For some situations such as building workbook with large data set for cells, MemorySetting.MEMORY_PREFERENCE option may optimize the memory usage and decrease the memory cost for user's application. However, this option may degrade performance in some special cases such as accessing cells randomly and repeatedly.
  • Obsoletes SeriesCollection.SecondCatergoryData property and adds SeriesCollection.SecondCategoryData property
  • Uses SeriesCollection.SecondCategoryData to replace SeriesCollection.SecondCatergoryData.
  • Implementations of Row/Cell/RowCollection is changed
  • In old versions, Row and Cell objects are kept in memory for representing corresponding row and cell in a worksheet.
  • The same instance will be returned whenever user call methods such as RowCollection[int index], Cells[int, int] and so on.
  • For memory performance consideration, from this version on only properties and data of Row and Cell will be kept in memory.
  • Row/Cell object become the wrapper of those properties and data for user's convenience to manipulate cells model
  • and will be newly instantiated when user call those methods.
  • So, now user will get different objects when calling the same method to get Row/Cell many times
  • even though those different objects all refer to the same row/cell in the worksheet.
  • This change may affect user's application for following situations:
  • If user used code like:
  • if(row1==row2)...
  • if(cell1==cell2)...
  • to check the same Row/Cell, with new versions those checks may fail. Please use row1.equals(row2) and cell1.equals(cell2) instead.
  • Because Row/Cell objects are newly instantiated according to user's invocation, they won't be kept and managed in memory by cells component.
  • After some inserting/deleting operations, their position(row/column index) may not be updated or even worse, those objects become invalid. For example, for following code:
  • Cell cell = cells.get("A2");
  • System.out.println(cell.getName() + ":" + cell.getValue());
  • cells.insertRange(CellArea.createCellArea("A1", "A1"), ShiftType.DOWN);
  • System.out.println(cell.getName() + ":" + cell.getValue());
  • with old versions, the cell will refer to A3 after the insert operation and its value is same with the one before insert.
  • However, with new version the cell object will become invalid or still refer to A2 with other value.
  • For such kind of situation, user needs to get Row/Cell object again from cells collection to get the correct result:
  • Cell cell = cells.get("A2");
  • System.out.println(cell.getName() + ":" + cell.getValue());
  • cells.insertRange(CellArea.createCellArea("A1", "A1"), ShiftType.DOWN);
  • cell = cells.get("A3");
  • System.out.println(cell.getName() + ":" + cell.getValue());
  • RowCollection now does not inherit CollectionBase because there is no Row object in its inner list anymore:
  • Cell.StringValue is changed for special formatting pattern with '*' and '_'
  • In old versions, special pattern '_' will be ignored when formatting cell value for Cell.StringValue
  • and '*' always produces one character into the formatted result.
  • From this version we change the logic of doing with '_' and '*' to make the formatted result same as what you can get from ms excel
  • when copy a cell as text(such as copying a cell to a text editor or export the cell to csv).
  • For example, use the custom "_($* #,##0.00_)" to format cell value 123,
  • with old versions Cell.StringValue will give the result as "$ 123.00".
  • Now with new versions Cell.StringValue will give result as " $123.00 " which is same with what you can get from ms excel by copying this cell to text.

New in Aspose.Cells for Java 7.7.2 (Feb 17, 2014)

  • New Features:
  • Print comments on an Excel document
  • Support Justify Distributed Alignment Setting
  • Enhancements:
  • Remove hardcode usage of com.sun.image.codec.jpeg.JPEGCodec
  • Unhide Row with previously assigned height
  • Bugs:
  • Axis.setTickLabelSpacing() is not working for XLS version
  • Cell borders were rendered on opaque cells
  • Less than equals to calculation error
  • Problem with wildcard parsing in formula calculation
  • Some columns are narrow to contain text properly
  • IStreamProvider.setCustomPath not effect to file tabstrip.htm
  • Extracting formatted Chinese Date issue
  • getStringValue() returns #VALUE!
  • Validation not working after converting to XLS format
  • XLSX to PDF: Underline below the hyperlink is getting spread out to adjacent character positions
  • Exceptions:
  • Exception when opening xlsx converted to xls
  • Exception when opening xlsx converted to xls
  • CellsException: Invalid cell name on Workbook constructor
  • Rendering cuased com.aspose.cells.CellsException: java.lang.String cannot be cast to java.lang.Double
  • com.aspose.cells.CellsException on SheetRender
  • Exception: java.lang.NullPointerException in rendering charts in a worksheet

New in Aspose.Cells for Java 7.6.1 (Nov 16, 2013)

  • Enhancements:
  • The dependency of dom4j library has been removed. So dom4j-1.6.1.jar can be excluded from the ClassPath when using Aspose.Cells component.
  • Workbook.getWorksheets().setOleSize is not working as expected
  • License issue (CellsException: Cannot find black listed licenses resource)
  • Missing Permissions manifest attribute message after JRE 1.7 u45 upgrade
  • Using Aspose.Cells in an OSGi environment
  • Exceptions:
  • File throws exception on opening it
  • Problems when trying to convert the document to PDF
  • CellsException: Invalid data source
  • NullPointer Exception while opening MS Excel file
  • Bugs:
  • Drawings disappear in the output PDF
  • Problem rendering spaces at different resolutions
  • Wrong value in VerticalAlignment when using XML Spreadsheet
  • DateTime returned for XLSM document’s properties is incorrect
  • Sparklines custom axes are not working
  • Charts are getting cut off while printing

New in Aspose.Cells for Java 7.6.0 (Nov 16, 2013)

  • New Features:
  • Saving Excel sheet with a few cells selected
  • Place image to the header (only for the first page)
  • Create STRAIGHT_CONNECTOR in MS Excel 2003 format
  • Enhancements:
  • GB18030 Characters do no display
  • Chart Quality is too low
  • Copying sheet lost ActiveX control’s properties and the control becomes a simple shape control
  • Setting image quality does not have any effect
  • Exceptions:
  • NullPointerException when opening Excel spreadsheet
  • NullPointerException while Chart to Image transformation
  • “java.lang.NegativeArraySizeException” in SheetRender
  • Excel template file not loading
  • Bugs:
  • Workbook has Worksheets with duplicate CodeNames
  • Deleting chart causes unreadable spreadsheet
  • SheetRender.toImage() with ImageFormat.getJpeg() returns PNG image file
  • Can't resize Textbox in XLSX
  • “#VALUE!” error after Calculation
  • calculateFormula() does not work for INDEX function
  • Error executing replace in text box
  • The image shrank resolution increases and expands when decreases

New in Aspose.Cells for Java 7.5.3 (Nov 16, 2013)

  • Bugs:
  • Method called workbook.calculateFormula() fails to calculate
  • Saving copy of XLSX file results in unreadable content
  • Refreshing PivotTable issue with the saved file

New in Aspose.Cells for Java 7.5.2 (Aug 19, 2013)

  • New Features:
  • 40579 – Support using a cell address with $ to build CellArea
  • Enhancements:
  • 40467 - Automatic resizing of Textbox with respect to its contents
  • 40589 - Add icon sets (conditional formatting)
  • Exceptions:
  • 40527 - Generic CellsException while converting to PDF format
  • Bugs:
  • 40567 - Inserting rows and copying cells does not work for Array formulas
  • 40553 - Rendering Excel to PDF does not render Charts with JDK1.7.0_21
  • 40557 - Chart problem: output file does not equal to input file
  • 40568 - Charts and data in the sheet for PivotTable are not rendered fine in the generated PDF
  • 40576 - Results are different when pivot table is refreshed manually and with Aspose.Cells
  • 40584 - When copying cells containing an array formula ABOVE the original row results in a corrupt Excel file
  • 40578 - Inserting rows and copying cells does not work for Array formulas II
  • 40581 - References lost when calling Cells.copyRow() method

New in Aspose.Cells for Java 7.5.1 (Jul 23, 2013)

  • New Features:
  • 40566 - Insert a picture based on cell reference
  • 40546 - Detect category type of cell's number formatting
  • 40542 - Cell type returns numeric even if it's a String
  • Exceptions:
  • 40550 - Exception on document load
  • 40545 - Not able to open the Excel file
  • 40552 - Exception:java.lang.IndexOutOfBoundsException on opening an XLSX file
  • 40549 - Chart is missing in PDF Output
  • 40558 - Exception caused by JDK1.7 version (Chart to Image)
  • 40556 - Exception caused by JDK1.7 version (Sheet to Image)
  • Bugs:
  • 40514 - Chart legend text overlapping
  • 40512 - Pivot table’s refresh problem when Excel has special characters (other language)
  • 40540 - Excel has unreadable content after refreshing PivotTable and re-saved the file
  • 40535 - URLs in the Excel file are altered in the generated PDF
  • 40488 - Issue with passing in empty value into a Chart Series
  • 40547 - Chart to Image Quality is not good
  • 40555 - Refreshing the PivotTable issue

New in Aspose.Cells for Java 7.4.2 (Mar 28, 2013)

  • Enhancements:
  • 40427 - Export HTML files to user specified streams
  • 40449 - Get locale-based Date format for MS Excel’s built-in number formats
  • 40464 - Copy Macros when copying workbooks
  • Exceptions:
  • 40465 - com.aspose.cells.CellsException: Shape to image Error!
  • 40456 - IndexOutOfBoundsException is thrown when performing a Workbook.copy() operation
  • Bugs:
  • 40447 - Interesting image filenames in the generated HTML
  • 40463 - Image height stretching when adding to Excel’s sheet
  • 40466 - Formula was calculated incorrectly
  • 40462 - Textbox characters are not working correctly

New in Aspose.Cells for Java 7.4.0 (Jan 30, 2013)

  • New Features:
  • 40413 - Support custom encoding for saving HTML file
  • Bugs:
  • 40380 - Incorrect formula calculation results
  • 40414 - Data source of the chart was changed after combining workbooks

New in Aspose.Cells for Java 7.3.5 (Jan 11, 2013)

  • New Features:
  • 40382 - Add new methods: Validation.getValue1() and Validation.getValue2() for getting DateTime values
  • 40408 - Support Sparklines rendering for PDF format
  • Enhancements:
  • 40343 - Include new option: PdfSaveOptions.CheckFontCompatibility for improving performance of saving PDF file
  • 40385 - Getting java.lang.IllegalArgumentException: Arg_DateTimeRange when calling Cell.putValue(value, true) where the value represents date/time
  • 40370 - Conditional formatting formulas don't differentiate between String and Numbers
  • 40394 - Support to read Theme color for sheet tab color from an XLS file
  • 40295 - Support to write RTL in PDF rendering
  • 40312 - DisplayRightToLeft problem
  • Exceptions:
  • 40397 - OutOfMemory error when re-saving an XLSX file with conditional formatting
  • 40401 - CellsException when saving as PDF
  • Bugs:
  • 40377 - Cropping effect in the pictures was lost for Shape-to-Image feature
  • 40383 - Only the first RadioButton in a GroupBox has linked cell
  • 40379 - Inconsistent results with CalculateFormulas method
  • 40375 - Vlookup with a Lookup_value range was not working
  • 40392 - Shapes in group were removed after ungroup
  • 40350 - Support SmartArt for Shape-to-Image feature
  • 40377 - Cropping of pictures was incorrect for Shape-to-Image feature when shape was re-sized
  • 40396 - Rows became hidden when viewing the re-saved XLS file (by Aspose.Cells) in OpenOffice
  • 40384 - "#Recursive Reference!" error in formula calculations
  • 40388 - DataLabels were shown for XLS file format but not for XLSX
  • 40402 - Series’ Axis was shown for XLS file format but not for XLSX
  • 40389 - Periods were inserted in lines with Courier font type
  • 40386 - Shape.toImage() hanged for indefinite time
  • 40281 - Image truncated and color different while converting Excel to PDF
  • 40406 - Problem with converting Excel file with large number of columns into PDF file

New in Aspose.Cells for Java 7.3.3 (Oct 30, 2012)

  • New Features:
  • 40333 - Add Row.getLastDataCell() method to get the last cell having data in a row
  • 40345 - New APIs added for getting same Style object for cells with the same style settings
  • Enhancements:
  • 40334 - Add quotes to empty cell value(s) when exporting a CSV with TxtValueQuoteType.ALWAYS option
  • Exceptions:
  • 40335 - Conditional formatting with Unicode characters fails
  • 40348 - Setting formula before adding areas for conditional formatting and then renaming worksheet caused an error when saving workbook
  • 40349 - Re-saving an XLS template file caused NegativeArraySizeException
  • Bugs:
  • 40340 - Formatted Date value was different from what is shown in MS Excel
  • 40318 - Chart series names are lost if CellCollection is cleared
  • 40341 - Displaying blank as gaps/zeroes does not work for XLSX files
  • 40342 - Data label formatting for charts is not fine
  • 40339 - Font underline disappeared in the rendered PDF file
  • 40347 - Setting font styles took no effect for XLSX in LightCells mode
  • 40344 - Part of footer was lost when saving to PDF

New in Aspose.Cells for Java 7.3.2 (Oct 10, 2012)

  • New Features:
  • 40300 - Shape.getRight()/getBottom() to get an offset of the shape from the right-bottom corner to the cell
  • 40330 - Set worksheet tab color to default color
  • Enhancements:
  • 40294 - Close internal streams for releasing memory resources in PDF conversion
  • 40310 - Copy Sparklines when copying worksheet
  • Exceptions:
  • 40306 - Opening an XLS file caused StackOverflowError
  • 40302 - Saving PDF caused Exception
  • 40308 - Worksheet.getFreezedPanes() caused NullPointerException
  • 40303 - Opening an empty XML file caused an exception
  • 40313 - Saving to PDF caused an exception -I
  • 40314 - Saving to PDF caused an exception -II
  • 40315 - Saving to PDF caused an exception -III
  • 40301 - Saving to PDF caused an exception -IV
  • 40304 - Exception when open HTM template file
  • 40322 - IllegalArgumentException when opening an XLS file
  • 40323 - NullPointerException when opening an XLS file
  • 40325 - ArrayIndexOutOfBounds exception when opening an XLS file
  • 40331 - Saving PivotTable caused ClassCastException after setting auto-sort
  • 40301 - Shape to image error when saving PDF using Aspose Cells
  • 40324 - CellsException when printing gridlines to PDF
  • Bugs:
  • 40297 - Some regions saved in the XLS templates could not be recognized when reading
  • 40292 - Chart- to-Image fails rendering the scale for Bar charts
  • 40284 - Data loss after conversion from XLSX to PDF
  • 40317 - Pie and Scatter charts don't work if Cell collection is cleared

New in Aspose.Cells for Java 7.3.0 (Jul 17, 2012)

  • New Features:
  • 40221 – Supports settings for Transition Formula Evaluation
  • Enhancements:
  • 40213 - Format cell values with user specified locale
  • Exceptions:
  • 40246 - Unsupported font files may cause saving to PDF failed with exception
  • Bugs
  • 40215 - Cell.setR1C1Formula() method did not work correctly without column offset
  • 40214 - Named range was created twice
  • 40217 - sortNames() method caused exception when saving an XLSM file
  • 40231 - Number was not formatted correctly for fraction
  • 40230 - Blank PDF generated for PrintOrderType.OVER_THEN_DOWN
  • 40232 - Background color and grids are incorrect in the generated PDF
  • 40224 - Intercept and Slope functions were not calculated correctly
  • 40235 - Remove 33k limit of Pivot field items for Excel 2007 file formats
  • 40240 - Notation 1:1 is not supported in IF function
  • 40241 - DATEDIF formula was calculated incorrectly
  • 40242 - Incorrect lookup of cells in case of named row

New in Aspose.Cells for Java 7.2.0 (Apr 13, 2012)

  • Enhancements:
  • 40055 - Maintain exact date format in reading CSV template files
  • Exceptions:
  • 40157 - Shape.getFillFormat() cause NullPointerException when saving to XLS file
  • Bugs:
  • 40492 - Cell references were changed when column names are in lower case
  • 40161 - Shape’s text was not wrapped fine as what is shown in MS Excel
  • 40167 - Transparency is changed from 100% to 0% after processing
  • 40168 - Chart become black after re-saving XLS file

New in Aspose.Cells for Java 7.1.2 (Apr 13, 2012)

  • New Features:
  • 40132 – Support Cells.importCustomObjects() method for importing POJO
  • Enhancements:
  • 40142 - Enhancements are made for autoFitColumns() methods
  • 40136 - Performance for Sheet-to-Image feature with gridlines on
  • Exceptions:
  • 40148 - NullPointerException occurred when calling Cell.getDisplayStyle() method
  • Bugs:
  • 40125 - Maximum value for Scatter chart cannot be set properly
  • 40146 - Text in shapes was lost or moved to out of shapes range in the generated PDF file
  • 40145 - Series name was not shown for Date Labels in the chart

New in Aspose.Cells for Java 7.1.1 (Feb 17, 2012)

  • New Features:
  • 40122 - Check whether a column is blank
  • Enhancements:
  • 40118 - Saving to XLSX with LightCells API by directly rendering to OutputStream
  • Exceptions:
  • 40121 - Cell.setHtmlString() method throws NullPointerException
  • 40131 - Reading an XLSX template file throws NullPointerException
  • Bugs:
  • 40116 - Secondary category axis of SCATTER chart become text axis
  • 40115 - Contents in Textbox have not been rendered correctly
  • 40124 - ROUND function cannot round a value greater than 922337.20
  • 40005 - Chart was not read correctly from ODS template file
  • 40126 - Custom Number format: "dd.MM.yyyy" was not saved correctly for ODS file
  • 40115 - LineShape become shorter in the generated PDF document

New in Aspose.Cells for Java 7.1.0 (Jan 19, 2012)

  • Enhancements:
  • 40090 - Delete template files after reading XLSX/ODS files with Apache's zip tool
  • Exceptions:
  • 40091 - Cell.setHtmlString() throws NullPointerException
  • Bugs:
  • 40066 - Cell contents disappeared from the generated PDF file
  • 40044 - Error message: "The pivot table was created in a later version of Excel…" while opening the file into MS Excel
  • 40088 - Sheet’s zoom is changed when opening an XLS template file
  • 40093 - Cell.getStringValue() gives incorrect value for double types
  • 40094 - When saving to PDF, the right part of shape's text is truncated and part of image lost
  • 40089 - Number format lost when saving to ODS file format

New in Aspose.Cells for Java 7.0.4 (Dec 21, 2011)

  • General Features / Improvements:
  • Support reading common HTML files
  • Read/Write advanced conditional formatting types for XLS files
  • Optimization is done for Cells.Merge() function regarding memory usage
  • Enhancements:
  • Set BigDecimal value as double for Cell.putValue() method
  • Provide more Copy options for copying worksheets
  • Load CSV file with user specified parsers
  • Support advanced formatting condition types introduced in Excel 2007 for XLS format
  • New API added: Range.getRefersTo()
  • "\n" char in the shape's text becomes square in the generated PDF document
  • Read Sort settings from template file for Auto-Filters
  • Include TxtLoadOptions.convertDateTimeData option
  • Support animated GIF images for ODS/HTML files
  • Read charts from ODS template file
  • Support to set colors that are not in the MS Excel 2003 standard palette for charts
  • Remove FILEPASS record when there is no password set
  • Exceptions:
  • Style.copy() and Cell.getR1C1Formula() may cause NullPointerException
  • Sheet-to-Image - it causes exception: java.lang.UnsupportedOperationException
  • FormatCondition.getFormula() causes Exception when there is no CellArea added
  • Setting TxtLoadOptions.ConvertNumericData to “false” will cause CSV file’s reading failed
  • Bugs:
  • Support to set locales for LoadOptions
  • Generated PDF document may cause Adobe Reader give error
  • Incorrect calculated value for the PRICE function
  • ISERROR function works incorrectly
  • Calculate COUNTIF function incorrectly
  • Problem with Array formulas
  • Reversed order for category value of a 3D Bar chart takes no effect using Chart-to-Image
  • Legend order is different from what is shown in MS Excel for Chart-to-Image
  • Auto-Fit Column function gives inconsistent results
  • Issue while saving custom filters (with AND/OR flag); Support R/W multiple-filters for XLS file
  • Generated Excel file gives error messages after adding Calculated Field to Pivot Table
  • Formulas are not calculated when opening generated XLSX file in MS Excel

New in Aspose.Cells for Java 7.0.3 (Dec 21, 2011)

  • General Features / Enhancements:
  • Support LightCellsDataProvider for saving XLS file
  • Enhancements are made for Excel-to-PDF feature
  • Include a useful method: PivotField.getBaseIndex()
  • Support to get all colors that are used by different objects in the Workbook
  • Exceptions:
  • Reading XLS template file with option set: LoadDataOnly=true gives exception
  • WorksheetCollection.getNamedRanges() method gives exception
  • Get an exception “Invalid password” when reading XLSX template file
  • Bugs:
  • Cell value with character '"' and ',' was saved incorrectly for CSV file
  • Saving PDF took too long time and generated very large PDF file
  • Currency symbol was lost when formatting cell values
  • Text orientation of merged cells changed in the generated PDF file
  • Saved Pivot Table causes MS Excel give error
  • Inserting rows cause merged cells broken
  • Symbols of Auto-filter were duplicated and became larger when re-saving XLS Setting data labels of chart point loses inherited settings from Series data labels
  • DateTime values are read as double format
  • When row/column exceeds XLS file's limit, the saved XLS causes: "Excel found unreadable content" error when opened in MS Excel

New in Aspose.Cells for Java 7.0.2 (Dec 21, 2011)

  • General Features / Improvements:
  • Support LightCellsDataProvider for saving XLSX files
  • Support J2SE7.0 version
  • Enhancements are made for Sheet-to-Image feature
  • Enhancements are made for Excel-to-PDF feature
  • All Fixes:
  • Enhancements:
  • Synchronize value type of the property Cells.StandardHeightPixels
  • Support to set worksheet as hidden at runtime even if it is the only sheet in the workbook
  • Support Grouping Data feature in Smart Markers
  • Support Sorting Data feature in Smart Markers
  • Include more format condition types (for Conditional Formatting feature) while saving XLS file
  • Support encryption type: RC4, Microsoft Enhanced Cryptographic Provider 1.0 128-bit
  • Exceptions:
  • Get an exception when using scientific values for Validation's formula
  • Reading encrypted Excel2007 template file causes Exception
  • Get an exception for Cell.getStringValue() method
  • Get an exception while saving XLSX with LightCells APIs
  • Bugs:
  • Picture lost in XLS-to-PDF feature
  • X/YAxis lost in Chart-to-Image feature
  • “#NA” values lost in Chart-to-Image feature
  • Image was created incorrectly for Pyramid Chart
  • Invalid PDF file was generated by XLS-to-PDF feature
  • Cell's value was not rendered correctly with “shrink to fit” property
  • Text was aligned to center instead of left in the resultant PDF file
  • TextBox.setHtmlText() did not parse rich text correctly
  • Scaled value of the newly added picture was changed in saved XLS file
  • Content of the Textbox was not rendered correctly in PDF file
  • Formulas was shown as “#NAME” in the generated XLS file
  • MROUND formula was not calculated correctly
  • Formula was calculated as “#VALUE” -1
  • Formula was calculated as “#VALUE” -2
  • Parentheses were lost for the negative values in the generated PDF file
  • ROUND formula was calculated incorrectly

New in Aspose.Cells for Java 7.0.1 (Dec 21, 2011)

  • Enhancements:
  • Improve Worksheet-to-Image feature
  • Enhance Excel-to-PDF conversion
  • Add new APIs: Worksheet.calculateFormula(), Row.getFirstCell(), Row.getLastCell()
  • Support Aspose.Total license
  • Render image to user’s custom Graphics
  • Include FormatCondition.getPriority() method
  • Include Cells.checkColumn(int) method
  • Include getters/setters for Cells.StandardHeightPixels/StandardWidthPixels attributes
  • Include WorkbookSettings.setLocale(Locale) and Protection.getPasswordHash() methods
  • Include getters/setters for WorkbookSettings.WindowHeightInch/WindowWidthInch
  • Exceptions
  • Get an Exception when saving PDF with French locale
  • Get an Exception when reading XLS file with the default locale which has no Country code
  • Worksheet.autoFitColumn() and Chart.toImage() may cause “java.awt.HeadlessException”
  • Get an Exception when reading XLS template file Bugs
  • Chart fonts changed after re-saving XLSX file
  • Sorting Names causes control’s linked cell changed
  • Vertical alignment is changed in the re-saved XLSX file

New in Aspose.Cells for Java 7.0.0 (Dec 21, 2011)

  • Overview of the changes:
  • It is not common practice for us to make breaking changes to the API and we always try to avoid this whenever possible, but sometimes it is necessary. In this case the changes in the new version occur because
  • A move towards using the Aspose Unified Framework which dictates an improved API for loading and saving. This makes for a more organized and consistent API to be used across all Aspose products
  • The source code from the .NET platform will now be automatically ported to the Java platform. This will enable Aspose.Cells for Java to match Aspose.Cells for .NET feature-by-feature
  • New Features/Enhancements:
  • There are some features that are included / enhanced now
  • Separate compiled versions of the product for different JDKs, e.g. 1.4, 1.5, 1.6
  • Set formulas with external references
  • Support ListObjects / Tables
  • Support AutoShapes Objects
  • Enhancements are made for Shape-to-Image feature
  • Enhancements are made for Chart-to-Image feature
  • Enhancements are made for Sheet-to-Image feature
  • Enhancements are made for Excel-to-PDF feature
  • Enhancements are made for Auto-Fit Rows/Columns feature
  • All Fixes:
  • Manipulate Tables
  • Read/Save Auto-Shapes, Chart-to-Image, Shape-to-Image features
  • Support to add Text Box into Chart for XLSX file
  • Copy PivotTables when copying Worksheets
  • Select multiple items for PivotField
  • Save Chart for Excel 2007 file
  • Explicit Exception type for invalid password and file format when reading template file
  • Read XLSX files with old dom4j library on OAS, saving PDF with “OnePagePerSheet” settings
  • Remove “final” restriction for Worksheet/Font/Color classes
  • Support to set ROUND/ROUNDUP/ROUNDDOWN formulas with only one parameter
  • Support to get Validation for a specific cell, copy validations when copying cells range
  • Sort data with more than three keys
  • Support RTL languages for PDF
  • Set HTML format value to cell
  • Support to set Gradient Fill for a cell
  • Provide support for Chart data table for Chart-to-Image feature
  • Support chart leader line for Chart-to-Image
  • An exception occurred when reading cell value from ODS file
  • An exception occurred when reading XLSX file that contains large amount of Styles
  • An exception occurred when reading Hyperlink with empty address from XLS file
  • An exception occurred when saving XLS files with auto-filters on
  • Problem with plotting empty cells in Chart-to-Image feature
  • Line chart are saved as Line chart with data markers
  • Read Number format incorrectly from ODS file
  • Saving PDF in long-running Server causes file descriptor leaking
  • Setting line type for a Line chart takes no effect for XLSX file
  • Header/Footer's Properties are not copied correctly when copying Worksheets
  • Re-saved Pivot Table causes “Excel has encountered an unreadable content ...” warning
  • Render Radio Button and Check Box to Image files
  • Copy Conditional Formatting when copying Workbook
  • Rules of Conditional Formatting are changed when re-saving XLSX files
  • Page margins for Excel-to-PDF
  • Chinese characters for Chart-to-Image feature
  • Re-saved XLSM file causes “Excel has encountered an unreadable content ...” warning
  • Calculate formulas with “-0.0” incorrectly
  • Style’s indent property takes no effect for the generated PDF
  • Invisible Textbox becomes visible in the re-saved XLSX file
  • Data Labels number format and legend order changed for Chart-to-Image feature
  • Validation criteria was saved incorrectly
  • Zero was formatted as “#” for Time value
  • Render border and part of picture for PDF
  • Calculate IRR formula incorrectly
  • Set Shape’s absolute position incorrectly
  • Copied Shapes(Dropdown List) cannot work fine when copying Worksheet
  • Saved Pivot Table for XLSX file causes warning message in MS Excel
  • Cells.clearContent() makes merged area un-merged
  • Calculate SUMIF incorrectly
  • Pie chart was not rendered to image fine

New in Aspose.Cells for Java 2.5.4 (Jun 1, 2011)

  • New Features:
  • 25051 - Support advanced auto-filter types: MultipleFilter, DynamicFilter, IconFilter
  • 25742 - Format the whole pivot table or cells in the pivot table report
  • 26627 - Set axis’ properties, such as, Max/Min value as “Automatic”
  • 26655 - Export animated GIF pictures for HTML file
  • 26607 - Support to calculate EOMONTH function
  • Enhancements:
  • 26655 - Import/Export date and border styles for ODS file
  • 27317 - Keep thumbnail of re-saved chart same with the original file when embedding XLS into PPT
  • 27214 - Make pivot field’s items hidden/shown
  • 26626 - Read/Save pivot table styles
  • Performance:
  • 27041 - Reading ODS files cause memory issues
  • Exceptions:
  • 26710 - Get an exception when reading form controls from XLSX file
  • 27128 - Handle “NumberFormatException” when reading ODS file whose row index of split pane exceeds the limit of Short
  • 27578 - An exception “IllegalArgumentException” occurred when reading ODS files whose column width definition exceeds Excel file’s limit
  • 27773 - Cope with “ArrayIndexOutOfBoundsException” when reading Hyperlinks from ODS file
  • 27780 - Get “NumberFormatException” when rendering PDF file
  • Bugs:
  • 26563 - Problem with Axis scale in Chart-to-Image feature
  • 27793 - Border style lost when re-saving XLS file
  • 26610 - Calculate EVEN, ODD, ROUNDUP/ROUNDDOWN functions
  • 27445 - X/Y axis scale issue for Chart-to-Image feature
  • 26605 - Calculate HLOOKUP, VLOOKUP/LOOKUP functions
  • 26156 - Problem in calculating SUM function
  • 26986 - Render chart data series for chart2image
  • 26735 - Issue in rendering back color of data labels for Chart-to-Image feature
  • 26600 - Render Exploded Pie Chart for Chart-to-Image feature
  • 27754 - Generated HTML file produce “File not found…” issue
  • 26599 - Problem with rendering grid lines for Chart-to-Image feature
  • 27699 - Making a sheet hidden may cause protection issue
  • 27040 - Issue with reading border style and formulas
  • 26151 - Problem with reading Dates prior to 1900-02-28 from ODS template file
  • 27426 - Issue with reading shapes in the chart
  • 26626 - Refresh/Calculate pivot tables programmatically
  • 26604 - Render series of hidden cells for Chart-to-Image feature
  • 26561 - Problem with right alignment of large numbers for Sheet-to-Image feature
  • 27792 - Save custom Date format in ODS file
  • 27445 - Axis scale issue in Chart-to-Image feature
  • 26666 - Set style of one workbook to the cells in another workbook

New in Aspose.Cells for Java 2.5.3 (Jun 1, 2011)

  • New Features:
  • 26872 - Render Arabic characters in PDF Conversion
  • 19910 - Set Custom Locale for formatting Cell values
  • 24141 - Keep Macros and read Cell Styles from ODS files
  • 22286 - Interruptible threads for rendering PDF files
  • 25400 - Detects the file format type for spreadsheets - CellsHelper.detectFileFormat()
  • 25457 - Support Arrows and other shapes in Sheet-to-Image feature
  • 26017 - Support IFERROR formula/function
  • 25513 - Get Pivot Table’s Data Source
  • 18897 - Remove Macros in the Excel spreadsheets - Workbook.removeMacro()
  • Enhancements:
  • 25153 - Enhance setting color feature for Shapes
  • 25406 - Excel-to-ODS conversion to save Theme Color and Percentage Formats
  • 25708 - Enhance Sheet-to-Image feature to include Rich Text contents
  • 25637 - Re-build component’s package structure
  • 25928 - Compatibility with POI
  • 26103 - Improve DateTime conversion while reading from CSV files
  • 25235 - Generate Chart from large data and enforce Series limit to 255
  • 26179 - Provide backward compatibility for OpenOffice to read Comments in XLS files
  • 26207 - Support for Animated Gif pictures for ODS to ODS and ODS to XLS conversions
  • 26169 - Read numeric values form CSV files
  • 26470 - Enhance Pivot Table’s manipulation by providing setIsGridDropZones
  • Performance:
  • 25857 - ODS to Tab Delimited conversion
  • 26878 - Smart Markers feature
  • Exceptions:
  • 25132 - Handle exception in PivotTable/Pivot Chart for null values
  • 25446 - Cannot read ODS files through ByteArrayInputStream
  • 25439 - Find exception in Reading XLSX Template
  • 26212 - Cannot Save ODS to PDF format
  • 26195 - Handle exception in Saving ODS to XLSX and creating Chart based on XLSX Data
  • 26444 - An exception is occurred in opening XLSX with encoding UTF-8 through FileInputStream
  • 26445 - Cannot save ODS file that was read using FileInputStream
  • Bugs:
  • 25068 - Problem in Reading / Saving Pivot Table for XLSX files
  • 25106 - Saving INDIRECT Formula for XLS files
  • 25237 - Issue in Saving output stream with Macros (attached) for XLS files
  • 25307 - Problem in copying Worksheets with AutoFilter enabled
  • 23721 - Layout problem for PDF rendering
  • 25308 - Refreshing Pivot Table in the template file
  • 25577 - Pivot Table is corrupted in the generated file
  • 24790 - Problem in Excel-to-PDF after adding EMF pictures into header of XLS file
  • 25671 - Problem in saving TAB_DELIMETED
  • 25635 - Delete Row with Formulae
  • 25624 - Issue in Chart-to-Image while rendering Category Labels of Chart
  • 25660 - XLS compatibility problem with MS Excel 2007
  • 25939 - Problem with Chart’s data source
  • 25962 - Data Labels of Scattered Chart in Chart-to-Image feature
  • 25967 - Color of 3D-Line Chart for XLSX file
  • 25968 - Issue with Category Axis Attribute for XLSX files
  • 26036 - Convert CSV to XLSX when cells value contain “%”
  • 26057 - Backward compatibility problem from XLS to XLSX for un-supported shapes
  • 26156 - Problem with Formula Evaluation [Div!0 Error]
  • 26110 - Formula Calculation issue with Round() function
  • 26129 - Save Shared Formula for XLS files
  • 26195 - Read Custom Number formats for ODS files
  • 26246 - Problem rendering EMF in Sheet-to-Image feature
  • 26151 - Apply formatting while saving ODS to XLS or XLSX formats
  • 26561 - Problem in SheetRender API for exporting range of Cells
  • Regression:
  • 25399 - Fix Saving XLS to XLSX
  • 25698 - Rows are getting “Hidden” in AutoFilter’s region of XLS file
  • 25874 - Incorrect First Subtotal on Named Ranges

New in Aspose.Cells for Java 2.5.2 (Mar 10, 2011)

  • Supports to read Pivot Tables from the template files.
  • Adds LineShape to Excel 2007 XLSX files.
  • Provides support to set Series name when setting Chart’s data source.
  • Supports to get/set Gridlines’ visibility of different Worksheets in ODS files.
  • Enhancement is made for reading Shapes from XLSX files.
  • Enhancement is made for Chart-to-Image, Sheet-to-Image and Excel-to-PDF features.
  • Enhancement is made for parsing Formulas.
  • Enhancement is made for copying Cells.
  • 31 fixes and enhancements.

New in Aspose.Cells for Java 2.5.1 (Feb 9, 2011)

  • Supports to interrupt open/save process while working with large files.
  • Provides support to set and calculate more formulas
  • Supports to get/set shape’s absolute position
  • Fixes bugs of reading/saving Excel 2007 files
  • Fixes bugs of reading/saving ODS files
  • Fixes bugs of reading/saving Excel 97-2003 files
  • Enhancement is made for Chart to Image, Sheet to Image and Excel to PDF features
  • Enhancement is made for parsing formulas
  • Enhancement is made for calculating formulas
  • 22 fixes and enhancements

New in Aspose.Cells for Java 2.5.0 (Dec 27, 2010)

  • What's changed:
  • Supports to import/export XLSB file format.
  • Includes ShapeTextFrame class to auto-size the frame to fit its contents.
  • Dotted lines are supported in Chart-to-Image feature.
  • Fixes internal bugs of reading/saving Excel 2007 files.
  • Fixes internal bugs of reading/saving ODS files.
  • Fixes bugs of reading/saving Excel 97-2003 files.
  • Chart-to-Image feature is enhanced.
  • Direct Excel-to-PDF feature is enhanced.
  • Sheet-to-Image and Sheet-to-Print features are enhanced.
  • Formula Calculation Engine is enhanced.
  • 11 fixes and enhancements.

New in Aspose.Cells for Java 2.4.3 (Dec 27, 2010)

  • What's changed:
  • Supports to get Excel 2007 Theme colors.
  • Exports charts/shapes as images for HTML file conversion.
  • Supports to read/write different headers/footers for first/even/odd pages.
  • Fixes some internal bugs of reading/saving Excel 2007 files.
  • Fixes some internal bugs of reading/saving ODS files.
  • Fixes some internal bugs of reading/saving Excel 97-2003 files.
  • Enhancement is made for Chart to Image feature.
  • Enhancement is made for Direct Excel to PDF feature.
  • 14 fixes and enhancements.

New in Aspose.Cells for Java 2.4.2 (Dec 27, 2010)

  • What's changed:
  • Supports array parameters({...}) for setting formulas.
  • Provides support to add linked pictures.
  • Supports to save cells data directly into stream or file without building complete data model in the memory.
  • Check whether the license has been set, includes support to get expiry date of your subscription.
  • Reading/Saving Excel 2007 files operation is enhanced.
  • Chart to Image feature is enhanced.
  • Direct Excel to PDF feature is enhanced.
  • Formatting Cell values feature is enhanced.
  • Reading/Saving Excel 97-2003 files operation is enhanced.
  • 21 fixes and enhancements.

New in Aspose.Cells for Java 2.4.1 (Dec 27, 2010)

  • What's changed:
  • Supports more flexible model for calculating custom functions.
  • Includes error checking options for cells.
  • Mathematical calculation of Range parameters in formulas is added.
  • Provides support to set linked cells for chart frames such as Title, Data Labels.
  • Supports to manipulate window position and size properties for Workbook.
  • Reading/Saving Excel 2007 files operation is enhanced.
  • Chart to Image feature is enhanced.
  • Direct Excel to PDF feature is enhanced.
  • Formatting Cell values is enhanced.
  • Reading Excel 97-2003 files operation is enhanced.
  • Saving charts module is enhanced.
  • Formula Calculation Engine is enhanced.
  • 21 fixes and enhancements.

New in Aspose.Cells for Java 2.4.0 (Dec 27, 2010)

  • What's changed:
  • Includes Sheet to Image, Sheet to Print and Workbook to Print features
  • Supports Conditional formatting for Excel to Pdf feature
  • Provides support for grouping pivot table fields in Excel2007 files
  • Keeps macros when converting Excel97-2003 files to Excel2007 files
  • Renders Shapes when converting to Pdf files, e.g. TextBox, Rectangle, Oval, Arc
  • Supports to get/set full name of the source file for the Ole Object
  • Enhancement is made for reading/saving Conditional formatting
  • Enhancement is made for Chart to Image feature
  • Enhancement is made for direct Excel to Pdf feature
  • Enhancement is made for formatting of cell values
  • Enhancement is made for removing header/footer of PageSetup
  • Enhancement is made for copying cells
  • 22 fixes and enhancements.

New in Aspose.Cells for Java 2.3.1 (Dec 27, 2010)

  • What's changed:
  • Provides support for AES encryption type for Excel 2007 files.
  • Supports reading/writing PivotTables for Excel 2007 files.
  • Adds svg/svgz image format support for Chart to Image feature.
  • Supports multiple print areas for PageSetup options.
  • Sets custom number formats for PivotField.
  • Includes new Built-in document properties for Excel 2007 file.
  • Combines multiple Workbooks.
  • Supports to save PDF to Stream for the direct Excel to PDF feature.
  • An enhancement is made for reading/writing Excel 2007 files.
  • An enhancement is made for reading/writing Excel 2003 files.
  • An enhancement is made for reading XLS template files.
  • 25 fixes and other enhancements.

New in Aspose.Cells for Java 2.0.1 (Jun 11, 2009)

  • What's changed:
  • Supports to R/W Open Document Spreadsheet file(ODS): Cell data and style, Row/Column style, Merged Cells, Worksheet/Workbook properties, Document properties, Formula/Name.
  • Supports to set shared formula.
  • Supports to manipulate controls: Check box, Button, Radio button, Combo box, List box, Group box, Scroll bar, spinner, Label.
  • Supports Page setup Header(s) and Footer(s) in xls2pdf.
  • Supports to copy Chart when copying Worksheet/Workbook
  • Supports to copy Shape related objects
  • Supports to save worksheet as html to stream
  • Supports PivotChart
  • Supports to get image data of Picture and OleObject
  • Supports to R/W Color theme for 2007 file format
  • Supports Encryption type: Microsoft Strong Cryptographic Provider
  • 27 fixes and enhancements.

New in Aspose.Cells for Java 2.0.0.0 (Jan 21, 2009)

  • Supported to manipulate charts in Excel97-2003 template files
  • Supported to read and save Excel2007 XLSM, XLTX, XLTM file
  • Supported drawing objects such as Shapes, Charts, etc. in Excel2007 format
  • Supported to set outline border for a range
  • Supported to read OleObject from template file
  • Supported to insert AVI file as OleObject
  • Supported to copy Macros when copying Workbook
  • Supported images in xls2pdf
  • Supported new Excel formula functions: MROUND, FDIST, NEGBINOMDIST
  • Improved performance of reading Excel2007 file
  • Enhanced chart attributes APIs
  • Fixed bugs while reading and saving some special files
  • Fixed a bug of saving as html
  • Fixed a bug of saving as CSV
  • Fixed a bug of saving header and footer of PageSetup
  • Fixed a bug of adding Picture by InputStream from URLConnection
  • Fixed a bug of parsing Date value for Date and Time function
  • Fixed a bug of sorting Names
  • Fixed a bug of copying formula
  • Fixed a bug of calculating and saving formula
  • Fixed a bug of Cell.getStringValue()
  • Fixed a bug of Cell.setValue(Long)
  • Fixed a bug of Cells.deleteRows()
  • Fixed a bug of Validation and ConditionalFormatting's formula

New in Aspose.Cells for Java 1.9.3.0 (Jan 30, 2008)

  • Supports to add Arc, Oval, Rectangle
  • Supports to add Word and Excel file as OLE object
  • Supports to only load data and formatting in the template file
  • Supports to copy style when insert rows and columns
  • Supports to get number format type of cell
  • Supports to filter non-blank/blank cells in AutoFilter
  • Improved: Provides methods for Shapes object to add any shape
  • Fixed a bug of calculating formulas
  • Fixed a bug of getting minimum column of row
  • Fixed a bug of importing a collection into cells
  • Fixed a bug of reading file
  • Fixed a bug of copying formulas
  • Fixed a bug of copying cell range
  • Fixed a bug of formatting number with E-exponent

New in Aspose.Cells for Java 1.9.2.0 (Dec 27, 2007)

  • Supports to iterate all cells of one worksheet by one Iterator
  • Supports to copy cells range
  • Supports to get all defined Name objects, including NamedRange object and those objects which are not conventional NamedRange but Name object
  • Supports to unmerge cells
  • Supports to add the line shape
  • Remove the 64K rows and 256 columns limitation for Excel2007
  • Fixed a bug of losing merged style when copy row and column
  • Fixed a bug of saving workbook on AIX
  • Fixed a bug of getting string value of the cell
  • Fixed a bug of reading the file

New in Aspose.Cells for Java 1.9.1.0 (Nov 20, 2007)

  • Supports to export to and import from Excel2007xlsx file.
  • Supports to sort datas of the range.
  • Supports to be used with PHP.
  • Supports to set the scale and unit of Time Scale Category axis.
  • Fixed a bug of calculating formulas
  • Fixed a bug of formating number.
  • Fixed a bug of adding picture.
  • Fixed a bug of saving file.

New in Aspose.Cells for Java 1.9.0.0 (Sep 3, 2007)

  • Supports to export to Aspose.Pdf xml file
  • Supports to copy comments and named ranges when coping worksheet
  • Supports ICustomFunction interface of calculating formulas
  • Supports to trace predents and depedents of a cell
  • Supports to only calculate all formulas in a worksheet
  • Supports POJO and POJOs with smart markers
  • Fixed a bug of getting named ranges of the worksheet
  • Fixed a bug of creating the PivotTable
  • Fixed a bug of protecting file
  • Fixed a bug of calculating formulas
  • Fixed a bug of saving the file.