Detect Hyperlink Type with Aspose.Cells for .NET 19.8

Share on FacebookTweet about this on TwitterShare on LinkedIn
Aspose.Cells for .NET logoHi Guys, in the blog you will learn how to categorize hyperlinks in order to select the appropriate method for processing each of these links. You may also explore and extract embedded MOL file. Moreover, we now provide a solution when rendering bigger files (having millions of pages in the sheet(s)). You may get total page count before converting to PDF/Image, This is a good thing to know to decide whether to render or not to render. You may have a look at the release notes to get the complete list of features and bug fixes which are part of this new release. So let’s not wait another moment to review the release notes.  To get essence of the public release (Aspose.Cells for .NET v19.8), I am giving you preview of the new features and other enhancements available in it.

Detect Hyperlink Type

There can be different types of hyperlinks which can be used in an Excel file like external, cell reference, file path and email. Our new release has introduced an enumerator TargetModeType which represents the type of hyperlink. A new property LinkType is introduced in Hyperlink class which return the hyperlink type using above mentioned enumerator. See the document for your reference. Here is an example which can be used to exercise this new feature.
Program output vs template Excel file

Get total page count before PDF/image creation

Well, the title is explaining this new feature. When a file has too many pages, the process of converting to pdf/image may use too much memory and CPU, and OOM exception may be thrown. Getting total pages count before converting can indicate this risk, and do some actions (e.g. skip this file) or print the selected pages to avoid the undesired results. For example one of my sample Excel file (870 KB) was showing about 38 million pages. Just imagine, what will happen if you come across a conversion containing such a huge number of pages. Following is an example to show the usage of new classes SheetPrintingPreview and WorkbookPrintingPreview. Both of these classes contain a property EvaluatedPageCount which returns the page count of the printout or PDF file.
See the document for your complete reference.

Extracting Embedded MOL File

As you know that molecular data file created in the MDL Molfile format, a chemical file format; contains plain text information and stores information about atoms and bonds; often used as a standard exchange format for molecular information. This type of file can be embedded in the Excel file. In this latest release, support is provided to extract object of such an uncommon type i.e. MOL. The following code snippet demonstrates extracting embedded MOL file and saving it to disk.
See the document for your reference.

Other enhancements and fixes

  • And enhancement is made to Aspose.Cells.GridWeb for compatibility with MVC.
  • Improved performance for calculating large matrix with double values.
  • The document fails to save when saved more than 10 times.
  • Handled an exception when getting image from SheetRender for encrypted ODS file.
  • Handled an excetion when calculating charts on an excel with a number > int.MaxValue.
  • Fixed the error "IndexOutOfRangeException" when using smart marker with a pivot table and saving the workbook.
  • Fixed an error "Index was outside the bounds of the array" while converting XLSX to PDF.
  • Fixed an error "Invalid MsoLineDashStyle string val" when loading an XLSX file format.
To use these features and avail other enhancements and fixes, I recommend you to try the release Aspose.Cells for .NET v19.8. 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.

The post Detect Hyperlink Type with Aspose.Cells for .NET 19.8 appeared first on File Format APIs Blog –

Posted in Conholdate.Total Product Family, Aspose.Cells Product Family | Tagged | Leave a comment

gzip Compression Format Supported by Aspose.ZIP for .NET 19.8

Share on FacebookTweet about this on TwitterShare on LinkedIn

Guys, let’s check out what’s new for you in Aspose.ZIP for .NET 19.8 release.

Retrieve gzip Archive Name

The following code example shows how to open an archive from a stream and retrieve its name.

Compress into a .gz Archive

The following code example shows how to compress a file using GZipArchive instance.

Open gzip Archive for Processing

The following code example shows how to open a gzip archive.

Moreover, to learn how to extract/copy a .gz file into a MemoryStream, please refer to the following article:
Working with gzip Archives

Extraction of Huge Size Archives Supported

Previously, Aspose.ZIP for .NET API was unable to extract a .zip archive with huge size when it contains several entries and compressed size of first entry is above 4 GB. We have fixed this issue in Aspose.ZIP for .NET API 19.8.

See Also Useful Links

The resources, you may need to accomplish your tasks:

Keeping the Aspose tradition, you are welcome to shape the upcoming releases of Aspose.ZIP for .NET API by posting your suggestions and concerns in the Aspose.ZIP for .NET support forum.

The post gzip Compression Format Supported by Aspose.ZIP for .NET 19.8 appeared first on File Format APIs Blog –

Posted in Conholdate.Total Product Family, Aspose.ZIP Product Family | Tagged | Leave a comment

Sign Documents with QR-Code

Share on FacebookTweet about this on TwitterShare on LinkedIn

Why we need eSigning?

As most of the businesses are going green, the need for paperless environment is increasing day by day. This also brings in the need for establishing the authenticity of the documents by signing them electronically. Therefore, eSigning is the very basic requirement and could be considered as the first step towards the paper free world.

Even in the scenarios where you can print the documents out, you may still have to send that back after signing the same. That may also leave you to figure out how you are going to do so, considering the scanners and fax machines going extinct, it is quite likely that your office may not have one either. And that will make eSigning a useful option in this case as well.

Other than these obvious solutions, eSigning is also a cost-effective and time-saving option. It does not need you to print dozens of pages just to sign one of those and send them back through some post taking days.

The GroupDocs.Signature As eSigning Tool

The GroupDocs.Signature makes this task of signing your documents electronically extremely easy and could be integrated into almost all of the commonly available famous document formats. Currently, you can sign your documents with Stamp, Barcode, QR-Code, Text, Image, Metadata, Form Field and Digital signatures, using just a few lines of code along with the GroupDocs.Signature API.

Using the GroupDiocs.Signature you can sign all the pages of a document in one go. It also allows you to save custom data securely encrypted in it along with the useful feature of setting the alignment and appearance of the signature. Apart from signing the documents, this API also allows you to search for the signature and verify it.

Sign Your Documents with QR-Code

Here, in this article, we will discuss how the documents can be signed electronically with QR-Code. A QR-Code consists of black squares arranged in a square grid on a white background, which could be read by an image capturing device such as a camera. The QR-Code could be used to store bank information, contact information, addresses and all kind of private information that you do not want to be tempered with.

Following code represents how a document can be signed with QR-Code in C#:

A signed document will looks like the following screenshot:

You can also get the complete ready to run code samples at GitHub.

The post Sign Documents with QR-Code appeared first on Document Manipulation APIs Blog –

Posted in Conholdate.Total Product Family, Uncategorized | Tagged | Leave a comment

Aspose.Words for C++ and Aspose.Cells for C++ Security Updates

Share on FacebookTweet about this on TwitterShare on LinkedIn

Aspose makes it a top priority to ensure that our products are free of any bugs which may cause security issues for customers. Our internal teams carefully analyze all releases for possible vulnerabilities and to keep on top of emerging threats.

Recently we were made aware of two vulnerability reports from security researcher Cisco Talos.
Unfortunately, there was a long delay in us receiving these reports because Cisco Talos failed to get in touch via one of the many channels on our website, but instead used incorrect email addresses. However, as soon as we were independently made aware of these reports our development teams responded quickly and we were able to release fixes to these issues within 5 business days.

All customers affected were alerted via email, however, the issues are summarised below:

Aspose.Words for C++ 19.8 or earlier
CVE Number: CVE-2019-5041
Description: An exploitable Stack Based Buffer Overflow vulnerability exists in the EnumMetaInfo function of Aspose Aspose.Words for C++.
Reported to Aspose: 23-Aug-2019
Fix Released: 29-Aug-2019

Aspose.Cells for C++ 19.4 or earlier
CVE Number: CVE-2019-5041, CVE-2019-5032
Description: An exploitable out-of-bounds read vulnerability exists in the Number record parser and LabelSst record parser of Aspose.Cells for C++.
Reported to Aspose: 23-Aug-2019
Fix Released: 29-Aug-2019

It is our assessment that the vulnerabilities would be extremely difficult for an attacker to make use of in the real world, but that does not stop us taking the issues seriously and addressing them quickly. We encourage customers of Aspose.Words for C++ and Aspose.Cells for C++ to download the latest versions from the below links:

By keeping their Aspose product support & maintenance subscription up-to-date, customers can ensure they always to get instant access to the latest bug and security fixes, as well as great new features added in every release.

The post Aspose.Words for C++ and Aspose.Cells for C++ Security Updates appeared first on File Format APIs Blog –

Posted in Conholdate.Total Product Family, Aspose.Cells for C++, Aspose.Total Product Family, Aspose.Words for C++ | Tagged , , | Leave a comment