I have created a spreadsheet using jrxml and I am trying to set height of all rows in that spreadsheet to 16 through method Cells.setStandardHeight(16). But this mehtod does not work and my row height in generated sheet is as per the content in it.
Can you please let me know what can be done? I dont want to use autoFitRows() coz of the way my application code is written.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Thank you for considering Aspose.
We have found your mentioned issue after an initial test. We will look into it and get back to you soon. Your issue has been registered in our internal issue tracking system with issue id: CELLSJAVA-14671.
Please try this fix (attached). And, please make sure that you call
Cells.setStandardHeight() before all the rows being instantiated (such as by
calling Cells.getRow()/getCell()) because Cells.setStandardHeight() will
only influence this way for those newly created rows and not reset existing rows'
height.
I am still having the same issue with new jar also. Lets say the jasper report height is 400 and my detail section comes up to 350, row after my last data row takes up the remaining size of report and that particular row is greater than 16. All other remaining rows of that spreadsheet are size 16.
I have set my document's IGNORE PAGINATION property to "false".
We have tested the setStandardHeight() method with the following test code
and cannot find the issue. Please confirm us for that and give us your
sample code to reproduce the issue.
So is there no way to set auto height of all cells after the content is set? We have a generic java code which fills up the data and then sets aspose properties for the spreadsheet.
So using the above method wouldn't work for us. Please let me know whats the alternative we could use.
Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
If you have any further requirement, please share your sample code, template and required output file here with details about your issue and requirements. We will look into it soon.