Enable show report filter pages options and get support for Excel 95 using Aspose.Cells for Java v19.1

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

It is pleasure for us to announce the release of new updated version Aspose.Cells for Java v19.1 with exciting new features. This time along with adding new features, we have resolved many bugs and handled exceptions to assist the developers community. Aspose is committed to achieve the maximum user satisfaction by providing innovating solutions and enhancements. We are always in the process of making improvements by analysing different features of Excel and providing the support for the same in our product.

Release notes is one of the important document where all the detailed information is available about the changes made in the new release.  This time new features are introduced like “Show report filter pages option”, using text cross type option to handle overflowing cell content, support for legacy Excel 95/5.0 and sorting data based on background color. You may go through the release notes to have a glimpse of all the changes in this new version. For more details about this product you may visit the links in the last section of this document. For an easy access and utilization  Aspose for Java APIs can be directly installed from Maven repository for which check document.

Enable show report filter pages option while managing pivot table

Excel supports creating pivot tables, adding report filters and enable “Show Report Filter Pages” option. Aspose.Cells has also provided this support now to enable the “Show Report Filter Pages”option on created pivot table. As a result of this option the created workbook will contain more worksheets. It will split every possible value of report filter in a separate worksheet.

For a working example refer to the following article:

Support for legacy Excel 95/5.0

Excel 95 support was not available earlier which was causing issues in using legacy Excel 95/5.0 files. Aspose.Cells has provided the support for this old file format now. For this purpose FileFormatType.EXCEL_95 is introduced which can be used for creating new workbook and LoadFormat.Auto can be used to open these file formats.

For a working example refer to the following article:

Specify how to cross string in output PDF and image

When a cell contains text or string but it is larger than the width of the cell, then the string overflows if the next cell in next column is null or empty. While saving Excel file into PDF/Image, we can control this overflow by specifying the cross type using the TextCrossType enumeration. It has the values TextCrossType.DEFAULT, TextCrossType.CROSS_KEEP, TextCrossType.CROSS_OVERRIDE and TextCrossType.STRICT_IN_CELL. This feature will create similar output as Excel while rendering sheets to PDF and images.

    For a working example refer to the following article:

    Sorting data based on cell background color

    Excel provides feature to sort data based on background color. Same feature was required by users while using Aspose.Cells. This feature is provided now by using DataSorter where SortOnType.CELL_COLOR can be used in addKey() to sort data based on background color. All the cells which contain specified color in the addKey() function are placed on top or bottom according to the SortOrder setting and order of the rest of the cells is not changed at all.

    For a working example refer to the following article:

    Using custom functions from Add-in  

    There is a common scenario when there are custom formulas which we want to include as an excel add-in. While setting the cell.setFormula value to some function, built-in functions work fine however there is a need to set the custom functions or formulas using the add-in functions. Aspose.Cells provides features to register add in functions using Worksheets.registerAddInFunction(). Afterwards when we set cell.setFormula(anyFunctionFromAddIn), the output Excel file will contain the calculated value from the Add-In function. This feature is available now where an add-in can be registered and function from the newly added add-in can be called.

    For a working example refer to the following article:

    Other Enhancements and Fixes

    There are some other enhancements included and a few exceptions handled in the new release for the users. A few of the worth mentioning features and other improvements are as follows.

    • Bug removal for change in text color while converting ODS to XLSX
    • Support for preserving the strikethrough font while ODS to XLSX
    • Problem with strikethrough text in generated HTML file format
    • ODS to XLSX – Text box dimensions changed
    • ODS -> XLSX – Hyperlink is functional but shown as plain text
    • ODS to XLSX, Percentages are lost in bar graph chart
    • Some styles are not rendered in HTML input

    In Aspose.Cells 19.1, we fixed several important bugs and other issues. For example, CellsException while converting files, Exception “java.lang.ArrayIndexOutOfBoundsException: -32768” when loading an XLSX file format and ArrayIndexOutOfBoundsException when loading a workbook.

    Changes to the Public API

    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:

    • Adds PivotTable.ShowReportFilterPageByName (string fieldName) method, shows all the report filter pages according to PivotField’s name, the PivotField must be located in the PageFields.
    • Adds PivotTable.ShowReportFilterPageByIndex(int posIndex) method , shows all the report filter pages according to the position index in the PageFields.

    • Adds PivotTable.ShowReportFilterPage(PivotField pageField) method, shows all the report filter pages according to PivotField, the PivotField must be located in the PageFields.
    • Adds DataSorterKey and DataSorterKeyCollection class , represents the key of the data sorter.
    • Adds DataSorter.AddKey(Int32,SortOnType,SortOrder,Object) method, adds the sort key such as cell’s background color, font color.
    • Adds Aspose.Cells.DataSorter.Keys property, gets all keys of the data sorter.
    • Adds SortOnType enum, represents the type of sorted data.
    • Adds ODSLoadOptions class, represents the options of loading ODS file.
    • Adds HTMLLoadOptions.ProgId property, gets the program id of creating the file. used only for MHT files.
    • Adds PdfSaveOptions.TextCrossType property, gets or sets displaying text type when the text width is larger than cell width.
    • Adds TextCrossType enum class, Enumerates displaying text type when the text width is larger than cell width.
    • Adds WorksheetCollection.RegisterAddInFunction() methods, replacement of Cell.SetAddInFormula(), a more convenient and efficient way for users to add and use addin functions.
    • Deletes Obsoletes Cell.SetAddInFormula() method, register the addin functions firstly by WorksheetCollection.RegisterAddInFunction() and then setting the formula for Cell by Cell.Formula/Cell.SetFormula() instead.

    Aspose.Cells for Java Resources

    The resources, you may need to accomplish your tasks:

    Posted in Aspose.Cells Product Family | Leave a comment

    Enable show report filter pages option in PivotTables and manipulate Excel 95 files using Aspose.Cells for .NET 19.1

    Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

    Aspose.Cells for .NET logoWe are pleased to announce the release of Aspose.Cells for .NET v19.1, the MS Excel file formats API that provides the ability to create, manipulate, convert or render MS Excel spreadsheets, and more importantly – is fully documented. Please check the document on how to install Aspose for .NET APIs directly from NuGet repository. We have added a few important features and other enhancements while keeping the product more stable and feature rich API. We also included important bug fixes as a part of this release. Moreover, fixing bugs and issues leads us to new enhancements and features which increases our customer base.

    Please check the release notes which cover all the new features, enhancements and list of bugs which are resolved in this new version. New features are always introduced while enhancing this product which helps us to compete the ever growing software industry. Exceptions handling empowers the developers to keep control of the applications and assist users in a better way to continue using the application without any interruption. You will get an idea about what is new and what has been enhanced or fixed with this revision of Aspose.Cells for .NET
    .

     

    Enable show report filter pages option while managing pivot table

    MS Excel supports creating PivotTables, adding report filters and enabling “Show Report Filter Pages” option. Aspose.Cells has also provided this support now to enable the “Show Report Filter Pages”option on the created pivot table. As a result of this option the created workbook will contain more worksheets in it. It will split every possible value of report filter in a separate worksheet.

    For a working example refer to the following article:

    Support for legacy Excel 95/5.0

    MS Excel 95 support was not available earlier which was causing issues when using legacy Excel 95/5.0 files. This support is available now and these older file formats  can be used now. For this purpose FileFormatType.Excel95 is introduced which can be used for opening these file formats.

    For a working example refer to the following article:

    Specify how to cross string in output PDF and image

    When cell contains text or string but it is larger than the width of the cell, then the string overflows if the next cell in next column is null or empty. When MS Excel file is saved into PDF/Image, we can control this overflow by specifying the cross type using the TextCrossType enumeration. It has the values TextCrossType.DefaultTextCrossType.CrossKeepTextCrossType.CrossOverride and TextCrossType.StrictInCell. This feature will create similar output as Excel while rendering sheets to PDF and images.

      For a working example refer to the following article:

      Sorting data based on cell background color

      MS Excel provides feature to sort data based on background color. Same feature was required by some users while using Aspose.Cells. This feature is provided now by using DataSorter where SortOnType.CellColor can be used in AddKey method to sort data based on background color. All the cells which contain specified color in the AddKey(), function are placed on top or bottom according to the SortOrder setting and order of the rest of the cells is not changed at all.

      For a working example refer to the following article:

      Using custom functions from Add-in  

      In common scenario, there can be custom formulas that we want to include as an Excel addin. Setting the Cell.Formula value to some function, built-in functions work fine however there can be a need to set the custom functions or formulas using the add-in functions. Aspose.Cells provides features to register add in functions using Worksheets.RegisterAddInFunction method. Afterwards when we set Cell.Formula attribute, the output Excel file shall contain the calculated value from the AddIn function. This feature is available now where an add-in can be registered and function from the newly added add-in can be called.

      For a working example refer to the following article:

        Other Enhancements and Fixes

        There are some other enhancements included and a few exceptions handled in the new release for the users. A few of the worth mentioning features and other improvements are as follows:

        • Detect if generated MHT file is a worksheet or not
        • Handled an exception that raised while converting to the Open Strict XML format
        • Handled an exception when loading an XLSB/XLSX file format
        • Handled an exception while calling Cells.DeleteBlankRows

        In Aspose.Cells 19.1, we fixed several important bugs and other issues. For example, issues around reading/writing MS Excel file formats, using PageSetup options, importing objects into the worksheet, manipulating rows and columns, refreshing and calculating pivot tables, rendering and manipulating charts and shapes, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved in the release. Moreover, Aspose.Cells formula calculation engine is further improved.

        Changes to the Public API

        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 .NET:

        • Adds PivotTable.ShowReportFilterPageByName (string fieldName) method, shows all the report filter pages according to PivotField’s name, the PivotField must be located in the PageFields.
        • Adds PivotTable.ShowReportFilterPageByIndex(int posIndex) method , shows all the report filter pages according to the position index in the PageFields.

        • Adds PivotTable.ShowReportFilterPage(PivotField pageField) method, shows all the report filter pages according to PivotField, the PivotField must be located in the PageFields.
        • Adds DataSorterKey and DataSorterKeyCollection class , represents the key of the data sorter.
        • Adds DataSorter.AddKey(Int32,SortOnType,SortOrder,Object) method, adds the sort key such as cell’s background color, font color.
        • Adds Aspose.Cells.DataSorter.Keys property, gets all keys of the data sorter.
        • Adds SortOnType enum, represents the type of sorted data.
        • Adds ODSLoadOptions class, represents the options of loading ODS file.
        • Adds HTMLLoadOptions.ProgId property, gets the program id of creating the file. used only for MHT files.
        • Adds PdfSaveOptions.TextCrossType property, gets or sets displaying text type when the text width is larger than cell width.
        • Adds TextCrossType enum class, Enumerates displaying text type when the text width is larger than cell width.
        • Adds WorksheetCollection.RegisterAddInFunction() methods, replacement of Cell.SetAddInFormula(), a more convenient and efficient way for users to add and use addin functions.
        • Obsoletes Cell.SetAddInFormula() method, register the addin functions firstly by WorksheetCollection.RegisterAddInFunction() and then set the formula for Cell by Cell.Formula/Cell.SetFormula() instead.

        Aspose.Cells for .NET Resources

        The resources, you may need to accomplish your tasks:

        Posted in Aspose.Cells Product Family | Leave a comment

        Export Scene to AMF Format with Aspose.3D

        Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

        Aspose.3D for .NET logo

        We are pleased to announce January release of Aspose.3D API. It includes long awaited support to export a scene to AMF format, in compressed mode as well as in uncompressed mode. Moreover, you can manually generate UV and associate it with the mesh with latest version of the API. In order to implement this functionality in your applications, please check following demonstration in documentation of the API:

        You can use following links to download Aspose.3D for .NET and Java APIs.

        Please visit Release Notes (Java) or Release Notes (.NET) for further information about this release. In case you have any question about Aspose.3D API, you can post your inquiry in Aspose.3D forums.

        Aspose.3D for .NET and Java Resources

        The following resources will help you work with Aspose.3D for .NET and Java APIs:
        • Home page for Aspose.3D API.
        • Aspose.3D API wiki docs– Help documentation and API reference documents.
        • Aspose.3D product family forum– Post your technical questions, queries and any other problem you faced while running Aspose.3D APIs.
        • Enable email subscription– Do not limit yourself, stay up-to-date with the latest news about the Aspose.3D APIs and new features, fixes, plus other API related topics by subscribing to Aspose.3D blog.
        • Aspose.3D for .NET Examples– We have published our code examples on the social coding website GitHub.com. Anyone can explore the code examples for learning purposes.
        • Aspose.3D for Java Examples – We have published our code examples on the social coding website GitHub.com. Anyone could explore the code examples for learning purposes.
        • Release Notes (.NET and Java) – For details on API fixes, please check Release Notes having a complete list of the new features.
        Posted in Aspose.3D Product Family | Leave a comment

        Convert PostScript Files into Image format using Aspose.EPS

        Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

        Aspose.EPS for .NETWe are pleased to announce new release of Aspose.EPS for both .NET and Java Platforms. New excited features along with several performance improvements have been introduced in this release of the API. Furthermore, some fixes against reported bug in earlier version(s) of the API are also part of this release. Following links will take you to the downloading area of the API from where you can download and use it as per your working environment.

        Release notes of both .NET and Java APIs can be found over following links:

        Convert Postscript files into Image formats

        In this revision of the API, an exciting feature to convert PS/EPS files into image format has been introduced. At the moment, the feature is available only for .NET API and implementation of similar support in Java version of the API is still underway. In order to implement this functionality in .NET applications, please check following demonstration in documentation of the API:

        Aspose.EPS for .NET and Java Resources

        The following resources will help you work with Aspose.EPS for .NET and Java APIs:

        • Home page for Aspose.EPS API.
        • Aspose.EPS API wiki docs– Help documentation and API reference documents.
        • Aspose.EPS product family forum– Post your technical questions, queries and any other problem you faced while running Aspose.EPS APIs.
        • Enable email subscription– Do not limit yourself, stay up-to-date with the latest news about the Aspose.EPS APIs and new features, fixes, plus other API related topics by subscribing to Aspose.EPS Blog.
        • Aspose.EPS for .NET Examples– We have published our code examples on the social coding website GitHub.com. Anyone can explore the code examples for learning purposes.
        • Aspose.EPS for Java Examples – We have published our code examples on the social coding website GitHub.com. Anyone could explore the code examples for learning purposes.
        • Release Notes (.NET and Java) – For details on API fixes, please check Release Notes having a complete list of the new features.
        Posted in Aspose.EPS Product Family, Asad Ali | Leave a comment

        Convert XPS Document into Image Format using Aspose.XPS for .NET

        Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

        It is our pleasure to announce new release of Aspose.XPS for .NET 18.12 which is available for download and to be used in .NET Applications. This revision of the API has been rolled out with exciting features as well as improvements in the performance and usability. In case you want to use this version of the API, it is strongly recommended to go through the respective release notes page which contains complete information of what has been changed and introduced new in the API.

        Following section provides some insights into newly introduced features of the API:

        XPS to Image Conversion

        From 18.12 version of Aspose.XPS for .NET, you will be able to convert XPS documents into different image formats. Currently, following image formats have been added into output file formats catalog of the API:

        • PNG
        • BMP
        • JPEG/JPG
        • TIFF

        Conversion examples have also been showcased in API documentation and can be found over following links:

        Aspose.XPS for .NET Resources

        The following resources will help you work with Aspose.XPS for .NET API:

        Posted in Aspose.XPS Product Family, Asad Ali | Leave a comment

        Improved API Performance with Aspose.Email for .NET 19.1

        Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

        We are pleased to announce the release of Aspose.Email for .NET 19.1. This release includes few enhancements in API and overall functionality of the API has been improved as a result of several bug fixes. For a detailed note on what is fixed, please visit the release notes section of API.

        Enhancements in Aspose.Email for .NET 19.1

        This release includes few enhancements to the API’s functionality. These enhancements include listing messages while working with Pop3Client, loading and saving of VCF contact and reading of OLM and MBX files.


        Other Improvements

        This release includes several improvements in term of bug fixes. Following is the list of improvements in this month’s release.

        • Improved working with EWSClient while UpdateItems
        • Improved formatting of HtmlBodyText in output
        • Improved working with loading EML
        • Improved working with date in header using MapiMessage to display in MHTML output
        • Improved working with ImapClient.ListMessagesByPage
        • MSG contact to MHT conversion is enhanced
        • Improved working with signed MSG
        • MailMessage to HTML conversion is enhanced
        • VCF to MSG conversion is enhanced
        • PST to MBOX conversion is enhanced
        • MSG to MHTML is enhanced

        API Resources

        The following API resources can be of help to you in getting started with Aspose.Email API.

        Posted in Aspose.Email Product Family | Leave a comment

        Support for Microsoft Office 365 Project Online Service with Aspose.Tasks for .NET 19.2

        Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

        aspose-tasks-for-netWe are pleased to announce the release of Aspose.Tasks for .NET 19.2. This release includes support for Microsoft Project Online,  MPP files saved with Microsoft Office 365 cloud are supported now. Also fixes few issues reported with the API that further enhance the stability of the API. For a detailed note on what is new and fixed, please visit the release notes section of API documentation.

        Support for Microsoft Office 365 Project Online Service

        We happily announce that Aspose.Tasks for .NET API now supports Microsoft Office 365 Project Online Services. Now the users shall be able to read/write projects created using Microsoft Office 365 Project Online Service.

        Other Improvements

        There were various important improvements are implemented with this release. The support of setting CSS prefix for HTML export has been added and API is enhanced in working with Primavera DB. The feature to set custom date format while exporting to PDF format has also been implemented in this release. 

        Moreover, the following enhancements have been introduced in this release.

        • Working with hyperlinks, scheduling, Chinese timestamps and lookup values are improved while re-saving MPP files.
        • Improved reading of resources in MspResourceMapper and MpdResourceMapper

        API Resources

        You may visit the following API resources for getting started and working with the API.

        • Product Documentation – Detailed API documentation with code examples and details about API functional areas
        • Aspose.Tasks Forum – Our online support forum where we address your queries and inquiries
        Posted in Aspose.Tasks Product Family | Leave a comment

        Create Curved Geometries with Aspose.GIS for .NET 19.1

        Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

        We are pleased to announce the release of Aspose.GIS for .NET 19.1. With this release, you can add non-linear geometries to your FileGDB, WKT, WKP, and GML files. For a complete list of what is new and fixed, please visit the release notes section of the API documentation.

        Create curved geometries with Aspose.GIS for .NET 19.1

        This release of Aspose.GIS for .NET has added support for curved geometries. With this release, you can create the following curved geometries.

        • Circular String
        • Compound Curve
        • Curve Polygon

        In addition to this, you may determine whether geometry is curved or not. You may also convert curved geometries to linear geometries by using the method ToLinearGeometry().


        The following API resources can be of help to you in getting started with Aspose.GIS:

        API Resources

        Posted in Aspose.GIS Product Family | Leave a comment

        OneNote to PDF Improved with Aspose.Note for .NET 19.1

        Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

        Aspose.Note for .NET 19.1 has been released. This release includes improvement in terms of quality and performance with refactor rendering for underline text and rich text while saving .ONE documents to PDF. For a detailed note on what is new and fixed, please visit the release notes section of API documentation.

        Improvements in Aspose.Note for .NET 19.1

        This new release of API introduces some important enhancements while saving .ONE documents to PDF and also improves image visibility while saving as HTML.

        Following enhancements have been introduced in this release.

        • Improved quality with refactor rendering of underlined text for PDF format
        • Improved performance with refactor rendering to PDF
        • Image visibility improved in Chrome browser

        API Resources

        You can get started with Aspose.Note for .NET by making use of information available in the following.

        API Documentation – Helps getting started with the API using code samples and examples

        Forum Support – Post your inquiries to get help from our technical support team

        Examples – Try the ready-to-use examples of the API by downloading from our GitHub repository

        API Reference Guide – Provides information about all the namespaces, classes and properties of the API

        Posted in Aspose.Note Product Family | Leave a comment

        Support for PLT and IGES file formats in Aspose.CAD

        Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

        We are pleased to share the release announcement for Aspose.CAD for Java 18.12. We have included support for many API features including support for PLT and IGES file formats. We have also resolved certain issues incurring in API as well.

        Enhancements

        Following features have been introduced in this release.

        Enhancements

        Following enhancements have been introduced in this release.

        • DWG to PDF not properly converted .

        • Exception on saving DWG to Image.

        • Replace of entities sometimes not working.

        • Input string was not in a correct format during export of DGN with specified layout.

        • Exception on converting dwg to pdf.

        • Bad render on curve when converting dxf file to pdf and raster images.

        • DWG to PDF not properly converted.

        • ImageSave exception on exporting DWG to PDF.

        • Image load exception on loading DWF file.

        • Exception when Aspose.CAD.Image saved as pdf.

        • DWG to PDF not properly converted.

        • DXF to PDF not properly converted.

        • DWG to PDF not properly converted.

        • Adobe PDF throw error on exporting DXF to PDF.

        • Issue reading some tags and attributes from DWG.

        • DWG to PDF not properly converted.

        • DWG to PDF not properly converted.

        • DXF to PDF not properly converted.

        • DWG to PDF not properly converted.

        • DWG to PDF not properly converted.

        • DWG to PDF not properly converted.

        • DXF to PDF not properly converted.

        • DWG to PDF not properly converted.

        • Text missing in generated PDF.

        • DWG to PDF not properly converted.

        • DWG to PDF not properly converted.

        • ImageLoad exception on exporting to PDF.

        • Exception when loading Aspose.PDF and CAD in one project together.

        • Conholidate licenses support.

        • Resize the page height / width after adding layers.

        • DWG to PDF not properly converted.

        • DWG to PDF not properly converted.

        • Exception on loading Image.

        • Get the Size of IFC document.

        • Exception while using Resize() method for CadImage.

        • DXF to PDF conversion is producing empty pages.

        • Image saving failed when saving to image.

        To view a complete list of new features and to download the latest release, please visit Aspose.CAD for Java 18.12 page in downloads section. Please refer to the release notes of Aspose.CAD for Java 18.12 for a full view of improvements along with sample code snippets for newly added features.

        Aspose.CAD for Java Resources

        The resources, you may need to accomplish your tasks:

        Posted in Aspose.CAD Product Family | Leave a comment