|Summary:||POI is really far beyond being usable|
|Product:||POI||Reporter:||ahmed rehman <rehman>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
Description ahmed rehman 2004-09-16 10:30:52 UTC
I tried to use a very simple Excell (numbers, texts, Summs) as a template, I must say in current version of HSSF the efforts are too big. 1. POI isn't able to read most simple formulas from an existing Excel worksheet (I tracked it a bit and think: when rows or cells are copied or moved even edited on an existing workshhet then all or part of formulas become unreadable by POI HSSF (it reads only "#NAME, or "NO IDEA ...")) 2. Also the Modell is very complex (for no practical or technical benefit) and misses every now and then an important method where you would expect and need one. sample: Changing the type of cell (formula to number or back) is not possible, it fails, Creating a new Cell instead if type changed is in practice not possible because i cant read the row position of the old cell HSSFCell gives no information about position
Comment 1 Andy Oliver 2004-09-16 14:23:24 UTC
This is a bug with your not having read any documentation, not understanding the correct forum for questions and instead choosing to file a bug which is really just a rant and from what it looks like you're using a 4 year old version (1.02).