Bug 55005

Summary: Custom formula not getting read properly
Product: POI Reporter: uogra
Component: XSSFAssignee: POI Developers List <dev>
Status: NEEDINFO ---    
Severity: normal    
Priority: P2    
Version: 3.9-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   

Description uogra 2013-05-22 10:54:13 UTC
I have an excell sheet with only one cell. Value in the cell is 576
Now right click it, format cells and chose custom. Here I applied this formula:
_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)

Now I use POI library to read this cell. 

DataFormatter formatter = new DataFormatter();
content = formatter.formatCellValue(hssfCell);

where hssfCell is Cell object

But it is getting read as :
* 576

Even if I use formulaevaluator I get the same response
So an extra * is coming in the read value
Comment 1 Dominik Stadler 2015-09-07 20:10:27 UTC
If this is still an issue for you, can you attach a sample Excel file to allow others to reproduce the problem more easily?