Create Barcodes with parenthesis in the CodeText

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

We are pleased to announce the release of Aspose.BarCode for .NET 19.1. This release enhanced the BarCodeGenerator API to support parenthesis in the CodeText. For a detailed note on what is new and fixed, please visit the release notes page for information of API documentation.

Support for parenthesis in CodeText

This release of Aspose.BarCode enhanced the BarCodeGenerator API to allow the CodeText to contain parenthesis. You may generate barcodes with parenthesis in the CodeText as shown below in the code example. 

Aspose.BarCode.Generation.BarCodeGenerator generator = new
Aspose.BarCode.Generation.BarCodeGenerator(
Aspose.BarCode.Generation.EncodeTypes.Pdf417);

generator.CodeText = "Sample.Code.Text(Example).20181203_150435";

generator.Save(TestDirectory + "barcodeTest.png", BarCodeImageFormat.Png);
Result:
Correct PNG image.

Aspose.BarCode for .NET Resources

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

Posted in Aspose.BarCode Product Family | Leave a comment

Enable show report filter pages options and get support for MS Excel 95 using Aspose.Cells for PHP via Java 19.1

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

We are pleased to announce the first public release of Aspose.Cells for PHP via Java v19.1 for the users. This release includes new features, enhancements and bug fixes which further improve the overall stability and usability of the API. Aspose.Cells for PHP via Java has full functionality of Aspose.Cells for Java with a few limitations, minor API changes and additional requirements. Please notice Product features comparison page for your reference. See the following release notes on major features for your reference.
Aspose.Cells for PHP via Java 19.1 release notes.

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 PHP via Java Resources

    Following are the links to some useful resources you may need to accomplish your tasks.

     

    Posted in Aspose.Cells Product Family | Leave a comment

    Enable show report filter pages options and get support for MS Excel 95 using Aspose.Cells for JavaScript via Java 19.1

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

    We are pleased to announce the release of Aspose.Cells for JavaScript via Java 19.1. This release includes new features, enhancements and bug fixes which further improve the overall stability and usability of the API. Since Aspose.Cells for JavaScript is a subset component, so it includes all the important and useful features present in its native Aspose.Cells for Java, please visit features comparison page for your reference. Aspose.Cells for JavaScript via Java has almost full functionality of Aspose.Cells for Java with a few limitations, minor API changes and additional requirements. See the following release notes on major features and other improvements for your reference

    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 colour

      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 JavaScript via Java Resources

      Following are the links to some useful resources you may need to accomplish your tasks.

      Posted in Aspose.Cells Product Family | Leave a comment

      Read MapInfo TAB and MapInfo Interchange file formats with Aspose.GIS

      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.2. This release gives you the ability to work with MapInfo TAB and MapInfo Interchange file formats. For a complete list of what is new and fixed, please visit the release notes section of the API documentation.

      Read MapInfo TAB and MapInfo Interchange file formats

      This release of Aspose.GIS for .NET has added support for reading MapInfo TAB and MapInfo Interchange file formats as shown below in the code example.

      Read MapInfo TAB File

      string TestDataPath = RunExamples.GetDataDir();
      using (var layer = Drivers.MapInfoTab.OpenLayer(Path.Combine
      (TestDataPath, "data.tab")))
      {
      Console.WriteLine($"Number of features is {layer.Count}.");

      var lastGeometry = layer[layer.Count - 1].Geometry;
      Console.WriteLine($"Last geometry is {lastGeometry.AsText()}.");

      foreach (Feature feature in layer)
      {
      Console.WriteLine(feature.Geometry.AsText());
      }
      }

      Read MapInfo Interchange File

      string TestDataPath = RunExamples.GetDataDir();
      using (var layer = Drivers.MapInfoInterchange.OpenLayer(
      Path.Combine(TestDataPath, "data.mif")))
      {
      Console.WriteLine($"Number of features is {layer.Count}.");

      var lastGeometry = layer[layer.Count - 1].Geometry;
      Console.WriteLine($"Last geometry is {lastGeometry.AsText()}.");

      foreach (Feature feature in layer)
      {
      Console.WriteLine(feature.Geometry.AsText());
      }
      }

      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

      Implement Support of TrueType Fonts during PostScript to PDF and Image Conversion

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

      Aspose.EPS for .NETWe are pleased to announce latest release of Aspose.EPS API for both .NET and Java Platforms. In this January release, limitations related to rendering of TrueType Fonts have been removed. There were some limitations in earlier version(s) of the API where Type1 Fonts were used to be rendered as outlines instead of text resulting the restrictions that users cannot perform text search operations over obtained PDF documents. However, those restrictions are removed in latest version of the API and conversion of TrueType Fonts in PS to PDF and Images has been implemented. Furthermore, PS to PDF Conversion Engine is also optimized in this release of the API. In case you are planning to upgrade the API to latest version, you can download it using following links:

      In order to have a look over release notes pages of latest revision, please visit following links:

      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 Documents into PDF using Aspose.XPS

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

      It is our pleasure to announce new revision of Aspose.XPS for both .NET and Java Platforms. As per regular monthly update process, API has been rolled out with new features and enhancements. Various performance improvements are also part of this release of the API. In order to download and use the latest release of the API, please visit following links as per your working environment e.g. .NET and Java:

      Release Notes for both .NET and Java APIs can be found over following links:

      Following section includes insights into most interesting features included in latest release:

      Convert XPS Documents into PDF

      There has been anticipations for the feature since very first release of the API and now long awaited feature to convert XPS documents into PDF format has been introduced. With latest release of the API, you will be able to convert XPS documents into PDF format and you can also check demonstration of this functionality in API documentation over following link(s):

      • Convert XPS to PDF using Aspose.XPS for .NET and Java

      Aspose.XPS for .NET and Java Resources

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

      • Home page for Aspose.XPS API.
      • Aspose.XPS API wiki docs– Help documentation and API reference documents.
      • Aspose.XPS product family forum– Post your technical questions, queries and any other problem you faced while running Aspose.XPS APIs.
      • Enable email subscription– Do not limit yourself, stay up-to-date with the latest news about the Aspose.XPS APIs and new features, fixes, plus other API related topics by subscribing to Aspose.XPS Blog.
      • Aspose.XPS 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.XPS 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.XPS Product Family, Asad Ali | Leave a comment

      Convert PDF into EMF using Aspose.PDF

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

      We are honored to announce 19.1 version of Aspose.PDF API which has been rolled out with a lot of improvements in terms of performance and usability. API has already been published and is available for download and to be used in both .NET and Java Applications. In this release of API, more than 30 improvements have been included along with various enhancement in existing functionalities. In case you are planning to download and consume this revision of the API, you may please navigate over following links in order to download it as per your platform e.g. .NET/Java:

      While using the latest release of the API, it is always recommended to have a detailed look over its release notes. Release notes of the API contain complete information of new improvements in the API as well as Public API Changes which are part of new revision. Following links will take you to the release notes page(s) of the API in documentation:

      Following section offers highlights of worth mentioning enhancements in this release of the API.

      Convert PDF into EMF

      Converting PDF into EMF was already supported in Aspose.PDF API. However, using new revision of the API, you can achieve better results as new improvements have been made to PDF to EMF Conversion Engine to produce fine images. Following code snippet shows usage of this conversion feature:

      [C#.NET]

      Document doc = new Document("c:/pdftest/document_with_table.pdf");
      Aspose.Pdf.Devices.EmfDevice emf =
      new EmfDevice(new Aspose.Pdf.Devices.Resolution(300));

      emf.Process(doc.Pages[1], "c:/pdftest/document_with_table.emf");

      Improvements in Aspose.PDF v19.1

      As mentioned above, there are various improvements which have been included in this release of the API to increase its usability factor and performance. Following list shows some highlights about these improvements:

      • Following Conversion Engines have been improved further:
        • PDF to TIFF
        • PDF to Image
        • HTML to PDF
        • PDF to SVG
        • PDF to PPTX
        • PDF to HTML
        • PDF to PDF/UA
        • PDF to PDF/A
        • PCL to PDF
      • Improvements have been made for Text editing and replacement scenarios
      • PDF Security features have been optimized
      • Memory consumption has been improved further
      • PDF Flattening feature has been further improved
      • Concatenation operations of PDF Documents have been optimized for better performance

      Aspose.PDF for .NET and Java Resources

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

      • Home page for Aspose.PDF API.
      • Aspose.PDF for .NET and Java wiki docs – Help documentation and API reference documents.
      • Aspose.PDF product family forum – Post your technical questions, queries and any other problem you faced while running Aspose.PDF APIs.
      • Enable Email Subscription – Do not limit yourself, stay up-to-date with the latest news about the Aspose.PDF APIs and new features, fixes, plus other API related topics by subscribing to Aspose.PDF blog.
      • Aspose.PDF 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.PDF 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.PDF Product Family, Asad Ali | Leave a comment

      Support for JDK 11 with Aspose.Note for Java 19.1

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

      We are pleased to announce the release of Aspose.Note for Java 19.1. In this release, the support for JDK 11 has been added. This release also includes enhancement in Jpeg Quality in output document. For a detailed note on what is new and fixed, please visit the release notes section of API documentation.

      Aspose.Note Compatibility with JDK 11

      This month’s release provides compatibility for JDK 11. It can be used either with -jdk17 or -jdk18 library versions on JRE 11 environmentThis release also improves the image quality for JPEG in output documents.

      API Resources

      • Documentation – Visit our documentation section for getting started with the API in no time
      • API Reference Guide – Gives detailed information about all the namespaces, classes and methods of the API
      • Forum Support – Post your queries on Aspose.Note forum to get assistance from our technical support team
      • GitHub Examples – Try the ready-to-use examples of the API by downloading from our GitHub repository
      Posted in Aspose.Note Product Family | Leave a comment

      Improved Support of Page Break and Added New Configuration Option to Break Row Across Page

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

      Aspose.Words for JasperReports logoWe are pleased to announce new release of Aspose.Words for JasperReports. We have upgraded this release to the latest version of Aspose.Words for Java 19.1 and fixed an issue related to bottom margin of page. Moreover, we have added new configuration option BREAK_TABLE_ROWS to work with row break across page. We have added another feature to break the page when page setting is changed e.g. page orientation. In such case, the page break is inserted even when PAGE_BREAKS configuration option is set to FALSE.

      Please see the release notes for more detail. You can download the latest release of Aspose.Words for JasperReports 19.1 from the following link:

      Download Aspose.Words for JasperReports 19.1

      Starting from release 1.9.0 there are several versions of jar library (necessary for better support of older versions of JasperReports). Aspose.Words’ jar file names for JasperReports versions are mentioned below.

      • 7.1.0 and higher (aspose.words.jasperreports-7.1.0.jar)
      • 6.4.2 … 6.4.3 (aspose.words.jasperreports-6.4.2-6.4.3.jar)
      • 6.3.0 … 6.4.0 (aspose.words.jasperreports-6.3.0-6.4.0.jar)
      • 6.0.0 … 6.2.1 (aspose.words.jasperreports-6.0.0-6.2.1.jar)
      • 5.6.0 … 5.6.1 (aspose.words.jasperreports-5.6.0-5.6.1.jar)
      • 4.7.0 … 5.5.0 (aspose.words.jasperreports-4.7.0-5.5.0.jar)
      • 3.7.2 … 4.5.0 (aspose.words.jasperreports-3.7.2-4.5.0.jar)

      Note that there is no more support of JasperReports 3.7.1 and lower versions. Please copy only one jar library according to the version of installed JasperReports.

      Aspose.Words for JasperReports Resources

      The following resources will help you work with Aspose.Words for JasperReports:

      Posted in Aspose.Words Product Family | Leave a comment

      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