[XLSx Auto width]

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

[Subreports with different properties in book report]

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:

Subreport	Properties
Cover Page	Standerd A4 report
Master 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]
Summary	Standerd 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

[Jasper Report integration with Oracle Apex]

Hi

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

Thank You

Monty

[XLSx Auto width]

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

[How to auto table Excel width?]

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