You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by "Andrew C. Oliver" <ac...@apache.org> on 2003/04/24 23:18:50 UTC
Re: [POI] Number of sheet.addMergedRegion
There is a bug regarding this in bugzilla. Basically HSSF doesn't know how
to "continue" merged cell records. If the size of the merged cell exceeds
the limit (like 2k or 4k IIRC) then it is supposed to create a continuation
record and put the rest of the data (up to that limit) in the continuation
record with subsequent continuation records until its done. HSSF is trying
to dump it all into one record. That¹s very naughty.
In the next few weeks we're going to be putting out a 2.0pre release. It
would be killer if someone could fix this bug. However, its unlikely I'll
have time. I've got bigger cockroaches to fry.
-Andy
On 4/24/03 5:02 PM, "Lior Shliechkorn" <li...@yahoo.com> wrote:
> I'm still stuck on the fact that I can not merge enough data cells in a report
> file. I ran the report and the number of lines exceeded 90,000 but I only
> wanted to merge certain parts of the report. I tried to include a template of
> what I'm trying to do with the reports, with a message inside, but yahoo
> attachement is currently down. If you can help me, I'll e-mail you the
> template. Otherwise, is there any other way to merge cells other than
> addMergedRegion(new Region(....))? Again, I appreciate all the time and effort
> being given to me. Thanks,
> Lior
>
>
> ---------------------------------
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
Re: [POI] Number of sheet.addMergedRegion
Posted by "Andrew C. Oliver" <ac...@apache.org>.
There are always 3 options:
1. Wait for it to get fixed while giving samples and info necessary to help
someone else fix it
2. Fix it yourself (read the web pages for how. its pretty well explained.)
3. pay someone to do it.
I'm sure it will get fixed before too long if you opt for one. Its a
problem for a number of folks
We always encourage patches.
#3 is how I make my living. I can certainly help find someone to do this
for you.
-Andy
On 4/25/03 9:39 AM, "Lior Shliechkorn" <li...@yahoo.com> wrote:
> Is there any other way of getting this done, or is this basically up in the
> air until the bug gets fixed? I wish I knew enough to even look at how to fix
> this bug. Any ideas?
>
> "Andrew C. Oliver" <ac...@apache.org> wrote: There is a bug regarding this
> in bugzilla. Basically HSSF doesn't know how
> to "continue" merged cell records. If the size of the merged cell exceeds
> the limit (like 2k or 4k IIRC) then it is supposed to create a continuation
> record and put the rest of the data (up to that limit) in the continuation
> record with subsequent continuation records until its done. HSSF is trying
> to dump it all into one record. That?s very naughty.
>
> In the next few weeks we're going to be putting out a 2.0pre release. It
> would be killer if someone could fix this bug. However, its unlikely I'll
> have time. I've got bigger cockroaches to fry.
>
> -Andy
>
> On 4/24/03 5:02 PM, "Lior Shliechkorn"
> wrote:
>
>> I'm still stuck on the fact that I can not merge enough data cells in a
>> report
>> file. I ran the report and the number of lines exceeded 90,000 but I only
>> wanted to merge certain parts of the report. I tried to include a template of
>> what I'm trying to do with the reports, with a message inside, but yahoo
>> attachement is currently down. If you can help me, I'll e-mail you the
>> template. Otherwise, is there any other way to merge cells other than
>> addMergedRegion(new Region(....))? Again, I appreciate all the time and
>> effort
>> being given to me. Thanks,
>> Lior
>>
>>
>> ---------------------------------
>> Do you Yahoo!?
>> The New Yahoo! Search - Faster. Easier. Bingo.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
>
> ---------------------------------
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
Re: [POI] Number of sheet.addMergedRegion
Posted by Lior Shliechkorn <li...@yahoo.com>.
Is there any other way of getting this done, or is this basically up in the air until the bug gets fixed? I wish I knew enough to even look at how to fix this bug. Any ideas?
"Andrew C. Oliver" <ac...@apache.org> wrote: There is a bug regarding this in bugzilla. Basically HSSF doesn't know how
to "continue" merged cell records. If the size of the merged cell exceeds
the limit (like 2k or 4k IIRC) then it is supposed to create a continuation
record and put the rest of the data (up to that limit) in the continuation
record with subsequent continuation records until its done. HSSF is trying
to dump it all into one record. That�s very naughty.
In the next few weeks we're going to be putting out a 2.0pre release. It
would be killer if someone could fix this bug. However, its unlikely I'll
have time. I've got bigger cockroaches to fry.
-Andy
On 4/24/03 5:02 PM, "Lior Shliechkorn"
wrote:
> I'm still stuck on the fact that I can not merge enough data cells in a report
> file. I ran the report and the number of lines exceeded 90,000 but I only
> wanted to merge certain parts of the report. I tried to include a template of
> what I'm trying to do with the reports, with a message inside, but yahoo
> attachement is currently down. If you can help me, I'll e-mail you the
> template. Otherwise, is there any other way to merge cells other than
> addMergedRegion(new Region(....))? Again, I appreciate all the time and effort
> being given to me. Thanks,
> Lior
>
>
> ---------------------------------
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.