Shift chart in an excel sheet

[martin <ma...@oneoverzero.net>]

Hello,
I would like to shift the position of a chart of an excel sheet. As I understood
the position of the chart is stored in the ChartRecord. The low level event api
gives me access to the records, but it is a read only api. The HSSFSheet does
not give me access to the low level record entries. 
The HSSFChart class in the poi-3.1-beta2 doesn't provide access for the position
and size of the chart. 
Is there another way to do that? 
Thanks very much for your reply.

Martin


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: Shift chart in an excel sheet

[Nick Burch <ni...@torchbox.com>]

On Tue, 27 May 2008, martin wrote:
> I would like to shift the position of a chart of an excel sheet. As I 
> understood the position of the chart is stored in the ChartRecord. The 
> low level event api gives me access to the records, but it is a read 
> only api. The HSSFSheet does not give me access to the low level record 
> entries.

You could subclass HSSFWorkbook, then that'll give you access to the 
underling model.Workbook object, from which you can get at all the records 
you want

Another option is to look in scratchpad at 
org.apache.poi.hssf.usermodel.HSSFChart. That is able to find all the 
charts for a given HSSFSheet, even if it can't do much with them yet. I've 
just added methods to svn trunk to let you get and set the x, y, width and 
height. That ought to do what you need

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org