Render Office Add-Ins While Converting Excel to Pdf & Implement Formula Similar to Excel VBA
What’s new in this release?Aspose team is pleased to announce the new release of Aspose.Cells for Java 17.12.0. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the APIs. It is also recommend to clients to use the powerful Aspose for Java APIs directly in their Maven Projects with simple configurations. Microsoft Excel formulas may have different names in different locales/regions or languages. For example, SUM function is called SUMME in German. Aspose.Cells cannot work with non-English function names. In Microsoft Excel VBA, there is Range.FormulaLocal property that returns the name of the function as per its language or region. Aspose.Cells also provides Cell.FormulaLocal property for this purpose. However, this property will only work when users will implement GlobalizationSettings.getLocalFunctionName(String standardName) method. Aspose.Cells now supports to render MS Office Add-ins (in Excel files) in the output PDF. You do not need to use any special method or property to render Office Add-Ins in the output PDF. Sometime, users want to auto populate smart marker data to other worksheets if it is too large. Suppose, users data source has 1500000 records. These are too many records for a single worksheet, then users can move the rest of the records to next worksheet. Users can change the shape type of data labels of the chart using the DataLabels.ShapeType property. It takes the value of DataLabelShapeType enumeration and changes the shape type of data labels accordingly. Aspose.Cells provides the feature to export worksheet CSS separately when users convert your Excel file to HTML file format. Please use HtmlSaveOptions.ExportWorksheetCSSSeparately property for this purpose and set it to true while saving Excel file to HTML format. Aspose.Cells allows you to prefix table elements styles with HtmlSaveOptions.TableCssId property. Below are some important new features, enhancement and bug fixes part of this release.
• Improved LoadDataFilterOptions enumeration and ambiguity removed
• CSV Format - D2 and D6 are IsString but Aspose.Cells treats them as IsNumeric
• When XLSX is converted to PDF, some lines in charts are different
• Some CSS class declarations are not prefixed in the output HTML
• HTML output inconsistent with source - Excel to HTML conversion
• Importing long value from HSQL DB throws an exception
• Equation is not rendered fine in the output PDF
• Chart is missing in the output PDF
• Datalabels for the chart are missing in the output PDF/image
• Chart image is not alike Microsoft Excel
• Datalabels display wrong in the output HTML file format
• Set combo box name does not work for the source Excel file but if re-saved by Microsoft Excel it works ok
• Microsoft Excel Macro-Enabled Worksheet (.xlsm) gets corrupted after opening and saving via Aspose.Cells APIs
• Setting a Checkbox linked cell causes MS Excel to prompts an error message when opening the output file into it
• Reading the XLSB file throws the NullPointerException
• Exception elements styles with HtmlSaveOptions.TableCssId property.
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: http://www.aspose.com/products/cells/java
- Download Aspose.Cells for Java: http://www.aspose.com/downloads/cells/java
- Online documentation of Aspose.Cells for Java: http://www.aspose.com/docs/display/cellsjava/Home
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
Australia
Phone: 888.277.6734
Fax: 866.810.9465
This release was published on openPR.
Permanent link to this press release:
Copy
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 Render Office Add-Ins While Converting Excel to Pdf & Implement Formula Similar to Excel VBA here
News-ID: 899226 • Views: …
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…
aspose.cloud 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…
More Releases for Cell
Global GMP Cell Banking Market By Type - Mammalian Cell, Microbial Cell, Insect …
Researchmoz added Most up-to-date research on "Global GMP Cell Banking Market By Type - Mammalian Cell, Microbial Cell, Insect Cell and Others" to its huge collection of research reports.
This report researches the worldwide GMP Cell Banking market size (value, capacity, production and consumption) in key regions like North America, Europe, Asia Pacific (China, Japan) and other regions.
This study categorizes the global GMP Cell Banking breakdown data by manufacturers, region, type…
Cell Culture Market Size, Cell Culture Market Share, Cell Culture Market Trends …
According to a new research published by Polaris Market Research the global cell culture market is anticipated to reach more than USD 49 billion by 2026. Cell culture is a rapidly emerging as an implement for analyzing and treating various disease such as Alzheimer’s and cancer.
Request for Sample of This Research Report @ https://bit.ly/2D7pZ5u
Top Key Players: -
Becton,
Dickinson and Company
Biospherix
EMD Millipore
Eppendorf AG
Merck KGaA
Sartorius AG
VWR International
Cell culture is a rapidly emerging…
Cell Banking Outsourcing Market Report 2018: Segmentation by Type of Bank (Maste …
Global Cell Banking Outsourcing market research report provides company profile for Charles River Laboratories, Cryo-Cell International Inc., BioOutsource (Part of Sartorious Stedim Biotech Group)Ltd., BioReliance Corporation, BSL Bioservice Scientific Laboratories Munich GmbH, Cleancells, CordLife Group Ltd and Others.
This market study includes data about consumer perspective, comprehensive analysis, statistics, market share, company performances (Stocks), historical analysis 2012 to 2017, market forecast 2018 to 2025 in terms of volume, revenue, YOY…
Load Cell Market Key Player Analysis By Single Point Load Cell, Compression Load …
The Load Cell Report consists of all the basic information regarding the Load Cell market. The all-inclusive report will aid users to understand the market current trends, industry growth drivers, share, analysis, size, production, forecast trends, supply, sales, demands, and many other aspects. The analysis was accomplished using an objective amalgamation of primary and secondary data including contributions from major participants in the market. The global Load Cell report is…
Global Stem Cell Storage Market By Product Type - Umbilical Cord Blood Stem Cell …
Researchmoz added Most up-to-date research on "Global Stem Cell Storage Market By Product Type - Umbilical Cord Blood Stem Cell, Embryonic Stem Cell & Adult Stem Cell" to its huge collection of research reports.
In this report, the global Stem Cell Storage market is valued at USD XX million in 2016 and is expected to reach USD XX million by the end of 2022, growing at a CAGR of XX% between…
Stem Cell Media Sales In Global Market, 2017: By Product Type - Pluripotent Stem …
Researchmoz added Most up-to-date research on "Stem Cell Media Sales In Global Market, 2017: By Product Type - Pluripotent Stem Cell Culture, Neural Stem Cell Culture & Mesenchymal Stem Cell Culture" to its huge collection of research reports.
In this report, the global Stem Cell Media market is valued at USD XX million in 2016 and is expected to reach USD XX million by the end of 2022, growing at a…