You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Karl-Heinz Zengerle <ka...@sawag.com> on 2004/06/30 16:24:16 UTC
Excel charts
Hi world.
It looks like charts are not fully supported yet (implicitly loading and
resaving - similar to macros; changing chart parameters) but that this
is in development.
Is it already planned in which version charts are supported better (or
fully)?
Regards, Karl-Heinz.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: HSSFSheet.removeRow()
Posted by Karl-Heinz Zengerle <ka...@sawag.com>.
Hi Davinder.
Indexes start at 0. So typically a none value is expressed by a negative
value. So it's nothing strange.
Regards, Karl-Heinz.
Am Do 01.07.2004 17:15 schrieb Davinder Kohli <kd...@yahoo.com>:
> In a sheet containing 65536 rows, I invoked removeRow,
> after all rows were removed the lastRowNum and
> firstRowNum were both set to -1. Shouldn't both these
> be set to 0?
>
> HSSFSheet sheet = m_workbook.getSheet(sheetName);
> // get the last row num
> int lastRowNum = sheet.getLastRowNum();
> // lastRowNum returns 65535
> for (int i = 0; i < lastRowNum +1; i++)
> {
> // get the row and remove it
> sheet.removeRow(sheet.getRow(i));
> }
>
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> New and Improved Yahoo! Mail - 100MB free storage!
> http://promotions.yahoo.com/new_mail
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
HSSFSheet.removeRow()
Posted by Davinder Kohli <kd...@yahoo.com>.
In a sheet containing 65536 rows, I invoked removeRow,
after all rows were removed the lastRowNum and
firstRowNum were both set to -1. Shouldn't both these
be set to 0?
HSSFSheet sheet = m_workbook.getSheet(sheetName);
// get the last row num
int lastRowNum = sheet.getLastRowNum();
// lastRowNum returns 65535
for (int i = 0; i < lastRowNum +1; i++)
{
// get the row and remove it
sheet.removeRow(sheet.getRow(i));
}
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: Excel charts
Posted by Karl-Heinz Zengerle <ka...@sawag.com>.
Hi Danny.
V3.0 sounds to be very interesting.
Regards, Karl-Heinz.
Am Mi 30.06.2004 17:37 schrieb Danny Mui <da...@muibros.com>:
> 3.0 is a major rewrite of the codebase to use less memory and perform
> faster. I think Andy placed the benchmarks on some of the extreme
> cases
> to save lots o'memory.
>
> Having said that, it's a lil broken at the moment since it's a branch
> based on about 2.0 code, the current unit tests don't all pass. So
> having said all that, yes, vague heh.
>
> Karl-Heinz Zengerle wrote:
>
> > Hi Danny.
> >
> > As we're at 2.5 it could be the next version. Is also the date for
> > that
> > release planned or is it rather vague?
> >
> > Regards, Karl-Heinz.
> >
> >
> > Am Mi 30.06.2004 16:32 schrieb Danny Mui <da...@muibros.com>:
> >
> >
> >>IIRC i think it was targetted for sometime in the 3.0 world. perfect
> >>contributing oppty :).
> >>
> >>Karl-Heinz Zengerle wrote:
> >>
> >>
> >>>Hi world.
> >>>
> >>>It looks like charts are not fully supported yet (implicitly
> >>>loading
> >>>and
> >>>resaving - similar to macros; changing chart parameters) but that
> >>>this
> >>>is in development.
> >>>
> >>>Is it already planned in which version charts are supported better
> >>>(or
> >>>fully)?
> >>>
> >>>Regards, Karl-Heinz.
> >>>
> >>>
> >>>
>
> >>>>>>---------------------------------------------------------------------
> >>>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> >>>For additional commands, e-mail: poi-user-help@jakarta.apache.org
> >>
>
> >>>>---------------------------------------------------------------------
> >>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> >>For additional commands, e-mail: poi-user-help@jakarta.apache.org
> >>
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: Excel charts
Posted by Danny Mui <da...@muibros.com>.
3.0 is a major rewrite of the codebase to use less memory and perform
faster. I think Andy placed the benchmarks on some of the extreme cases
to save lots o'memory.
Having said that, it's a lil broken at the moment since it's a branch
based on about 2.0 code, the current unit tests don't all pass. So
having said all that, yes, vague heh.
Karl-Heinz Zengerle wrote:
> Hi Danny.
>
> As we're at 2.5 it could be the next version. Is also the date for that
> release planned or is it rather vague?
>
> Regards, Karl-Heinz.
>
>
> Am Mi 30.06.2004 16:32 schrieb Danny Mui <da...@muibros.com>:
>
>
>>IIRC i think it was targetted for sometime in the 3.0 world. perfect
>>contributing oppty :).
>>
>>Karl-Heinz Zengerle wrote:
>>
>>
>>>Hi world.
>>>
>>>It looks like charts are not fully supported yet (implicitly loading
>>>and
>>>resaving - similar to macros; changing chart parameters) but that
>>>this
>>>is in development.
>>>
>>>Is it already planned in which version charts are supported better
>>>(or
>>>fully)?
>>>
>>>Regards, Karl-Heinz.
>>>
>>>
>>>
>>>---------------------------------------------------------------------
>>>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: Excel charts
Posted by Karl-Heinz Zengerle <ka...@sawag.com>.
Hi Danny.
As we're at 2.5 it could be the next version. Is also the date for that
release planned or is it rather vague?
Regards, Karl-Heinz.
Am Mi 30.06.2004 16:32 schrieb Danny Mui <da...@muibros.com>:
> IIRC i think it was targetted for sometime in the 3.0 world. perfect
> contributing oppty :).
>
> Karl-Heinz Zengerle wrote:
>
> > Hi world.
> >
> > It looks like charts are not fully supported yet (implicitly loading
> > and
> > resaving - similar to macros; changing chart parameters) but that
> > this
> > is in development.
> >
> > Is it already planned in which version charts are supported better
> > (or
> > fully)?
> >
> > Regards, Karl-Heinz.
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: Excel charts
Posted by Danny Mui <da...@muibros.com>.
IIRC i think it was targetted for sometime in the 3.0 world. perfect
contributing oppty :).
Karl-Heinz Zengerle wrote:
> Hi world.
>
> It looks like charts are not fully supported yet (implicitly loading and
> resaving - similar to macros; changing chart parameters) but that this
> is in development.
>
> Is it already planned in which version charts are supported better (or
> fully)?
>
> Regards, Karl-Heinz.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org