Use org.apache.poi.hssf.dev.BiffViewer to get an idea how Excel stores location of charts. Dump a file with a chart and examine what records hold the positioning information.
Yegor On Fri, Aug 24, 2012 at 2:08 PM, Varghese Antony <[email protected]> wrote: > Hi, > > Currently i am trying to display the charts in excel 2003 using the > HSSFChart APIs. But i am facing problem in finding the location and size > of the charts to be displayed. > > I tried the getX(), getY(), getWidth(), setHeight() APIs of "ChartRecord" > but it always return constant values 0,0,X,X for all charts. I also checked > the values getting stored in > > LegendRecord. i.e ( private int field_1_xAxisUpperLeft; > private int field_2_yAxisUpperLeft; > private int field_3_xSize; > private int field_4_ySize;) but this values are constant for > a particular chart even if its location is changed.. So how to get the > location and size for a chart. > > Do i have to extend hssf/record/chart by adding PosRecord for handling the > Pos field in a graph, will it solve problem , is there any other method? > > > Thanks > Varghese --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
