poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 55005] New: Custom formula not getting read properly
Date Wed, 22 May 2013 10:54:13 GMT

            Bug ID: 55005
           Summary: Custom formula not getting read properly
           Product: POI
           Version: 3.9
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: uogra@adobe.com
    Classification: Unclassified

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

You are receiving this mail because:
You are the assignee for the bug.

To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message