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 <[email protected]> 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 <[email protected]> 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: [email protected] >> For additional commands, e-mail: [email protected] >> >> > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
