Hi Bhushan,
we use a simple workaround. We create a template file using excel. All
charts are already added, the data is outside the print area. Then we load
the excel via POI, overwrite the data into the hidden fields --> the charts
becomes updated. Afterwards the file is saved under another filename. Works
very well - we do have some issues with updating formulas because they do
not recalculate all the time. But this should be fixed with 3.1 (we still
use 3.0). A simple workaround for this is a macro inside the template which
refreshes all data when openening the file.
Regards
Joern
Bhushan Jain schrieb:
Hi,
I am using the POI 3.1 final version. But it do not support the drawing of
charts in excel(spreadsheet).
It was being said that the next version release will come up with a solution
to this issue......
I wanted to know that is it sure that we can create charts in spreadsheet
from the next version and also that when will the next version or the
version addressing the issue be released?
Thanks,
-------------
Bhushan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
