poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Filip Defoort <filip...@cirquedigital.com>
Subject Re: bug in cell.setCellType(Cell.CELL_TYPE_NUMERIC) (POI 3.6)
Date Thu, 07 Jan 2010 18:36:14 GMT
Oh, and one more: unrecognized formulas (such as SUMIFS()) break POI.
It'd be great if it could just ignore those but at least keep
working...

- Filip

On Thu, Jan 7, 2010 at 10:35 AM, Filip Defoort
<filipdef@cirquedigital.com> wrote:
> Hi Nick,
>
> I'll write up some test cases - I have a few bugs that I got bitten by
> recently  (XSSF can't handle URL links in case protocol is not file or
> http; HSSF removeSheet destroys Named Ranges and Formulas that
> reference other sheets; HSSF setCellType doesn't work in some cases).
>
> I'll try to find some time over the next day or two to write up a
> working testcase for each.
>
> - Filip
>
> On Wed, Jan 6, 2010 at 2:37 AM, Nick Burch <nick.burch@alfresco.com> wrote:
>> On Tue, 5 Jan 2010, Filip Defoort wrote:
>>>
>>> I've just stumbled across a bug in POI 3.6:
>>>
>>> cell.setCellType(Cell.CELL_TYPE_NUMERIC);
>>>
>>> doesn't work if the cell is anything other than blank or a numeric
>>> cell - which kinda defeats the purpose of the whole thing...
>>
>> Any chance you could open a new bug on bugzilla, and upload a quick little
>> test case of the java that makes this fall over? That'll give us something
>> to test against when we come to fix it, plus then a test to make sure it
>> doesn't get broken again in the future! :)
>>
>> Nick
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>>
>

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


Mime
View raw message