Bug 31260

Summary: POI is really far beyond being usable
Product: POI Reporter: ahmed rehman <rehman>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED INVALID    
Severity: enhancement    
Priority: P3    
Version: 1.0.2   
Target Milestone: ---   
Hardware: All   
OS: other   

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).