• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Add Signature Line, Custom Decimal & Group Separators in a Spreadsheet Using Java

 
Ranch Hand
Posts: 714
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is new in this release?

The long awaited version of Aspose.Cells for Java 8.3.2 has been released. Most worth mentioning feature is the support for Signature Line. Microsoft Excel provides the feature to add Signature Line in Excel spreadsheets by clicking the Insert tab and then selecting the Signature Line from the Text group. This feature allows adding the information about the person whose signatures are required on the document while supplying some key information such as name, designation, email address and so on. Aspose.Cells also provides this feature and has exposed the Picture.setSignatureLine field and SignatureLine class for this purpose. Another worth mentioning feature is the support for Absolute Positioning of the PivotItem. Aspose.Cells for Java 8.3.2 has provided this support by exposing a series of new fields that can be used to specify the position of a PivotItem within a parent node and also in the complete collection. While using Microsoft Excel application, the user can specify the custom Decimal and Thousands separators instead of using the system’s predefined separators for a particular spreadsheet. Same can be achieved using the Aspose.Cells for Java API by using the newly exposed fields. Aspose.Cells for Java 8.3.2 has exposed two new overloads for the SheetRender.toPrinter & same for the WorkbookRender.toPrinter. One of the new an overload accept two integer parameters along with a string parameter for the printer name and prints a range of Worksheet & Workbook pages to the printer. Other overload accepts a string parameter to specify the printing job name along with the printer name. Some Unicode characters cannot be displayed using any specified font but they can be displayed with another font family. One of such Unicode character is the Non-breaking Hyphen (U+2011) and its Unicode number is 8209. This character cannot be displayed with Times New Roman but it can be displayed with other fonts like Arial Unicode MS. When a spreadsheet containing such characters is to rendered on PDF canvas while using a not supporting font family like Times New Roman, the Aspose.Cells API used to change the font of entire word or sentence to another font which could display this character. However, this could be an undesirable behavior for some users and they want only that specific character’s font to be changed instead of changing the font of entire word or sentence. In order to deal with this scenario, the Aspose.Cells for Java 8.3.2 API has exposed the setFontSubstitutionCharGranularity field for the PdfSaveOptions class which should be set to true so that only the font of specific character to be changed to another displayable font whereas the rest of the word or sentence should remain in original font. Charts can be of any type, where a few chart types such as all the variations of the Pie and Doughnut does not have any axis. Previously, it was not possible to retrieve the information about the particular axis of a given chart but with the release of Aspose.Cells for Java 8.3.2, the API has exposed the Chart.hasAxis method to determine if the chart has a particular axis or not. This release includes plenty of improved features and bug fixes as listed below

- Ability to delete Style from the StyleCollection when saving HTML
- Specify Custom Separators for complete Workbook
- Specify job/document name when printing with Aspose.Cells
- Smart Generation of CSS while exporting Spreadsheets to HTML
- Cell.setHtmlString does not work when using "<s><span style="color:#ff00ff;">S2</span></s>"
- Add default font directories for Mac and Linux in the fonts search list
- Chart.toImage hangs for indefinite time
- PivotChart does not refresh after updating the source data and rendering the spreadsheet to PDF
- Chart.refreshPivotData causes the dates in chart axis convert to numbers while converting spreadsheet to PDF
- Extra row appears in HTML output while pasting the range with PasteType.ALL
- Strange behavior regarding formatting in the output PivotTable report when using and without using the line of code that corresponds to retrieving Row range
- FormatCondition not supported regarding Numbers format when rendering to HTML file format
- Incorrect rendering of the border while converting spreadsheet to HTML
- XLSB2007TestNewS.xlsb does not load and keeps increasing memory consumption
- Extra lines are shown when output HTML is displayed in Chrome
- Opening and saving Financial_Statement_Input_Report_Withdata.xlsb makes it corrupt
- Refresh Pivot table removes the Pivot Table's formatting when converting to PDF
- MemorySetting.MEMORY_PREFERENCE causes the XLS being corrupted
- Incorrect rendering of Time when spreadsheet is converted to PDF
- Excel found unreadable content... error on opening and saving the workbook
- Cell does not get set with ListObject.putCellValue() method
- Extending Table does not copy formula to new rows
- XPS Viewer cannot open Aspose.Cells generated XPS
- SVG export creates invalid file
- Shape.toImage stores the image in BMP format rather than SVG for shapes other than Chart
- Issue with setting datalabels' cell range values
- Charts are not rendered fine when re-saving the XLSX file
- Chart image has a noise with when converted with lesser resolution
- Chinese Text in Chart Category Titles is not rendering correctly
- Issue with formatting data in PivotTable report
- Issue with calculating Pivot table data
- Trendline series are not shown in the legend

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.

- Specifying the absolute position of the Pivot Item
- Create Signature Line in an Excel Workbook using Aspose.Cells

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
- Demos of Aspose.Cells for Java

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Aspose - The .NET and Java component publisher
[email]sales@aspose.com[/email]
Phone: 888.277.6734
Fax: 866.810.9465
 
reply
    Bookmark Topic Watch Topic
  • New Topic