Bug 55005 - Custom formula not getting read properly
Summary: Custom formula not getting read properly
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.9-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2013-05-22 10:54 UTC by uogra
Modified: 2015-09-07 20:10 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
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?