Render Office Add-Ins While Converting Excel to Pdf & Implement Formula Similar to Excel VBA

2024-10-31 11:30:44 Computer

812

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

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for Java documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Render Office Add-Ins while converting Excel to Pdf: https://docs.aspose.com/display/cellsjava/Render+Office+Add-Ins+while+converting+Excel+to+Pdf

- Set the Shape Type of Data Labels of Chart: https://docs.aspose.com/display/cellsjava/Set+the+Shape+Type+of+Data+Labels+of+Chart

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

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
http://www.aspose.com/
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465