diff options
| author | Nick Burch <nick@apache.org> | 2013-10-31 16:53:03 +0000 |
|---|---|---|
| committer | Nick Burch <nick@apache.org> | 2013-10-31 16:53:03 +0000 |
| commit | 374ea84aa6c74a0a0bb540958be41eb90c9cf7a5 (patch) | |
| tree | 7977ede1a366c155bd0114831587cd7177d589ec /src/java | |
| parent | 2bd3296911e74f25f8d12a7b20a2b499b9fd40e2 (diff) | |
| download | poi-374ea84aa6c74a0a0bb540958be41eb90c9cf7a5.tar.gz poi-374ea84aa6c74a0a0bb540958be41eb90c9cf7a5.zip | |
Allow formatting of formula error cells, giving back the error string that Excel shows #55729
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1537552 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'src/java')
| -rw-r--r-- | src/java/org/apache/poi/ss/usermodel/DataFormatter.java | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/java/org/apache/poi/ss/usermodel/DataFormatter.java b/src/java/org/apache/poi/ss/usermodel/DataFormatter.java index 4e3718e956..273dd89ef2 100644 --- a/src/java/org/apache/poi/ss/usermodel/DataFormatter.java +++ b/src/java/org/apache/poi/ss/usermodel/DataFormatter.java @@ -829,6 +829,8 @@ public class DataFormatter { return String.valueOf(cell.getBooleanCellValue()); case Cell.CELL_TYPE_BLANK : return ""; + case Cell.CELL_TYPE_ERROR: + return FormulaError.forInt(cell.getErrorCellValue()).getString(); } throw new RuntimeException("Unexpected celltype (" + cellType + ")"); } |