Track conversion progress in image rendering with Aspose.Cells for .NET 19.10

Share on FacebookTweet about this on TwitterShare on LinkedIn
Aspose.Cells for .NET logo Conversion of Excel spreadsheets to image formats always remains a hot topic. Sometimes, you claim the process takes too long. Others complain that the process gets stuck for larger files and they need to stop the process. Aspose.Cells has now included a useful feature where you can track the conversion progress in Sheet to image rendering in the way you want, you may notice which pages are being rendered in the process at the moment. You can also render your desired pages and skip your unwanted pages. There are some other useful features which might attract you. We suggest you to have a look at the release notes to get the complete list of features, enhancements and other fixes which are part of this new release. Let’s not wait another moment to review the release notes.  To get essence of the public release (Aspose.Cells for .NET v19.10), I am giving you preview of the new features and other enhancements available in it.

Track conversion progress of Excel files

You are working with large Excel files and converting them to other formats. Sometimes it may take a lot of time for conversion and you want your user to be aware of the progress. No worries!!! This latest release has provided this long-awaited feature to track conversion progress of Excel files. Aspose.Cells supports tracking document conversion process by providing the IPageSavingCallback interface. The IPageSavingCallback interface provides PageStartSaving and PageEndSaving methods that you can implement in your custom class. You may also control which pages are rendered as demonstrated in the TestPageSavingCallback custom class. The following code sample loads the source excel file and prints its conversion progress in the console by using the TestPageSavingCallback custom class that implements the IPageSavingCallback interface.
The following is the code for the TestTiffPageSavingCallback custom class.
Console output:
The following article demonstrates the feature with sample code for your reference. Track Conversion Progress of Excel to TIFF

Set custom DataSource for WorkbookDesigner in Smart Markers

We all know how useful is the Smart Markers feature when it comes to data binding or merging. Aspose.Cells provides an option to set custom DataSource for WorkbookDesigner. The API provides an overloaded method WorkbookDesigner.SetDataSource which takes the name of the source as the first parameter and the instance of the class that implements ICellsDataTable as the second parameter. In the following article, you will learn the feature with sample code and files for your reference. Set custom DataSource for WorkbookDesigner

Support custom data sorting for the specific area in PivotTable report

You have a pivot table and you want to sort it on field values. This is easily achievable now as you can use PivotField.AutoSortField attribute by providing item index to sort. Using this feature you will get a variety of data representation for analysis and reporting purpose. In the following article, you will see the result of this function along with a detailed sample code and files for testing. Custom sorting in Pivot Table
In the above article, the sample code snippet loads the sample Excel file and adds three pivot tables. The first pivot table is without custom sorting, the second pivot table is sorted on "SeaFood" row field values and the third pivot table is sorted on "28/07/2000" column field values.

Working with Content Type Properties

MS Excel file contains a few default properties like size, title, tag etc. but you want to add more custom properties for your requirements. Aspose.Cells has introduced this feature by providing Workbook.ContentTypeProperties.Add method. You can also mark a property as optional by setting the ContentTypeProperty.IsNillable to true. Following are the sample code and image showing the newly added properties.
The following document demonstrates the feature with sample code for your reference. Working with ContentTypeProperties

Other enhancements and fixes

  • Raise Exception similar to Excel instead of hanging program.
  • Extend Range.RemoveDuplicates.
  • Range.Copy performance for large volume.
  • Support for TEXTJOIN() function.
  • OLE objects become pictures when copying worksheets.
  • Fixed an error where Saving as HTML was throwing an exception when the cell has a file reference.
  • Handled an exception when calling Workbook.RemoveUnusedStyles().
To use these features and avail other enhancements and fixes, I recommend you to try the release Aspose.Cells for .NET v19.10. Moreover, I recommend you to browse Developers’ Guide for your complete reference on what you can deliver using the APIs. Also, you are always welcome to share your review, concerns or feedback on forums.
Posted in Aspose.Cells Product Family | Leave a comment

Track conversion progress to TIFF with Aspose.Cells for Java 19.10

Share on FacebookTweet about this on TwitterShare on LinkedIn
This image has an empty alt attribute; its file name is aspose_cells-for-java-e1558954178996.jpg

We are happy to share the release of the latest version of Aspose.Cells for Java v19.10 having a long-awaited feature of tracking the conversion progress of huge files. This is not the end of features in this release as it also supports custom data sorting for the specific area in PivotTable report and provides Workbook.ContentTypeProperties.Add method to add custom ContentTypeProperties to an excel file. Many other enhancements and bug resolutions are there in this release. Details of all the new features, enhancements and bugs resolution can be seen in the release notes. Just download the latest release and start testing the exciting features in Aspose.Cells for Java v19.10. Let us have a brief look at this new release.

Track conversion progress of Excel files

You are working with large Excel files and converting them to other formats. Sometimes it may take a lot of time for conversion and you want your user to be aware of the progress. No worries!!! This latest release has provided this long-awaited feature to track conversion progress of Excel files. Aspose.Cells supports tracking document conversion process by providing the IPageSavingCallback interface. The IPageSavingCallback interface provides PageStartSaving and PageEndSaving methods that you can implement in your custom class. You may also control which pages are rendered as demonstrated in the TestPageSavingCallback custom class. The following code sample loads the source excel file and prints its conversion progress in the console by using the TestPageSavingCallback custom class that implements the IPageSavingCallback interface.

The following is the code for the TestTiffPageSavingCallback custom class.

Console output

Visit the following article for more information and sample files.

Support custom data sorting for the specific area in PivotTable report

You have a pivot table and you want to sort it on field values. This is easily achievable now as you can use pivotField.setAutoSortField() function by providing item index to sort. Using this feature you will get a variety of data representation for analysis and reporting purpose. In the following article, you will see the result of this function along with a detailed sample code and files for testing.

In the above article, the sample code snippet loads the sample excel file and adds three pivot tables. The first pivot table is without custom sorting, the second pivot table is sorted on “SeaFood” row field values and the third pivot table is sorted on “28/07/2000” column field values.

Working with Content Type Properties 

Excel file contains a few default properties like size, title, tag etc. but you want to add more custom properties for your reference. Aspose.Cells has introduced this feature by providing Workbook.ContentTypeProperties.Add method. You can also mark a property as optional by setting the ContentTypeProperty.IsNillable to true. Following are the sample code and image showing the newly added properties.

You may visit the following link for more details and sample files:

Other enhancements

  • An issue was reported about the performance of calculateFormula(). This issue is resolved by implementing more robust logics covering maximum scenarios.
  • While converting Excel file to PDF, Pivot table data colouring and formatting was not rendering properly. This issue is resolved now.
  • We have improved our product for conversion to PDF like keeping the similar layout as in the source Excel file, appropriate space between the widgets and exact size of images.
  • A bug is removed like Cell.getStyle.getCustom was returning the wrong format for German locale but now the correct value is returned.
  • Exception ArrayIndexOutOfBoundsException while loading the Excel file is removed.

So we are done for now and take your time to try all these new features. Use the following resources to get more information and sample code for testing this latest release.

Posted in Aspose.Cells Product Family | Leave a comment

Support for AMP HTML Email in Aspose.Email 19.10

Share on FacebookTweet about this on TwitterShare on LinkedIn
aspose-email-for-android-via-java

We are pleased to announce the release of Aspose.Email for .NET and Java 19.10. As a standard practice, Aspose team publishes both .NET and Java based API having same features sets simultaneously. This release includes enhancements and bug fixes which improve the overall functionality of the API. It can now support AMP HTML Emails. For this purpose, AMP property has been introduced.

AMP HTML in Aspose.Email

Accelerated Mobile Pages are developer’s package from Google that help to develop a light-weight system with additional speedy masses. AMP is a web component framework and a website publishing technology made up of CSS, HTML, JavaScript developed by Google that help user to load web page more faster. AMP support many components like carousels, forms, images. Now by using this technology in Aspose.Email, user can download message more faster.

For more details visit here.

The similar Java based example for this is:

There’s many other features, enhancement, and bug fixes included in this release. Here you can get the detail!

When time allows you can check out API examples at Github, talk about this release and other API related issues in our forum.

Posted in Aspose.Total Product Family | Leave a comment

Web Extensions – Office Add-ins Task Panes Supported by Aspose.Words for Java 19.11

Share on FacebookTweet about this on TwitterShare on LinkedIn

Its great pleasure to share that we have achieved another milestone by publishing new release of Aspose.Words for Java i.e. 19.11 that supports Harfbuzz Shaper plugin on Unix-based operating systems and will enable developers to work with Web Extensions, customize the formatting of the horizontal rule shape etc. Details of all the new features, enhancements and bugs resolution can be seen in the release notes. This latest release Aspose.Words for Java v19.11 can be downloaded from the download section. Let us have a brief look at the salient features of this exciting release.

Work with Web Extensions and Task Panes

Aspose.Words API provides the WebExtensions namespace that provides various classes to customize elements and attributes extending the XML vocabulary for representing Office Add-ins. You can now use Aspose.Words for Java to work with Task Panes in Office Add-ins and Web Extensions. For this purpose, it provides new TaskPane class, TaskPaneCollection class, TaskPaneDockState enumeration, Document.WebExtensionTaskPanes property etc.

The following code example demonstrates how to create task panes and add to web extension task panes with basic properties.

Customize Formatting of Horizontal Rule Shape

Aspose.Words for Java API now provides Shape.HorizontalRuleFormat property to access the properties of the horizontal rule shape. The HorizontalRuleFormat class exposes basic properties like Height, Color, NoShade etc. The following code example demonstrates how to set HorizontalRuleFormat to format a horizontal rule.

Macros Support Improved

Aspose.Words for Java API provides Dcoument.VbaProject property to get or set VbaProject in the document. The following code example demonstrates how to create a VBA project and VBA Module along with basic properties e.g. Name and Type.

See also Useful Links

Keeping the Aspose tradition, you are welcome to shape the upcoming releases of Aspose.Words for Java API by posting your suggestions and concerns in the Aspose.Words for Java Support Forum.

Posted in Aspose.Words Product Family | Leave a comment

AMP HTML Emails in Aspose.Email v19.10

Share on FacebookTweet about this on TwitterShare on LinkedIn

Recently, Google announced that AMP HTML email is now live. And now it is already supported by Aspose.Email. It was added in Aspose.Email for .NET 19.10 Release and you can already update your version to check out the advantages of AMP HTML emails support.

Use AMP HTML for emails

AMP (Accelerated Mobile Pages) is a developer’s package from Google that allows developing a lightweight system with more rapid loads. AMP is a framework made up of HTML, JavaScript and CSS, which are the standard to provide a user-first format for web content.
By using parts of Google’s AMP Project for email, we presently possess a plenty list of components to be used. The primary advantage of this approach is to increase message download speed, that is critical while working with users. So right now all customers of Aspose.Email can use AMP HTML to provide the same familiar messages but a little bit faster.

Find more about AMP HTML update.👈

HTML to Text conversion improvements

While working with HTML emails there is one typical task – HTML to Text conversion.
It’s a common case to send a plain-text version of your HTML email or collect it in text, but writing it from scratch can be tedious. Therefore, you can apply conversion functions of our library to avoid difficulties with that. This feature exists a lot of time, but now we have made some improvements, which will improve your user experience.

This release has provided more accurate HTML to Text conversion

Check the example here.👈

SMTP and IMAP servers access improvements

Using AMP HTML emails and Text is useful while working with emails, but sometimes you need to access SMTP and IMAP servers to process them. To do it, you should use OAuth. This approach is implemented frequently in modern applications, and it is supported by Aspose.Email for a long time.

There is no limit to perfection, so we are constantly improving features to improve user interaction with our library – EWS client now supports OAuth authentication. OAuth supports different ways for retrieving an access token, and Microsoft may change them. Therefore a customer may implement a simple interface of a token provider by himself to make the code more general-purpose.

Find more example here.👈

You can find more enhancements here Aspose.Email for .NET 19.10 Release Notes.

Posted in Aspose.Email Product Family | Leave a comment

Font Kerning and Emulation support in Aspose.HTML API

Share on FacebookTweet about this on TwitterShare on LinkedIn

You will be excited to know that Aspose.HTML API now supports Font Kerning. It will notably improve the quality of text rendering. In a nutshell, Kerning is the contextual adjustment of inter-glyph spacing. It is used to adjust the spacing between characters and is supported by many fonts. We have also implemented emulation of bold fonts which is useful in scenarios when some font is not available on a machine.

Moreover, we have improved the processing of HTML document modes which enables the document to work better in limited-quirks mode. Some other improvements pertaining to MHT and XPS rendering have also been made in this release. Image rendering is one of the most widely used feature of Aspose.HTML API. We have further improved image rendering by changing the behaviour of text rendering methods. Information about rendered characters is now utilized and each character’s position is determined to ensure correct rendering.

A more closer overview of this release can be found in Release Notes and working examples can be found in Example Project. We value and appreciate your feedback that helps us to keep improving the API, so your feedback and suggestions are welcome in Aspose.HTML forum.

Posted in Aspose.HTML Product Family | Leave a comment

Swiss QRCode support with Aspose.BarCode for .NET v19.10

Share on FacebookTweet about this on TwitterShare on LinkedIn

We are glad to roll out our latest release of Aspose.BarCode for .NET v19.10 having support for widely used Swiss QRCode. This new feature will make developers capable of developing applications to use it on bills, making digital payments, product packaging, railways, bike-sharing and even for buying bitcoins. Details of all the new exciting features can be found in the release notes containing a list of all the new added features, bugs resolution and public API changes which a developer should know for working with latest upgrades. So let us jump into this new release and see how these new features can be used.

Generate Swiss QR Code

One of the important usages of Swiss QR Code is to replace the previous payment slips. For this purpose, detailed information is required to trigger payments and process the QR invoice. Aspose.BarCode has provided all those necessary payment information by introducing new classes  SwissQRBill and  SwissQRCodetext which provide a large number of properties required to work with the Swiss QR Codes.

Here is a detailed example for generating the Swiss QR Code. To perform this activity you have to instantiate a  ComplexBarcodeGenerator instance and provide SwissQRCodetext containing all the necessary information for billing.

Following is the output Swiss QR Code generated with the above code sample:

You may visit the following link for this example and other details in the developers’ guide.

Generate Swiss QR Code

Reading the Swiss QR Code

As mentioned earlier, Swiss codes are widely used so reading is also implemented for a wide range of Swiss QR Codes. A new class ComplexCodetextReader is to be instantiated by setting the DecodeType.QR. Following is the sample code which reads a Swiss QR Code and displays the detail.

For more details visit here.

Read information from Columbia Id cards and driving license

For testing purpose, we tried our product on a few used Columbia Id cards and driving license. It was a success and all the information was read successfully however few enhancements were done to read the information without any error. As we know that Pdf417 is used in this case which is a stacked linear barcode format used in a variety of applications such as transport, identification cards, and inventory management. “PDF” stands for Portable Data File. The “417” signifies that each pattern in the code consists of 4 bars and spaces in a pattern that is 17 units (modules) long. We have made the following enhancements in this case:

  • Enhance restoration methods for blurred Pdf417 barcodes
  • Improve basic recognition quality
  • Avoid failures during image to text conversion
  • Investigation for a multithreaded framework for Zebra target detection

Enhancement to read the whole length of the barcode

There was an issue while reading whole length of the barcode as the whole text was not read and the partial text was returned by the API. A detailed investigation was done and observed that current wiped bar restoration works only for NBase and need changes which could be implemented for WBase based barcodes. Another problem is the absence of checksum in Code39 barcodes, which doesn’t allow to check if the result correct. All these issues were resolved and this issue was sorted out by enabling the wiped bars option.

Following sample code reads the whole length of the barcode.

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

Work with Fonts using Aspose.Font for .NET

Share on FacebookTweet about this on TwitterShare on LinkedIn

TrueType font (TTF) indicates that font data is the same as in the TrueType fonts. CFF stands for the Type1 font format. Strictly speaking, it refers to the Compact Font Format, which is used in the compression processes. Dealing with such fonts programmatically i.e. Reading them and Getting their Statistics is an essential requirement while creating e-documents. Aspose is proudly going to release Aspose.Font for .NET to let programmers deal with fonts in their .NET applications. Aspose.Font is going to become a new member of Aspose APIs Family and with its introduction, the product catalog of Aspose will be extending elegantly. Let’s have a peek inside what this new API will be offering in its first release and when you will be able to use it in your applications.

Initial Features of Aspose.Font for .NET

The first release of Aspose.Font for .NET API will be compiled for the following .NET Frameworks:

  • 2.0
  • 3.5
  • 3.5 Client profile
  • 4.0
  • 4.0 Client profile

It will provide the capability to read fonts (TTF and CFF) as well as their statistics. You will be looking at a complete guide on how to use Aspose.Font for .NET in your applications with the help of full-fledged working code samples in C#.NET. The first version of the API would also offer a feature to draw simple text using desired colors with Aspose.Font API.

Availability of First Version

Dealing with Fonts and their glyphs to map dimensions and colors is not a trivial task and it definitely needs a significant amount of time to get it completed. Well, the good news is that API is on its final stage to get published with consolidated functionality. It is intended to be released at the end of this year (2019) or at the start of the year 2020. We encourage you to drop your inquiries about Aspose.Font in its support forum and don’t miss any new update by subscribing to our blog. We really hope to see you soon with the new update of the API.


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

Support of Web Extension and .NET Core 3.0 in Aspose.Words for .NET 19.11

Share on FacebookTweet about this on TwitterShare on LinkedIn

It is our pleasure to announce November release of Aspose.Words for .NET. We have included quite exciting features and enhancements in this release. Now, you can add Web extension elements in Word document, format the horizontal rule, and use Aspose.Words with .NET Core 3.0. let’s check out how to use newly introduced features.

Support of Web Extension Elements

Microsoft Office allows you to add more functionality through web extension. It extends Office applications and interact with the content in Office documents. Web Extension adds additional functionality to Office client to improve the user experience and productivity.

How to work with Web extensions using Aspose.Words? Well, it is not magic.

We have added Aspose.Words.WebExtensions namespace in this release to work with Web extensions. This namespace allows you to customize elements and attributes that extend the XML vocabulary for representing Office Add-ins. Please read following article about working with Web extensions.

Working with Web Extensions

Format Horizontal Rule

Adding horizontal line in MS Word document is sometime called horizontal rule. We have added new feature in this release to format the horizontal rule. In previous versions of Aspose.Words, you can add it using DocumentBuilder.InsertHorizontalRule method. However, formatting of horizontal rule was not supported. We have added Shape.HorizontalRuleFormat property and public class HorizontalRuleFormat in this release to format the horizontal rule. Now, you can set height, width, color, alignment, and 3D shading of it using this release of Aspose.Words. Following code example shows how to format horizontal rule.

Improved Macros Support

Aspose.Words already provides API to read and write the VBA Project. In this release, we have improved the macros support. Now, you can set the name of VBA project, read the VBA project’s code page, read and write VBA module name, add and remove VBA module. Following code example shows how to set properties of VbaProject and VbaModule classes.

Aspose.Words.MailMerging.MailMergeRtlCleanupMode was removed

We have removed obsolete enum Aspose.Words.MailMerging.MailMergeRtlCleanupMode from Aspose.Words’ API.

When time allows you can check Aspose.Words’ API reference guide, examples at Github, talk about this release and other API related issues in our forum.

We recommend you please check the release notes of Aspose.Words for .NET 19.11 for complete detail of API changes.

Posted in Aspose.Words Product Family | Leave a comment

Support for Font FallBack and Prompt Text using Aspose.Slides for C++

Share on FacebookTweet about this on TwitterShare on LinkedIn

Here comes new release of Aspose.Slides 19.10 for C++, which has been enriched with new features. Now, we offer support for Font FallBack and Prompt Text using Aspose.Slides.

Support For Font FallBack

A Font Fallback is a reserve type containing symbols for as several Unicode characters as doable. When a display system encounters a character that is not part of the repertoire of any of the other available fonts, a symbol from a fallback font is used instead. Normally, a fallback font style will contain images illustrative of the different sorts of Unicode characters. For this purpose a new method IFontFallBackRule has been added in Aspose.Slides for C++.

The following code example shows how to set font fall back using FontFallBackRule objects.

For more details visit here.

Set Prompt Text in a Placeholder

A Prompt Text is a content that shows up in a content field when it is first load however that disappears when a client begins composing into the content field. This is essentially for client straightforwardness to become more acquainted with what is to be entered in the chose field. We know that Standard and pre-built layouts contain placeholders with default text like Click to add a title or Click to add subtitle. Using Aspose.Slides you can add prompt text manually by accessing the default placeholders.

The code snippet below shows how to use this feature:

For more details visit here.

Wait, there’s many other features, enhancement, and bug fixes included in this release. Here you can get the detail!

When time allows you can check out API examples at Github, talk about this release and other API related issues in our forum.

Posted in Aspose.Slides Product Family | Leave a comment