Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Live chart size when exporting to Excel
TED KONG
<p>Hi,</p>
<p> </p>
<p>I faced a problem when exporting chart to Excel file as live chart format.</p>
<p>Report preview works well with the chart and PDF export works as well.</p>
<p>However live chart in Excel shrinks to the size of one single cell so I should make it larger using mouse to see the chart.</p>
<p> </p>
<p>Chart part of the rptdesign file is the following.</p>
<p> </p>
<div> <grid name="SUMMARY_DETAILS_GRID" id="273"></div>
<div> <column id="274"/></div>
<div> <row id="275"></div>
<div> <cell id="276"></div>
<div> <property name="textAlign">left</property></div>
<div> <label id="661"></div>
<div> <property name="style">content-title-first</property></div>
<div> <property name="textAlign">left</property></div>
<div> <text-property name="text" key="SUMMARY">Summary</text-property></div>
<div> </label></div>
<div> <extended-item extensionName="Chart" id="2914"></div>
<div> <xml-property name="xmlRepresentation"><![CDATA[......]]></xml-property></div>
<div> <property name="outputFormat">PNG</property></div>
<div> <property name="inheritColumns">false</property></div>
<div> <property name="height">310pt</property></div>
<div> <property name="width">7.6in</property></div>
<div> <property name="dataSet">Summary</property></div>
<div> <list-property name="boundDataColumns"></div>
<div> <structure></div>
<div> </div>
<div>I am attaching two screen shots.</div>
<div>One is report preview which works fine.</div>
<div>The other is live chart in Excel which I have to make it bigger using mouse to see the chart.</div>
<div> </div>
<div>Regards,</div>
<div>Ted.</div>
Find more posts tagged with
Comments
JFreeman
<p>Which version of BIRT are you using?</p>
<p>Which excel emitter are you using?</p>
<p> </p>
<p>Can you attach a sample report based on classic models or a flat file data source that we can run to replicate the issue?</p>
TED KONG
<p>I am using 4.3.2 and the following is the detailed installation.</p>
<p> </p>
<div> BIRT Chart Framework<span> </span>4.3.2.v20140211-1400-828v7QFQCnvKw65AL16KlJ</div>
<div> BIRT Chart OSGi Runtime SDK Feature<span> </span>4.3.2.v20140211-1400-795385HCXEZKbiOFsIT1hkXTBJft</div>
<div> BIRT Engine OSGi Runtime SDK Feature<span> </span>4.3.2.v20140211-1400-795388UF5G6LKl-4mBu2LJ7GXD29</div>
<div> BIRT Framework<span> </span>4.3.2.v20140211-1400-DPDKA5GixAoaudOsMil4K3C7KNz0</div>
<div> Eclipse BIRT Chart Context Sensitive Help Documentation<span> </span>4.3.2.v20140211-1400-5217w3125132202511</div>
<div> Eclipse Birt Chart Source Feature<span> </span>4.3.2.v20140211-1400-828v7QFQCnvKw65AL16KlJ</div>
<div> Eclipse BIRT Chart Web Tools Project<span> </span>4.3.2.v20140225-1404-5217w3125133602515</div>
<div> Eclipse Birt Chart WTP Project Source Feature<span> </span>4.3.2.v20140225-1404-5217w3125133602515</div>
<div> Eclipse BIRT Context Sensitive Help Documentation<span> </span>4.3.2.v20140211-1400-5217w3125132202511</div>
<div> Eclipse BIRT Documentation<span> </span>4.3.2.v20140211-1400-5217w3125132202511</div>
<div> Eclipse BIRT Example<span> </span>4.3.2.v20140211-1400-7T7K7DDZRDKcDdMPALcU9</div>
<div> Eclipse BIRT ISV Documents<span> </span>4.3.2.v20140211-1400-5217w312513252411</div>
<div> Eclipse BIRT ISV Documents<span> </span>4.3.2.v20140211-1400-5217w3125132202511</div>
<div> Eclipse BIRT Source Feature<span> </span>4.3.2.v20140211-1400-DPDKA5GixAoaudOsMil4K3C7KNz0</div>
<div> Eclipse BIRT Web Tools Project<span> </span>4.3.2.v20140225-1404-5217w3125133602515</div>
<div> Eclipse BIRT WTP Project Source Feature<span> </span>4.3.2.v20140225-1404-5217w3125133602515</div>
<div> </div>
<p> </p>
<p>And using the following emitters.</p>
<p> </p>
<p>com.arctorus.export.birt37x.xlsx_4.6.2.jar</p>
<p> </p>
<p> </p>
<p> </p>
<p>And the following is redering configuration.</p>
<p> </p>
<div>option.setOutputFormat( EXCEL_RENDER_FORMAT );</div>
<div>option.setOption( IRenderOption.EMITTER_ID, "com.arctorus.export.birt37x.xlsx" );</div>
<div>option.setOption( "single_sheet", Boolean.FALSE );</div>
<div>option.setOption( "show_charts_datasheet", Boolean.TRUE );</div>
<div>option.setOption( "excel_native_charts", Boolean.TRUE );</div>
<div>option.setEnableMultipleSheet( false );</div>
<div> </div>
<div> </div>
<div> </div>
<div>And attached a sample rptdesign file.</div>
JFreeman
<p>This issue has to do with the emitter.</p>
<p>You should contact Arctorus for assistance.</p>
TED KONG
<p>Thanks Jesse. I will contact Arctorus.</p>