Improved Page Orientation and Table Position in Aspose.Words for JasperReports 18.8

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 18.8 and fixed the issues related to page orientation and table position. Please see the release notes for more detail. You can download the latest release of Aspose.Words for JasperReports 18.8 from the following link:

Download Aspose.Words for JasperReports 18.8

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

Upgraded Aspose.Words for Reporting Services to Aspose.Words for .NET 18.8

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

Aspose.Words for SSRS iconWe are pleased to announce new release of Aspose.Words for Reporting Services. We have upgraded this release to Aspose.Words for .NET 18.8. Please see the release notes for more detail. You can download the latest release of Aspose.Words for Reporting Services 18.8 from the following link:

Download Aspose.Words for Reporting Services 18.8

 

Aspose.Words for Reporting Services Resources

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

Posted in Aspose.Words Product Family | Leave a comment

Improved API Performance with Aspose.Tasks for .Net 18.9

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 18.8. This release gives you the power to read activity codes for XER files. It also fixes several 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.

Improvements in Aspose.Tasks for .NET 18.9

This release of Aspose.Tasks for .NET API introduces the ability to read activity codes for XER files. It adds many bug fixes which make the API a pleasure to use. Following is a list of all the changes in this month’s release.

  • Ability to read activity codes for XER files.
  • Scheduling of recurring daily tasks has been fixed.
  • Time-phased data for material resources has been fixed.
  • Issues with formula calculation have been fixed.
  • After exporting to MPX, the number of task links generated was wrong. This issue has also been addressed.
  • Exceptions while loading MPP files have been handled.
  • Custom fields’ values are now formatted properly when saved as PDF.

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

Enhancements in the Barcode Generator API with Aspose.Barcode for Reporting Services 18.8

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

We are pleased to announce the release of Aspose.Barcode for Reporting Services 18.8. In this release, the Barcode Generation API you already love grows even more powerful. It gives you more power for generating Barcodes with desired information. For a detailed note on what is new and fixed, please visit the release notes information of API documentation.

Enhanced Barcode Generation API

The new Barcode Generation API, represented by BarcodeGenerator class, is simple but powerful enough to give maximum control over Barcode generation as per requirements. The API grows even stronger with the addition of new features and bug fixes in this new release. Following is the list of enhancements made to the Barcode Generation API

  • Added UpcaGs1DatabarCoupon for new Barcode generation API.
  • Interpolation AutoSize mode added in new renderers
  • MaxiCode renderer added in new Barcode generation API
  • DotCode renderer added in new Barcode generation API
  • Code16K Barcode drawn without above and below borders
  • GS1 Datamatrix Barcode wrapping issue in case of CodeLocation.Right

You can download the latest version of Aspose.Barcode for Reporting Services by visiting the Aspose.BarCode for Reporting Services 18.8 page in the downloads section.

Aspose.BarCode for Reporting Services Resources

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

Posted in Aspose.BarCode Product Family | Leave a comment

12th Wonder uses Aspose.Cells to extract PDF from Excel file

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

12th Wonder specializes in creating solutions to solve complex business problems. We had to provide a solution for displaying complex excel documents within an ASP.Net MVC application. We tried many solutions including writing custom code to convert excel to pdf, but we figured out the effort to maintain custom code is very high. So we decided to do a POC using Aspose.Cells product.

The formatting and layout of the excel file that we wanted to display as a PDF document within our MVC application were really complex and immutable. The excel sheet has multiple worksheets and each sheet contains 5 or more pages laid out side by side.  While displaying the excel sheet as pdf, we converted each worksheet into a separate document, with each document having a variable number of pages. The Excel also contains plain text, images, text boxes, custom formats such as double borders, strikeout cells, and different font styles. The fidelity of the generated pdf is really critical.

Please see the below for a screenshot of a single page from the uploaded excel file.


 

The sample code below is used to read the first page from the first worksheet in the uploaded excel file using the excellent Aspose.Cells library.

The first step is to initialize the Aspose.Cells object using the code below

//Load your Excel file

Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(“<Specify your file path>”);

The library has multiple overloaded methods that make it easy to read a specific worksheet.  The worksheet can be read either with the index of the worksheet or the by name of the worksheet.

//Access the worksheet

Aspose.Cells.Worksheet sourceSheet = wb.Worksheets[“<give the worksheet name>”];

To read the range in the selected worksheet, in my case I am reading from A4 to AE52.

//Read the range from Cell A4 to Cell AE 52

sourceSheet.PageSetup.PrintArea = “A4:AE52”;

After setting all the custom properties Aspose.Cells product will do the job and covert the specified range spreadsheet into PDF file.  Use the following code to generate the pdf file

//Save to Pdf – one page per sheet true

Aspose.Cells.PdfSaveOptions pdfSaveOptions = new Aspose.Cells.PdfSaveOptions();

pdfSaveOptions.OnePagePerSheet = true;

pdfSaveOptions.PageIndex = sourceSheet.Index;

pdfSaveOptions.PageCount = 1;

wb.Save(destFilePath + “_” + DateTime.Now.ToShortDateString() + “.pdf”, pdfSaveOptions);

Here is my output file, after generating PDF file.

Visually, there is no difference between the uploaded excel and generated pdf page.

Please see below for the complete source code

Aspose.Cells is an excellent library to convert excel to pdf. We had no problems in completing the POC in less than a day.

Posted in Customer Reviews | Leave a comment

Apply text alignment to partial text inside TextBox and disable Pivot Table ribbon using Aspose.Cells for JavaScript via Java 18.8

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 18.8. This release includes a number of 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

Applying text alignment to partial text inside the TextBox

It is very common to apply different alignments to the partial texts in the text box. This feature was having some issues but now it is reviewed and bugs are removed to incorporate proper alignment.   

For a working example refer to the following article:

Content Copying for accessibility

This option allows screen reader software to utilize the text within the PDF file for reading.  You can disable it by applying a change permissions password and deselecting few options in Adobe Acrobat. Same functionality can be achieved  using Aspose.Cells for JavaScript via Java now. 

For a working example refer to the following article:

Disable Pivot Table Ribbon 

Pivot table based reports are useful but prone to error if target users do not have detailed knowledge of Excel to configure these reports. In these circumstances organizations will want to restrict users from being able to change a pivot table based report. Common pivot table features like adding additional filters, slicers, fields, or changing the order of certain things in the report are mostly not recommended for every user. On the other hand, these users shall also be able to refresh the report and use existing filters or slicers. Aspose.Cells has provided this ability to developers for restricting users from changing these reports while creating them. For this purpose Excel provides feature to disable pivot table ribbon and same is provided by Aspose.Cells i.e. developer can disable the ribbon which contain controls to modify these reports.

For a working example along with a template file refer to the following article:

Improvements in process interruption 

Reliability and efficiency is basic requirement by the users for any software product. If some conversion takes too long, sometimes it is required to interrupt this process to return control to the user. This feature is already present but got some performance issues, however we have further improved it and now can be used without any trouble.  

For a working example refer to the following article:

Pasting rows/columns with paste option 

While working with Excel, pasting rows and columns is very common and this feature was introduced in the earliest versions of Aspose.Cells. However limited paste option was available in contrast to Excel where variety of options are available when we paste data somewhere in Excel. Now Aspose.Cells has provided this feature and you can paste data with multiple options.   

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. In Aspose.Cells for JavaScript via Java v18.8, we fixed several important bugs and other issues. For example, issues of not drawing the vertical line at the center of the chart, reading water mark from file, unnecessary text in property comment, retaining the macros in ODS files and rendering exception while converting worksheet to image. 

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 PdfSecurityOptions.AccessibilityExtractContent, Permission to copy or extract content (in support of accessibility to disabled users or for other purposes)
  • Adds SubtotalSetting class, Represents the setting of subtotal.
  • Adds Cells.RetrieveSubtotalSetting(CellArea) method, Retrieves the setting of subtotal
  • Adds overload Range.ExportDataTable (Aspose.Cells.ExportTableOptions) method, Supports options of exporting range
  • Adds WebQueryConnection.IsSameSetting property and deletes WebQueryConnection.IsFirstRow property, Use WebQueryConnection.IsSameSetting property instead
  • Adds WebQueryConnection.IsXmlSourceData property and deletes WebQueryConnection.IsSourceData property, Use WebQueryConnection.IsXmlSourceData property instead
  • Adds Shape.IsEquation property, Indicates whether the shape contains equation
  • Adds overload Cells.CopyColumns(Int32,Int32,PasteOptions) and Cells.CopyRows(Int32,Int32,PasteOptions) method, Supports paste options when copying rows and columns
  • Adds Axis.IsAutoTickLabelSpacing property, Indicates whether tick label spacing is automatic

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

Improved API Functionality with Aspose.Email for Java 18.8

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

aspose-email-for-javaWe are pleased to announce the release of Aspose.Email for Java 18.8. This month’s release includes an enhancement for updating member in a PST distribution list (DL) and appending another distribution list (DL) to an existing one. It also includes several other improvements in terms of bug fixes that further add to the overall stability of the API. For a detailed note on what is new and fixed, you may visit the release notes section of API.

Improvements in Aspose.Email for Java 18.8

This release includes improvements to the API’s functionality like creating a contact in sub-folder of contacts using EWS and support of adding attachments to MapiCalendarExceptionInfo. There are certain backward incompatibility changes as well which will need you to update the code samples with the new ones. Following is a list of issues fixed in this month’s release.

  • Creating MapiMessage using MapiMessage.fromMailMessage gets stuck
  • Aspose.Email reads message body as second attachment
  • Wrong CC field after save and reload the message
  • Resaving EML turns Japanese language to garbage
  • Opening PST file raises error
  • Html is added as inline to MapiMEssage
  • EML to MSG disturbs output
  • MHT to MSG embeds header information in message body
  • IEWSClient always returns UTF8 Encoding for Message.BodyEncoding
  • Updating MSG BodyHtml doesn’t change description in Outlook View Pane
  • Sender Type changed from Exchange to SMTP
  • The output message text content is unexpectedly concatenated on couple places
  • Invalid ContentUnreadCount value after splitInto()
  • Task start date/time set to UTC instead of local time

API Resources

We have detailed information available online for getting started with the Aspose.Email for Java API. These are:

Posted in Aspose.Email Product Family | Leave a comment

Enhancements in the Barcode Generator API with Aspose.Barcode for .NET 18.8

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

We are pleased to announce the release of Aspose.Barcode for .NET 18.8. In this release, the Barcode Generation API you already love grows even more powerful. It gives you more power for generating Barcodes with desired information. For a detailed note on what is new and fixed, please visit the release notes information of API documentation.

Enhanced Barcode Generation API

The new Barcode Generation API, represented by BarcodeGenerator class, is simple but powerful enough to give maximum control over Barcode generation as per requirements. The API grows even stronger with the addition of new features and bug fixes in this new release. Following is the list of enhancements made to the Barcode Generation API

For detailed code samples of this new Barcode generator class, please visit the Generating Barcode using BarcodeGenerator article of API documentation.

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

Paste text with paste options and disable pivot table ribbon using Aspose.Cells for Java 18.8

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

We are pleased to announce the release of Aspose.Cells for Java v18.8 having new features, enhancements and bug fixes to supplement the usability of the product and support the developers community. New features are always part of our every release to enrich the product. 
Special effort is made to address all the known issues and fulfill enhancement requests for a rapid development of feature rich market oriented products. Detailed release notes are published as usual for a detailed information about the enhancements, bugs fixing and handling of variety of exceptions in this new release. For an easy access and utilization, Aspose for Java APIs can be directly installed from Maven repository for which check document.

Applying text alignment to partial text inside the TextBox

It is very common to apply different alignments to the partial texts in the text box. This feature was having some issues but now it is reviewed and bugs are removed to incorporate proper alignment.   

For a working example refer to the following article:

Content Copying for accessibility

This option allows screen reader software to utilize the text within the PDF file for reading.  You can disable it by applying a change permissions password and deselecting few options in Adobe Acrobat. Same functionality can be achieved  using Aspose.Cells for Java now. 

For a working example refer to the following article:

Disable Pivot Table Ribbon 

Pivot table based reports are useful but prone to error if target users do not have detailed knowledge of Excel to configure these reports. In these circumstances organizations will want to restrict users from being able to change a pivot table based report. Common pivot table features like adding additional filters, slicers, fields, or changing the order of certain things in the report are mostly not recommended for every user. On the other hand, these users shall also be able to refresh the report and use existing filters or slicers. Aspose.Cells has provided this ability to developers for restricting users from changing these reports while creating them. For this purpose Excel provides feature to disable pivot table ribbon and same is provided by Aspose.Cells i.e. developer can disable the ribbon which contain controls to modify these reports.

For a working example along with a template file refer to the following article:

Improvements in process interruption 

Reliability and efficiency is basic requirement by the users for any software product. If some conversion takes too long, sometimes it is required to interrupt this process to return control to the user. This feature is already present but got some performance issues, however we have further improved it and now can be used without any trouble.  

For a working example refer to the following article:

Pasting rows/columns with paste option 

While working with Excel, pasting rows and columns is very common and this feature was introduced in the earliest versions of Aspose.Cells. However limited paste option was available in contrast to Excel where variety of options are available when we paste data somewhere in Excel. Now Aspose.Cells has provided this feature and you can paste data with multiple options.   

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.

  • Hyperlinks not working when referenced from other sheets
  • Incorrect alignment issue while rendering to PDF
  • Wrong placement of table data from HTML to Excel file
  • Depiction of slicer control while spreadsheet to HTML conversion
  • Improper gradient color rendering to PDF
  • Improper chart category title display in PDF
  • Wrong border style for merged cells

In Aspose.Cells 18.8, we fixed several important bugs and other issues. For example, issues of not drawing the vertical line at the center of the chart, reading water mark from file, unnecessary text in property comment, retaining the macros in ODS files and rendering exception while converting worksheet to image. 

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 PdfSecurityOptions.AccessibilityExtractContent, Permission to copy or extract content (in support of accessibility to disabled users or for other purposes)
  • Adds SubtotalSetting class, Represents the setting of subtotal.
  • Adds Cells.RetrieveSubtotalSetting(CellArea) method, Retrieves the setting of subtotal
  • Adds overload Range.ExportDataTable (Aspose.Cells.ExportTableOptions) method, Supports options of exporting range
  • Adds WebQueryConnection.IsSameSetting property and deletes WebQueryConnection.IsFirstRow property, Use WebQueryConnection.IsSameSetting property instead
  • Adds WebQueryConnection.IsXmlSourceData property and deletes WebQueryConnection.IsSourceData property, Use WebQueryConnection.IsXmlSourceData property instead
  • Adds Shape.IsEquation property, Indicates whether the shape contains equation
  • Adds overload Cells.CopyColumns(Int32,Int32,PasteOptions) and Cells.CopyRows(Int32,Int32,PasteOptions) method, Supports paste options when copying rows and columns
  • Adds Axis.IsAutoTickLabelSpacing property, Indicates whether tick label spacing is automatic

Aspose.Cells for Java Resources

The resources, you may need to accomplish your tasks:

Posted in Aspose.Cells Product Family | Leave a comment

Export range to DataTable, paste text with paste options and disable PivotTable ribbon using Aspose.Cells for .NET 18.8

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


Aspose.Cells for .NET logo
We are pleased to announce the release of Aspose.Cells for .NET v18.8. Please check the document on how to install Aspose for .NET APIs directly from NuGet repository. Every release has new features to enrich the product for its stability and feature rich flavor. In this release, we have added some useful features for the users. We made more efforts to address all the known issues and to fulfill requests for a rapid development of feature rich market oriented products. Moreover, we included important fixes and other enhancements in the release. Please check the release notes in order to get an idea about what is new and what has been enhanced or fixed with this revision of Aspose.Cells for .NET.

Exporting Range with flag to skip column name

Data from a range can be exported to DataTable where a flag is available now to skip/include header row or utilize other options in the exported data.  

For a working example refer to the following article:

Applying text alignment to partial text inside the TextBox

It is common to apply different alignments to the partial texts in the text box. This feature was having some issues but now it is reviewed and bugs are removed to incorporate proper alignment.   

For a working example refer to the following article:

Content Copying for accessibility

This option allows screen reader software to utilize the text within the PDF file for reading the PDF file.  You can disable it by applying a change permissions password and deselecting few options in Adobe Acrobat. Same functionality can be achieved  using Aspose.Cells for .NET now. 

For a working example refer to the following article:

Disable Pivot Table Ribbon 

Pivot table based reports are useful but prone to error if target users do not have detailed knowledge of Excel to configure these reports. In these circumstances organisations will want to restrict users from being able to change a pivot table based report. Common pivot table features like adding additional filters, slicers, fields, or changing the order of certain things in the report are mostly not recommended for every user. On the other hand, these users shall also be able to refresh the report and use existing filters or slicers. Aspose.Cells has provided this ability to developers for restricting users from changing these reports while creating these reports. For this purpose Excel provides feature to disable pivot table ribbon and similar thing is provided by Aspose.Cells i.e., developer can disable the ribbon which contains controls to modify these reports.

For a working example along with a template file refer to the following article:

Pasting rows/columns with paste option 

While working with Excel, pasting rows and columns is very common and this feature was introduced in the earliest versions of Aspose.Cells. However limited paste options were available in contrast to MS Excel where variety of options are available when we paste data somewhere in MS Excel. Now Aspose.Cells has provided this feature and you can paste data with multiple options.   

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.

  • Encrypting/decrypting ODS files
  • Read/write connections of XLSB file
  • Support parsing formulas of revision logs to binary array
  • Retrieve Subtotaling settings
  • Ink Annotations become regular images after conversion
  • Handled exception when calculating formulas
  • Handled exceptions when reading/loading HTML/XLSX file formats

In Aspose.Cells 18.8, we fixed several important bugs and other issues. For example, issues around reading/writing MS Excel file formats, applying auto-fit rows/cols, applying validations, reading/writing HTML files, rendering and manipulating charts and shapes, manipulating PivotTables, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved in the release. Moreover, the Aspose.Cells formula calculation engine is enhanced.

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 PdfSecurityOptions.AccessibilityExtractContent, Permission to copy or extract content (in support of accessibility to disabled users or for other purposes)
  • Adds SubtotalSetting class, Represents the setting of subtotal.
  • Adds Cells.RetrieveSubtotalSetting(CellArea) method, Retrieves the setting of subtotal
  • Adds overload Range.ExportDataTable (Aspose.Cells.ExportTableOptions) method, Supports options of exporting range
  • Adds WebQueryConnection.IsSameSetting property and deletes WebQueryConnection.IsFirstRow property, Use WebQueryConnection.IsSameSetting property instead
  • Adds WebQueryConnection.IsXmlSourceData property and deletes WebQueryConnection.IsSourceData property, Use WebQueryConnection.IsXmlSourceData property instead
  • Adds Shape.IsEquation property, Indicates whether the shape contains equation
  • Adds overload Cells.CopyColumns(Int32,Int32,PasteOptions) and Cells.CopyRows(Int32,Int32,PasteOptions) method, Supports paste options when copying rows and columns
  • Adds Axis.IsAutoTickLabelSpacing property, Indicates whether tick label spacing is automatic

Aspose.Cells for .NET Resources

The resources, you may need to accomplish your tasks:

Posted in Aspose.Cells Product Family | Leave a comment