Get Paper Size of Excel Worksheet & Improved Custom Load Filtering Mechanism using .NET

We are pleased to announce the new release of Aspose.Cells for .NET 17.1.0. The new release includes some valuable features and other enhancements with critical bug fixes. The LoadFilter class allows customizing the loading process as per the properties of the Worksheet. In order to customize the loading process, one has to override the LoadFilter.StartSheet method. Please note, there are just a few properties that can be used for a given worksheet object in this scenario because most of the data and properties have not been loaded yet. The available Worksheet properties are: Name, Index & VisibilityType. Users may change the LoadDataFilterOptions property in their own implementation of LoadFilter class to control the behavior of loading template files. Sometimes, application requirement could be to retrieve the worksheet’s paper size in the unit of Inches, which can now be achieved using the PageSetup.PaperWidth and PageSetup.PaperHeight properties. The PageSetup.PaperWidth and PageSetup.PaperHeight properties are of type double representing the paper width & height in the unit of inches while considering the page orientation. Aspose.Cells APIs store 17 significant digits of double values unlike Excel application which stores only 15 significant digits. Users can override this default behavior of Aspose.Cells APIs while using the newly exposed CellsHelper.SignificantDigits property. The code snippet enforces the Aspose.Cells APIs to use 15 significant digits while storing double values to the spreadsheet files of type XLSX. It has added the CheckCustomNumberFormat property to the WorkbookSettings class. The CheckCustomNumberFormat is useful in checking if the Style.Custom property has been set properly or not. In case the Style.Custom property has been set improperly, that is; the value does not correspond to valid pattern then the Aspose.Cells for .NET APIs will throw CellsException with appropriate message. It has enhanced its core for more stability as well as fixed a few critical bugs. Moreover, there are numerous minor enhancements in order to improve the overall usage of the API. Furthermore, this release has fixed several other issues. For example, issues around reading/writing MS Excel Excel file formats, rendering wordart and smartart shapes, rendering charts and other shapes, manipulating ListObject/Table, formatting and manipulating Pivot Tables, conditional formatting, rendering to HTML file format, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. The formula calculation engine is improved too in the new release. This release includes several enhanced features and bug fixes as listed below

• MS Excel 2016 XLSX file containing Waterfall chart cannot be opened via Aspose.Cells APIs
• Bind Worksheet to a Customized Collection object (Aspose.Cells.GridWeb)
• Bind Worksheet to a DataSet object at Run Time (Aspose.Cells.GridWeb)
• Output Excel file is not good when converting an HTML file to Excel file format
• Issue with Date format in German locale when rendering an Excel file to PDF
• Representation of double numbers in Aspose.Cells
• PivotTable.RefreshData takes a lot of time
• Performance of GETPIVOTDATA
• Formulas with GETPIVOTDATA are not being recalculated in the output file
• Some CSS rules ignored when importing HTML
• Images in table has incorrect position
• Content color has been changed
• Content style has been changed
• Contents have been displaced
• Issue with overriding default styling of TH elements
• Column position has been changed while refreshing the Pivot Table
• Merged cells in XLSX are not displayed as merged in HTML
• Horizontal and vertical lines are missing in Pivot Table after converting spreadsheet to PDF
• LoadOptions.LoadFilter is not working expectedly
• YIELD function result inaccurate when CalculateFormula() method is called
• Calculating formula returns different results than MS Excel
• Image rendered incorrectly when a cell has Egyptian pound symbol
• WordArt objects become mere dots in the output PDF
• Area chart is slanted at the end in PDF output unlike MS Excel file
• Unnecessary lines appear in the chart image
• Culture settings are not applying on output chart's image
• Graph is not rendered correctly when spreadsheet is converted to PDF
• Image generated by Aspose.Cells gets distorted when inserted into Docx
• Worksheet contents change after opening and resaving as illustrated in the second screenshot
• Worksheet contents change after opening and resaving as illustrated in the first screenshot
• Dotted cell borders are not retained while converting XLSX to ODS
• Excel files get corrupted after loading and saving via Aspose.Cells APIs

Other most recent bug fixes are also included in this release

Comments

  • Aspose development team is pleased to announce the new release of Aspose.Cells for .NET 18.6. It has supported to add Microsoft Excel Formula Watch Window for the users. Moreover, it has included some important fixes and other enhancements for the users. Slicers are a strong way to filter pivot table data. You can insert slicers into MS Excel to quickly and easily filter pivot tables. Aspose.Cells now supports to create, manipulate and render Slicers in the spreadsheet. Please see the sample code on blog announcement page. It loads the sample Excel file that contains the pivot table. It then creates the slicer based on the first base pivot field. The following sample code loads an Excel file that contains an existing slicer. It un-selects the 2nd and 3rd items of slicer to refresh it. It then applies formatting/style of the slicer and finally describes on how to remove the slicer. spose.Cells also supports rendering of slicer shape. When users convert a worksheet into image or save a workbook to PDF or HTML formats, Users will see, slicers are rendered properly. MS Excel Watch Window is a useful tool to watch the cell values and its formulas conveniently in a window. Users can open the Watch Window using Microsoft Excel by clicking the Formulas > Watch Window. It has Add Watch button that can be used to add the cells for inspection. Similarly, users can use Worksheet.CellWatches.Add() method to add cells into Watch Window using Aspose.Cells API. Custom XML Parts are the XML data that is stored inside the Microsoft Excel documents and are used by the applications that deal with them. There is no direct way of adding them using Microsoft Excel UI at the moment. However, users can add them programmatically. Please use Workbook.CustomXmlParts.Add() method if users want to add Custom XML Part using Aspose.Cells API. Aspose.Cells can extract text from the Gear type Smart Art shape. In order to do so, users should first convert Smart Art shape to group shape. Then users may get the array of all the individual shapes forming the group shape using the GroupShape.GetGroupedShapes() method. Finally, users can iterate all of individual shapes one by one in a loop and extract their text using the Shape.Text property. There are some other enhancements included and a few exceptions handled in the new release for the users, such as improve converting line Callout to image, WorkbookRender.ToImage(pageIndex, fileName/stream) and Bitmap WorkbookRender.ToImage(int pageIndex) methods included, Support DateTimeOffset format when importing custom objects, Handled EndOfStreamException when Aspose.Cells.Dll (latest assembly) is ilmerged, Exception: “File is corrupted” when loading an XLS file and ArgumentOutOfRangeException when Aspose.Cells (latest assembly) is ilmerged. This release includes several enhanced features and bug fixes as listed below

    • Render Slicer shape to image format
    • Update Slicer in XLSB and XLSX file formats
    • Create Slicer in XLSB and XLSX file formats
    • Create or update Slicer in Excel 2013 using Aspose.Cells
    • Add API to get & set CustomXmlPart ID
    • Improve converting line Callout to image
    • WorkbookRender.ToImage(pageIndex, fileName/stream) and Bitmap WorkbookRender.ToImage(int pageIndex) methods included
    • Support DateTimeOffset format when importing custom objects
    • GroupShape definition is misleading
    • Relevant methods in Aspose.Cells API are added for GetRangeAddess(), GetCellCount(), GetEntireAddress() and GetOffset()
    • Convert smart art from XLSX to XLS file format
    • Convert smart art from XLS to XLSX file format
    • Ink tools disappeared when converting to PDF
    • Portions of the picture in the spreadsheet renders in different color while converting worksheet to image
    • Ink Objects does not render while converting spreadsheet to PDF format
    • Some shapes are missing and some are dispersed (dis-positioned) - Excel to HTML conversion
    • When Issue4 callout placement.xlsx converted to PDF, formatting is not good
    • Displaced bigger image on converting an XLSM to PDF
    • Some drawing shapes are displaced or rendered wrongly in Excel to HTML rendering
    • Unable to extract smart art images correctly
    • Shape is displaced to cover data in Excel to HTML rendering
    • All previous columns and rows data stay in the PivotTable after filtering
    • Output HTML is good in Chrome but wrong in IE or Edge
    • Rows imported to single cell when importing HTML file format
    • Cell value truncated when importing HTML
    • Single quotes disappear from the formula when opening the file
    • Formulas (containing linked data source in other workbooks) are not calculated fine
    • Tab bar becomes hidden when user changes tab because Grid height grows up
    • Print from Aspose.Cells differs from Excel
    • PDF output ignores all the page breaks inside an MS Excel file
    • Shape color changes when convert to PDF file format
    • Excel document is slipping while saving as PDF
    • Mixture of page 1 and page 2 in the output PDF
    • Single word is splitted into two lines in Aspose.Cells' rendered output image
    • Unable to load password-protected ODS file
    • Pareto chart does not display in MS Excel file but it renders somewhat fine in PDF
    • The chart horizontal axis label is corrupted
    • Saving XLT file as XLS after clearing chart's data series causes red "Protected View" warning
    • Watermark works fine with the spreadsheets but nothing shows up on charts
    • Y-axis ticks in chart image do not match with MS-Excel
    • CellsException - System.OutOfMemoryException while converting Excel file to PDF
    • Pie chart legend colors change after saving to PDF and do not match up with pie chart slices
    • Saving an XLT/XLTX file as XLS/XLSX causes red "Protected View" warning
    • Hyperlinks are corrupted when referencing to sheet with special characters in its name
    • Standardized way for last three numbers in the signature shape name
    • Resizing headless table corrupts the output MS Excel file
    • Output Excel File is corrupt after creating list object
    • When render an Excel document to PDF, the process never finishes

    Other most recent bug fixes are also included in this release

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion