• 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 ...
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Junilu Lacar
  • Liutauras Vilda
  • Paul Clapham
  • Jeanne Boyarsky
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
  • Jesse Duncan
  • Frits Walraven
  • Mikalai Zaikin

Copy Row Heights While Copying Ranges & Calculate Page Setup Scaling Factor 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.5.0 has been released. This release contains many useful features and improvements along with some critical bug fixes. It has exposed the CalculationOptions class. CalculationPrecisionStrategy enumeration and a set of new CalculateFormula methods in order to add more flexibility & extensibility to the formula calculation engine. These new APIs were added to facilitate the user who wish to strategies the calculation precision handling on their own according to the application requirements. Please note, due to the precision issue of IEEE 754 Floating-Point Arithmetic, some seemingly simple formulas may not give expected results therefore the latest API build has exposed the following CalculationPrecisionStrategy fields to get desired results according to the selection. Aspose.Cells APIs have exposed the PasteType.ROW_HEIGHTS enumeration field for the purpose of copying the row heights while copying the ranges. Upon setting the PasteOptions.PasteType property to PasteType.ROW_HEIGHTS the heights of all the rows inside the source range will be copied to the destination range. Microsoft Excel calculates the page setup scaling factor while using the “Fit to n page(s) wide by m tall” option. This release has exposed the SheetRender.PageScale property to mimic the aforesaid feature of Excel application. This property returns a double value which can be converted to percentage for scaling notation. With this revision, the API has exposed the Cell.getStringValue method along with an enumeration CellValueFormatStrategy that can be used to extract the cell value with or without formatting applied. The newly exposed Cell.getStringValue() method can be used to get the string value of the cell with or without any formatting. Suppose, you have a cell with value 0.012345 and you have formatted it to display two decimal places only. It will then display as 0.01 in Excel. You can retrieve string values both as 0.01 and as 0.012345 using the Cell.getStringValue() method. The most notable enhancements in this release includes, improved the HTML rendering and handled a few JavaScript errors, improved the PDF rendering for Hebrew characters, wrapped text, page break handling & Right to Left rendering and Tweaked calculate engine for handling custom functions. This release includes plenty of improved features and bug fixes as listed below

- Enhance the PasteOptions/PasteType mechanism to allow copying of Row heights while copying Ranges
- Recalculating the Page Setup scaling factor
- HYPERLINK formula/function - Allow user to process parameters of hyperlink
- CELLSJAVA-41225 Wrong background color is returned by Aspose.Cells
- Spreadsheet corrupted after opening and saving the template XLSX file
- Conversion to HTML appends # string at the end of values for a column
- Numbers in the Text boxes are not displayed inside
- The smart arts' placement/alignment in the PDF is not matching with the source Excel file
- Bottom line is way longer that the original in template file
- Data shifted to the right in template file
- Text is overlapped with white background in template file
- Cell alignment is to left instead of right in template file
- Text and text alignment is messed up in template file
- JavaScript error when export to HTML
- Loss of text in template file
- Loss of text in template file
- Failed conversions from XLS to PDF with Aspose.Cells APIs
- Converting Excel file containing hyperlinks to HTML - Cell referenced hyperlinks don't work
- Issue with the formatting of an Arrow shape / object - Excel to PDF rendering
- Gantt chart is not rendered in the output PDF file format
- Issue with the returned values of parameters in calculating custom function
- Custom function involving Excel formula (INDIRECT) fails
- Issue with the value received in a CustomFunction
- Issue with RefferedArea as result of parameter's calculation
- When instantiating a Workbook with a corrupted Excel document and LoadOptions, hang occurs
- Problem with AutoFilters on formulas
- Conditional format with number format does not work for XLS
- Style.isDateTime returns false for a cell formatted as Date
- Left border appearing when it shouldn't for a cell that has adjacent hidden column
- Formulas are not updated correctly after insert rows
- Dynamic print area broken when save as / print PDF
- Some Hebrew characters in the textbox missing in the output PDF file
- The value axis and category axis labels in the chart are blacked out (Excel to PDF conversion)
- Text is too large and expanding beyond the margin
- Bold text characters overlap with each other while converting worksheet to image
- The text outside of the page break is rendered in PDF as wrapped text
- Issue with page break, fonts rendering and margins in Excel to PDF rendering
- Aspose.Cells: cut off text in original cell is showed fully when converted to PDF
- Page Layout issue (RTL) rendering
- Footer is mess up in the generated PDF file
- A small dot appears at the center of Pie Chart while saving it to image
- Chart used to be able to accept a series formula with empty values but now it throws exception
- Rendering problems while converting chart to image
- Issue with chart axis labels' width when converting Excel worksheet to image
- Chart Data Label properties issue
- Pie Chart percentage problem

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.

- Calculate Page Setup Scaling Factor
- Copy Row Heights of Source Range to Destination Range

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
Aspose - The .NET and Java component publisher
Phone: 888.277.6734
Fax: 866.810.9465
Every time you till, you lose 30% of your organic matter. But this tiny ad is durable:
Free, earth friendly heat - from the CodeRanch trailboss
    Bookmark Topic Watch Topic
  • New Topic