montherz

It seems that it is a reported issue [#2795]and it is still open .... I will export my report as XLS and manully save it as XLSx until this is fixed Thank You Monty

6.6 and it is still there :)

Hi guys, TIBCO Jaspersoft® Studio 6.6.0 - Visual Designer for JasperReports 6.6.0. I have a book report with 4 subreports in it that will be exported to XLSx and some reports have different properties than other: SubreportPropertiesCover PageStanderd A4 reportMaster Report <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/> <property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/> <property name="net.sf.jasperreports.export.xls.wrap.text" value="false"/> <property name="net.sf.jasperreports.print.keep.full.text" value="true"/> <property name="net.sf.jasperreports.export.xls.create.custom.palette" value="true"/> <property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="false"/> <property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>[/code]Detail Report <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/> <property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/> <property name="net.sf.jasperreports.export.xls.wrap.text" value="false"/> <property name="net.sf.jasperreports.print.keep.full.text" value="true"/> <property name="net.sf.jasperreports.export.xls.create.custom.palette" value="true"/> <property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="false"/> <property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>[/code]SummaryStanderd A4 report I tried setting those properties in the sub report but when I run the book report all subreports will inherit the book report proberties. is there a way to set a different properties for each subreport in the book report? Thank you Monty

Hi Have you tried JasperReportsIntegration by Opal Consulting ... I'm using it and it is very nice and free :) Thank You Monty

Hi, I'm using TIBCO Jaspersoft® Studio 6.6.0 - Visual Designer for JasperReports 6.6.0. for sometime now i been trying to auto fit width when exporting to XLSx. My textField looks like this: <textField> <reportElement x="600" y="0" width="190" height="39" uuid="ada9ab70-53c7-47f1-b25b-6c8ed7084657"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="dec2d24a-e1c9-450a-932c-397fd36a5c5d"/> <property name="net.sf.jasperreports.export.xls.auto.fit.row" value="true"/> <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> </reportElement> <textFieldExpression><![CDATA[$F{IML_POSITION}]]></textFieldExpression> </textField>[/code] when trying this it exports to XLS proberly but when trying XLSx it always takes the width specified for the textField (in my case width="190"). Am I missing something ??? been trying to find a solution for a while now and i've found alot of unanswered questions facing this particular problem. Help guys :) Thank You Monty

Hi, I'm facing the same problem. though <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> <property name="net.sf.jasperreports.export.xls.auto.fit.row" value="true"/> <property name="net.sf.jasperreports.print.keep.full.text" value="true"/> <property name="net.sf.jasperreports.export.xls.wrap.text" value="false"/> works with XLS it is not working with XLSx did you find a solution ??? Thank You Monty