Render your desired range only to HTML and filter VBA Projects in the workbook using Aspose.Cells for .NET 18.12

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

Aspose.Cells for .NET logoWe are pleased to announce the release of Aspose.Cells for .NET v18.12, the MS Excel file formats API that provides the ability to create, manipulate, convert or render MS Excel spreadsheets, and more importantly – is fully documented. Please check the document on how to install Aspose for .NET APIs directly from NuGet repository. We have added a few important features and other enhancements while keeping the product more stable and feature rich API. We also included important bug fixes as a part of this release. We are moving ahead to achieve our goals in the industry by providing state of the art products by addressing each and every concern of our customers. This is all possible due to continuous support and feedback by the developers community. Moreover, fixing bugs and issues leads us to new enhancements and features which increases our customer base.

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

 

Export single sheet workbook to HTML

Workbook can have multiple sheets which are rendered as multiple tab pages when converted to HTML using MS Excel. Similarly if a workbook contains single sheet, it shows one tab page when converted to HTML using Excel. This conversion was working fine for multiple sheets while using Aspose.Cells. However for single sheet workbook, there was no tab page and only HTML file was created without creating the separate folder containing CSS. Now Aspose.Cells has enhanced its library to create similar output for single sheet workbooks as compared to output created by Excel.

For a working example refer to the following article:

Load workbook efficiently without loading VBA project

In complex Excel files (XLSM/XSLB) there can be large amount of macros which can be very long. Many times there is a need to load the workbooks without loading these VBA projects like just extracting the sheet names from loaded workbook. In this case we need a filter which can load/skip VBA projects. This time Aspose.Cells has introduced a filter option LoadDataFilterOptions.VBA which can be used for this purpose.

For a working example refer to the following article:

Replacing tags in Textbox within a worksheet

Textbox is a common control which can be used in a worksheet. This is not necessary that text in the textbox is fixed. It may have tags which can be replaced with some text at runtime. It helps users to configure the controls as per the data on the sheet or from some other source. Worksheet.replace can be used for this purpose and textbox can be set with the desired text.

For a working example refer to the following article:

Export print area range to HTML

We can convert worksheet to HTML but rendering entire sheet at once may not be required always. You may require just a selected area of the sheet to be rendered to HTML. Worksheets contain page setup where print area can be set. There was a need that only  this print area shall be rendered to HTML if required. HtmlSaveOptions is extended by adding a new enumerator ExportPrintAreaOnly which enables users to render only print area in the HTML.

For a working example refer to the following article:

Identification of validation as dropdown

A worksheet can have different types of validations including dropdown. Users might want to detect the type of validation and take some decisions  based on this information. Validation object can be obtained from a cell and a new function is defined for this validation which returns if validation is a dropdown or not. Use the function Validation.getInCellDropDown() which returns a Boolean value i.e. true or false.

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:

  • Creating and customizing charts
  • Tracked Changes lost during conversion from XLSB to XLSM and XLS to XLSM
  • Text moved a little bit after ungrouping the shape when saving an XLS to XLSX
  • Optimization for memory performance: release original stream after loading Workbook
  • Handled exception “NullReferenceException” when loading an XLSB file format
  • Handled ArgumentException on loading a workbook

In Aspose.Cells 18.12, we fixed several important bugs and other issues. For example, issues around reading/writing MS Excel file formats, reading/writing HTML files, protecting ODS files, setting data validations, manipulating rows and columns, manipulating smart art shapes, refreshing and calculating pivot tables, rendering and manipulating charts and shapes, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved in the release. 

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 HtmlSaveOptions.ExportSingleTab property, indicates whether exporting the single tab when the file only has one worksheet in it. The default value is false.
  • Adds HtmlSaveOptions.ExportPrintAreaOnly property, indicates if only exporting the print area to html file. The default value is false.

  • Deletes obsoleted Workbook.Initialize() method, use Workbook constructor instead.

  • Deletes obsoleted Workbook.Styles property, use Workbook.CreateStyle() to create and manipulate style for workbook instead of StyleCollection.Add(); Use Workbook.GetNamedStyle(string) to get named style instead of StyleCollection.

  • Deletes obsoleted Workbook.CheckWriteProtectedPassword() method, use WorkbookSettings.WriteProtection.ValidatePassword method instead.

  • Deletes obsoleted Workbook.CheckWriteProtectedPassword() method, use WorkbookSettings.WriteProtection.ValidatePassword method instead.

  • Adds LoadDataFilterOptions.VBA enum, the option used to ignore VBA projects while loading template file.

  • Adds Style.InvariantCustom property, gets the culture-independent pattern string for number format (including the pattern string for built-in number).

  • Adds FindOptions.ValueTypeSensitive property, indicates whether searched cell value type should be same with the searched key.

  • Obsoletes FindOptions.SearchNext property, use FindOptions.SearchBackward property instead, true value for this new property corresponds to false of SearchNext.

  • Deletes obsoleted Cells.ImportGridView(System.Web.UI.WebControls.GridView,int ,int , bool ,bool ,bool ) method, use Cells.ImportGridView (System.Web.UI.WebControls.GridView gridView,int firstRow,int firstColumn,ImportTableOptions options) method. instead.

  • Deletes obsoleted Cells.Start property, use Cells.FirstCell property instead.

  • Deletes obsoleted Cells.End property, use Cells.LastCell property instead.

  • Deletes Cells[int] property, use Cells.GetEnumerator() method to iterate all cells in this worksheet instead.

  • Deletes obsoleted Cells.ImportDataColumn() methods, use Cells.ImportData (DataTable,int,int,ImportTableOptions) method instead.

  • Deletes obsoleted Cells.ImportDataReader() methods, use Cells.ImportData (IDataReader, int, int,ImportTableOptions) method instead.

  • Deletes obsoleted Shape.Rotation property, use Shape.RotationAngle property instead.

  • Deletes obsoleted Validation.AreaList property, use Validation.Areas property instead.

  • Deletes obsoleted Style constructor, use CellsFactory.CreateStyle() or Workbook.CreateStyle() method instead.

  • Deletes obsoleted Shape.IsPrinted property, use Shape.IsPrintable property instead.

  • Deletes obsoleted PivotItem.Move(int) method, using PivotItem.Move(int , bool ) method instead.

  • Deletes obsoleted  Cells.ExportDataTable(int, int, int, int,bool, bool),Cells.ExportDataTable(int, int, int, int,object[]), Cells.ExportDataTable(int, int, int, int,bool), 
    Cells.ExportDataTable(DataTable, int, int[],int, bool) and Cells.ExportDataTable(DataTable,int, int, int, bool, bool) methods, 
    use ExportDataTable(firstRow,firstColumn, totalRows, totalColumns,ExportTableOptions) method instead.

Aspose.Cells for .NET Resources

The resources, you may need to accomplish your tasks:

Posted in Aspose.Cells Product Family | Leave a comment

Apply Formatting to Time Field and Control Threshold to Determine TIFF Binarization Error

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

Aspose.Words for .NET logoWe are pleased to announce our next version Aspose.Words for .NET 19.1. This month’s release contains over 48 useful new features, enhancements and bug fixes. Please check the release notes to get an idea about all new features, enhancements and fixes made in this release. If you are planning to upgrade from older version of Aspose.Words to the current version, we would strongly suggest you to check the Public API and Backward Incompatible Changes section to know what APIs are changed so far.

 

Added Feature to Apply Custom Formatting for Time Field

For Time field,  there is a difference between MS Word formatting and .NET/Windows formatting and also between different .NET Framework versions. So, we have added new feature in this version of Aspose.Words 19.1 to apply custom formatting to Time field. Now, user can format the Time field according to his requirement. For more detail, please read the following article

How to Apply Custom Formatting to Time Field

Expose The Threshold Control for TIFF Binarization

We have added new property ThresholdForFloydSteinbergDithering in ImageSaveOptions class to control threshold for TIFF binarization. Please read the following article for more detail.

Control Threshold For TIFF Binarizations

Here is a look at just a few of the biggest features and API changes in this month’s release.

  • Implemented the directed line caps rendering for Bezier curves in metafiles.
  • Implemented processing of the stroke properties while rendering custom line caps in metafiles.
  • Implemented support of Unicode font names while rendering to PDF.
  • Implemented Tiff binarization threshold control via ImageSaveOptions.ThresholdForFloydSteinbergDithering property.
  • Fixed a bug that prevents rendering of horizontal lines with gradient fill in DrawingML.
  • Fixed a bug when gradient fill is not rotated with DrawingML shapes by default.
  • Fixed a bug that caused an incorrect rendering of DrawingML shapes inside groups when 3D rotation was applied.
  • Fixed a bug with the calculation of the point coordinates if the date axis is replaced by the string axis.
  • Fixed a bug with vertical alignment of Ruby objects while rendering.
  • Fixed a bug that caused the creation of extra link tags in output PDF when rendering documents with footnotes.
  • Supported dynamic table cell merging for LINQ Reporting Engine.
  • Supported textual comments within LINQ Reporting Engine template syntax tags.
  • Improved computation of wrap bounds of floating objects which affects position of text nearby.
  • Improved positioning of line when it cannot fit next to floating object and has to be pushed below.
  • Implemented navigation from footnote reference to footnote for PDF output.
  • Fixed exception which may happen when spans are merged in paragraphs with different directionality.
  • Fixed exception which may happen when span has null shading inside text box.

Aspose.Words for .NET Resources

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

    • Home page of .NET API.
    • Install using NuGet Package
    • Documentation – up-to-date documentation containing Programmer’s Guide, Knowledge Base and much more.
    • API Reference Guide – detailing the publicly exposed classes, methods, properties, constants & interfaces.
    • Aspose.Words Product Family Forum – post your technical questions and queries, or any other problem you are facing while working with Aspose.Words APIs.
    • Enable Blog Subscription – do not limit yourself, you can keep yourself updated with the latest news on Aspose.Words APIs, new features, fixes and other API related topics by subscribing to Aspose.Words blog.
    • Examples – we have published our code examples on the social coding website GitHub.com. Anyone could explore the code examples for learning purposes.
Posted in Aspose.Words Product Family | Leave a comment

Aspose Holiday Offer – 25% Off Aspose.Total or Free Pirathon Wine

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn
LinkedIn YouTube Twitter Facebook
Share this issue:

Monthly Newsletter

January 2019

25% off Aspose.Total OR 24 bottles of Award-Winning Pirathon Total Shiraz Wine
 
25% off Aspose.Total OR 24 bottles of Award-Winning Pirathon Total Shiraz
 

Aspose.Total brings together all Aspose APIs in one product suite and is great value for money. This holiday season Aspose is making it even better value by giving you 25% off Aspose.Total..
Quote HOLOFF2018 or HOLOFF2018 when placing your order.

24 Bottles of Award-Winning Pirathon Total Wine (worth over $1500). Comprising of the 2016 vintages of Bluemark, Pirathon Silver, Pirathon Black and Pirathon Gold, Pirathon Total is the ultimate holiday gift.

Enter the coupon code PIRATH2018 to take advantage of this offer.

 
Buy Now
This offer is only available on new Aspose.Total purchases and cannot be used in conjunction with other offers, renewals or upgrades. Only available directly from Aspose.com, not through third parties or resellers. Ts & Cs Apply, offer subject to change with no notice.
Product News
Product News
Product News
 
From the Library
From the Library
From the Library
 
Feedback
Feedback
Feedback
 
Aspose for .NETAspose for .NETAspose for JavaAspose for Cloud APIsAspose for Android
Product Releases and Updates
Posted in Customer Reviews, Newsletter | Leave a comment

Detect Archive Based File Format and Work with AMF files using Aspose.3D

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

Aspose.3D for .NET logo

We are pleased to announce December release of Aspose.3D API. It includes long awaited support for standard 3d printing format i.e. AMF. Additive manufacturing file format has been added to Aspose.ThreeD.FileFormat class. Moreover, Archive-based file format can also be detected with latest version of Aspose.3D API. Issue with AssetDirectory for relative path, and some other internal fixes have also been incorporated in this release. You can use following links to download Aspose.3D for .NET and Java APIs.

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

Aspose.3D for .NET and Java Resources

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

Read dotted BarCodes from TIFF images with Aspose.BarCode for JasperReports 18.12

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

Aspose.BarCode for JasperReports We are pleased to announce the release of Aspose.BarCode for JasperReports 18.12. This release gives you the ability to read dotted barcodes from Tiff images. To view a complete list of fixes, please visit Aspose.Barcode for JasperReport 18.12 release notes page.

Read dotted BarCodes from TIFF Ima

The new release of Aspose.BarCode adds the ability to read dotted barcodes from Tiff images. You may read such barcodes as shown below.

String fileName = "Test.tiff";
BarCodeReader reader = new BarCodeReader(fileName,
new MultyDecodeType(DecodeType.ALL_SUPPORTED_TYPES));
while (reader.read())
System.out.println(reader.getCodeText());

Other Enhancements made to the API

Other than the ability to read dotted barcodes from Tiff images, XML serialization was enhanced and made compatible between .NET and Java.

You can download the latest release of Aspose.BarCode for JasperReports from the following link: Download Aspose.BarCode for JasperReports 18.12.

Aspose.BarCode for JasperReports Resources

The following API resources can be of help to you in getting started:

Posted in Aspose.BarCode Product Family | Leave a comment

Read dotted BarCodes from TIFF images with Aspose.BarCode for Java 18.12

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

We are pleased to announce the release of Aspose.BarCode for Java 18.12. This release gives you the ability to read dotted barcodes from Tiff images. For a detailed note on what is new and fixed, please visit the release notes page of API documentation.

Read dotted BarCodes from TIFF Images

The new release of Aspose.BarCode adds the ability to read dotted barcodes from Tiff images. You may read such barcodes as shown below.

String fileName = "Test.tiff";
BarCodeReader reader = new BarCodeReader(fileName,
new MultyDecodeType(DecodeType.ALL_SUPPORTED_TYPES));
while (reader.read())
System.out.println(reader.getCodeText());

Other Enhancements made to the API

Other than the ability to read dotted barcodes from Tiff images, XML serialization was enhanced and made compatible between .NET and Java.

Aspose.BarCode for Java Resources

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

Posted in Aspose.BarCode Product Family | Leave a comment

Support for EMF/WMF processing in Aspose.Slides for C++

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

aspose-slides-for-cpp We are pleased to announce the release of Aspose.Slides for C++ 18.12. This is one of maintenance release whereby we have resolved certain issues incurring in API.

Enhancements and Features

Following issues have been fixed in this release.

Please refer to the release notes of Aspose.Slides for C++ 18.12 for a full view of improvements along with sample code snippets for newly added features. If you are planning to upgrade the API to the latest revision, we strongly suggest you to check the Public API Changes section to know what has been changed in the public API since your current version.

Aspose.Slides for C++ Resources

The resources, you may need to accomplish your tasks:

As always, we appreciate your feedback so if you ever have anything to share with us about this release or anything else, please feel free to contact us in Aspose.Slides forum.

Posted in Aspose.Slides Product Family | Leave a comment

Support for adding GIF available in Aspose.Slides for Android via Java

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

Aspose.Slides for Android logo We are proud to share the release announcement of Aspose.Slides for Android via Java 18.12. This is one of maintenance releases whereby we have resolved issues incurring in API.

Features

Following features have been added in this release.

    Issues Resolved

    Following enhancements and issues have been fixed in this release.

    • Text is not exported to PDF.

    • Exception on loading presentation.

    • Exception on loading presentation.

    • Exception on loading presentation.

    • Date Changed after saving PPT to PPTX.

    • Wrong outline gradient direction.

    • Font changed after converting PPTX to PDF.

    • Spaces lost in generated Thumbnail.

    • Font substitution not rendering non-latin character-based languages correctly.

    • PPTX not properly converted to PDF.

    • PPTX not properly converted to PDF.

    Please refer to the release notes of Aspose.Slides for Android via Java 18.12 for a full view of improvements along with sample code snippets for newly added features. If you are planning to upgrade the API to the latest revision, we strongly suggest you to check the Public API Changes section to know what has been changed in the public API since your current version.

    Aspose.Slides for Java Resources

    The resources, you may need to accomplish your tasks:

    As always we appreciate your feedback so if you ever have anything to tell us about this release or anything else, please head to the Aspose.Slides forum for a chat.

    In order to download Aspose.Slides for Android via Java 18.12, please visit the download page.

Posted in Aspose.Slides Product Family | Leave a comment

Improved rendering performance for Aspose.Slides for Java

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

We like to share the release announcement for Aspose.Slides for Java 18.12. We have included support for some new features along with resolution of outstanding issues incurring in API.

Features

Following features have been added in this release.

Issues Resolved

Following enhancements and issues have been fixed in this release.

  • Text is not exported to PDF.

  • Exception on loading presentation.

  • Exception on loading presentation.

  • Exception on loading presentation.

  • Date Changed after saving PPT to PPTX.

  • Wrong outline gradient direction.

  • Font changed after converting PPTX to PDF.

  • Spaces lost in generated Thumbnail.

  • Font substitution not rendering non-latin character-based languages correctly.

  • PPTX not properly converted to PDF.

  • PPTX not properly converted to PDF.

Please refer to the release notes of Aspose.Slides for Java 18.12 for a full view of improvements along with sample code snippets for newly added features. If you are planning to upgrade the API to the latest revision, we strongly suggest you to check the Public API Changes section to know what has been changed in the public API since your current version.

Aspose.Slides for Java Resources

The resources, you may need to accomplish your tasks:

As always we appreciate your feedback so if you ever have anything to tell us about this release or anything else, please head to the Aspose.Slides forum for a chat.

Posted in Aspose.Slides Product Family | Leave a comment

Improved fonts and EMF rendering support in Aspose.Slides for .NET

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

We like to share the release announcement for Aspose.Slides for .NET 18.12. This is primarily a maintenance release whereby we have resolved certain issues incurring in API.

Issues Resolved

Following enhancements and issues have been fixed in this release.

  • Font rendered by version 17.10 is no longer found by 18.7.

  • OutOfMemoryException on generating thumbnail (metafile rendering).

  • EMF images are rendered wrong.

  • Wrong font substitution.

  • Cell borders are missing on thumbnail when it is generated in original size.

  • PPTX not converted properly to PDF.

  • Table disappears while converting PPT to PDF.

  • Exception on saving PPTX.

  • Wrong values returned by IPortion GetCoordinates().

  • Corrupt Embedded excel file in PPTX.

  • Chart is improperly rendered in generated PDF.

  • Presentation repair message on loading Aspose generated presentation.

  • PPTX not properly converted to PDF.

  • Chart is improperly rendered in generated PDF.

  • Heading with URL removed in saved presentation.

  • PPT text box changed from one line to two lines.

Please refer to the release notes Aspose.Slides for .NET 18.12 for a full view of improvements along with sample code snippets for newly added features. If you are planning to upgrade the API to the latest revision, we strongly suggest you to check the Release Notes section to know what has been changed in the public API since your current version.

Aspose.Slides for .Net Resources

The resources, you may need to accomplish your tasks:

As always, we appreciate your feedback so if you ever have anything to share with us about this release or anything else, please feel free to contact us in Aspose.Slides forum.

Posted in Aspose.Slides Product Family | Leave a comment