openPR Logo
Press release

Group Pivot Fields in Pivot Table, Access & Modify Display Label of Linked OLE Object using Java

04-03-2018 10:38 AM CET | IT, New Media & Software

Press release from: Aspose

What’s new in this release?

Aspose team is pleased to announce the new release of Aspose.Cells for Java 18.3.0. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the APIs. Microsoft Excel allows users to group pivot fields in the Pivot Table. When there is large amount of data related to a pivot field, it is better to group them into sections. Aspose.Cells provides this feature via the PivotTable.setManualGroupField() method. This was a long-awaited feature requested by many users. The following sample code loads the template Excel file and performs grouping operation on the first pivot field in the Pivot Table using the PivotTable.setManualGroupField() method. Aspose.Cells provides an abstract class DrawObjectEventHandler which has a draw() method. User can implement and utilize the draw() method to get the DrawObject and Bound while rendering Excel to Pdf or Image. If users are rendering Excel file to Pdf, then can utilize DrawObjectEventHandler class with PdfSaveOptions.DrawObjectEventHandler. Similarly, if users are rendering Excel file to Image, users can utilize DrawObjectEventHandler class with ImageOrPrintOptions.DrawObjectEventHandler. Microsoft Excel also supports dashed border types which are not supported by most web browsers. When user convert such an Excel file into HTML using Aspose.Cells, the borders are removed. However, it allows to accomplish the task and supports to display such borders with HtmlSaveOptions.ExportSimilarBorderStyle property. Dialog sheet is an older format that contains a dialog box. Users can find if a sheet is dialog or some other type with Worksheet.Type property. If it returns enumeration value SheetType.DIALOG, then it means, users are dealing with Dialog sheet. Microsoft Excel allows to change the display label of the Ole Object. Developers can also access or modify the display label of the Ole object via Aspose.Cells APIs using the OleObject.Label property. When users put some value inside a cell that has leading apostrophe or single quote mark, then Microsoft Excel hides it, but when users select the cell, it displays the leading apostrophe or single quote in a formula bar. Aspose.Cells provides StyleFlag.QuotePrefix property that will handle either preserving the quote or not preserving the quote for users needs. Developers can read axis labels of chart after calculating its values using the Chart.calculate() method. Please use the Axis.AxisLabels property for this purpose that will return the list of axis labels. Users can change the Version number of Excel file by right clicking the file and then selecting Properties > Details and then editing the Version number field. Please use BuiltInDocumentPropertyCollection.DocumentVersion property to change it programmatically using Aspose.Cells APIs. Below are some important new features, enhancement and bug fixes part of this release.

• Add PdfSaveOptions.DrawObjectEventHandler similar to ImageOrPrintOptions.DrawObjectEventHandler
• Extract label name that can be set for Package objects embedded in MS Excel file
• Using stream to import Excel file via GridWebBean.importExcelFile() is invalid or non-existing
• How to identify worksheet shapes via DrawObjectEventHandler
• Unable to access horizontal category axis label items
• Output HTML does not match with MS Excel
• Excel files corrupted after open/save by Aspose.Cells APIs
• Extra columns are coming at the end of each row in the output HTML for a range
• Excel file is corrupted and have some cells changed after saving
• Calculation errors are present in the hidden sheet namely "KD020"
• ImportTableOptions.setInsertRows() is not working while importing the ResultSet to worksheet
• Comments attached to the cells (in the template file) are not shown when imported the Excel file into GridWeb
• Inconsistent cell coordinates reported by ImageOrPrintOptions.DrawObjectEventHandler
• Borders of rows are misaligned in the output PDF
• X-axis scale is incorrect in PNG output of Excel Chart
• Rendering of the chart is not correct in the output PDF
• Chart is replaced with red X when converting XLSX to ODS
• Images lost when converting ODS to XLSX
• Properties are not extracted from XLS and XLSX files
• Saving XLS to XLSB removes allowEditRanges
• Control external resources using WorkbookSetting.StreamProvider - it works for .NET but does not work for Java
• Specify formula fields while importing data to worksheet - it works for .NET but does not work for Java
• Chinese characters in embedded file name (title) is not well-displayed in notepad

Other most recent bug fixes are also included in this release

Overview: Aspose.Cells for Java

Aspose.Cells is a Java component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted excel files, macros, VBA, unicode, formula settings, pivot tables, importing data from JDBC ResultSet and support of CSV, SpreadsheetML, PDF, ODS and all file formats from Excel 97 to Excel 2007. It is compatible with Windows, Linux & Unix and supports all advanced features of data management, formatting, worksheet, charting and graphics.

More about Aspose.Cells for Java

- Homepage of Aspose.Cells for Java:

- Download Aspose.Cells for Java:

- Online documentation of Aspose.Cells for Java:

Aspose Pty Ltd was founded in March 2002 in Sydney, Australia. The corporate portal was firstly launched in October 2002. Aspose strives to provide the richest component choices for global .NET programmers. Thousands of organizations from tens of countries have acquired Aspose products, including Microsoft, IBM, PricewaterhouseCoopers, Ernst & Young, DuPont, Hilton Hotels, Reader's Digest, Bank of America, Boeing, Siemens, etc.

Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Phone: 888.277.6734
Fax: 866.810.9465

This release was published on openPR.

Permanent link to this press release:

Please set a link in the press area of your homepage to this press release on openPR. openPR disclaims liability for any content contained in this release.

You can edit or delete your press release Group Pivot Fields in Pivot Table, Access & Modify Display Label of Linked OLE Object using Java here

News-ID: 999783 • Views: 152

More Releases from Aspose

Read/Write Projects Created using MS Office 365 Project Online Service using .NE …
What's New in this Release? Aspose team is pleased to announce the new release of Aspose.Tasks for .NET 19.2. This release includes support for Microsoft Project Online, MPP files saved with Microsoft Office 365 cloud are supported now. Also fixes few issues reported with the API that further enhance the stability of the API. Aspose.Tasks for .NET API now supports Microsoft Office 365 Project Online Services. Now the users shall Newsletter February 2019: Work with Cloud File Format REST APIs & S …
Aspose.Cloud Newsletter for February 2019 has now been published that highlights all the newly supported features offered in the recent releases. It also includes information about Cloud REST API and SDKs for working with Microsoft Visio Diagrams, Reordering multiple PowerPoint slides in one Cloud REST API call, Convert HTML to Markdown and MHTML formats in cloud applications and much more. Cloud REST API and SDKs for working with Microsoft Visio Diagrams Manipulate
Aspose.Newsletter February 2019: Enhance Productivity using JDK 11 Compatible PD …
Aspose Newsletter for February 2019 has now been published that highlights all the newly supported features offered in the recent releases. It includes information about Enhancing productivity & performance using JDK 11 compatible PDF API, Loading Excel workbook efficiently without loading VBA project, Use latest version of Aspose.PDF for C++ with new codebase changes, Create PST folder hierarchy with string notation, Detect archive-based file format and work with AMF files
Load any HTML with Self-Closing Tags & Convert It to Excel File inside Android A …
What’s new in this release? Aspose development team is pleased to announce the new release of Aspose.Cells for Android via Java 18.12. Depiction of data through HTML page is very common, however this page can be opened in variety of devices including mobiles, tabs and other hand held devices which contain small screens. The size of the columns is defined in “pt” which works in many cases. However there can be

All 5 Releases

More Releases for Excel

Top Profits of knowledge Advanced Excel Database
specialists. It is the basic piece of activities. It is normally utilized in every one of the parts like medical clinics, institutes, air crafts, telecom, car, land and so forth. A considerable lot of us think about the essential working of MS excel however not many are capable ahead of time excel programs. It is the need of an hour to gain proficiency with all the essential elements of this
ExcelRT 1.1 Creates App from Excel Workbook
Excel Software is shipping ExcelRT 1.1 with enhancements for creating standalone desktop and mobile apps from an Excel workbook. With ExcelRT, a Microsoft Excel user without programming experience can become an app developer for Mac, Windows, Linux and iOS for iPhone or iPad. ExcelRT 1.1 adds a platform specific default sheet that allows the same file to adjust to its screen size and platform. Workbook properties like column and
DataNumen Excel Repair Software Recovers Damaged Spreadsheets
DataNumen has released DataNumen Excel Repair version 2.1, a Windows utility that repairs corrupted or damaged Excel files. Using advanced proprietary technologies to scan the damaged spreadsheets, workbooks, formulas, and associated files, DataNumen Excel Repair recovers as many files as possible, and minimizes data loss. New features in version 2.1 include support for .xlsx files, support to recover number format of the cells, the ability to recover shared formulas and
The New Excel Training Magic
Creative Mentor Training gives imparts Microsoft Excel Training Sydney for the people of different levels of skill. We impart Microsoft Excel courses in a perfect method to gain the skill required to create and edit spreadsheets with an ease. Our Excel training courses include both practical as well as hands on. We get you to work using the skill you learn during the entire period of the course. We also
OfficeProtect Secures Excel, Word and PowerPoint
Excel Software announced OfficeProtect 1.0 to protect Microsoft Office documents with a secure software license. Authors that sell Excel spreadsheets, Macros or Add-Ins for Excel, Word or PowerPoint can ensure that only licensed users can activate and use the protected documents. OfficeProtect includes ready-to-paste Visual Basic code and step-by-step instructions to bind a document to a license configured with the QuickLicense protection and licensing system. OfficeProtect supports
Unable to Access your Excel File, Use Excel Recovery Tool
Being one of the most commonly and widely used spreadsheet application of Microsoft for preparing various financial or annual reports, you just cannot take any chance of MS Excel file corruption. Usually, the file you create in MS Excel is primarily saved in .xls or .xlsx format depending on the MS Excel version you are using for the creation of file. Any minor corruption could result in the result in