diff options
| -rw-r--r-- | src/documentation/xdocs/who.xml | 1 | ||||
| -rw-r--r-- | src/java/org/apache/poi/hssf/usermodel/HSSFCell.java | 15 |
2 files changed, 10 insertions, 6 deletions
diff --git a/src/documentation/xdocs/who.xml b/src/documentation/xdocs/who.xml index f4f1826084..504fbbf5f4 100644 --- a/src/documentation/xdocs/who.xml +++ b/src/documentation/xdocs/who.xml @@ -52,6 +52,7 @@ <section title="Developers"> <ul> <li>Shawn Laubach (shawnlaubach at cox dot net)</li> + <li>Jason Height (jheight at chariot dot net dot au)</li> </ul> </section> </section> diff --git a/src/java/org/apache/poi/hssf/usermodel/HSSFCell.java b/src/java/org/apache/poi/hssf/usermodel/HSSFCell.java index 27d9d681e3..b3aaf2dbbd 100644 --- a/src/java/org/apache/poi/hssf/usermodel/HSSFCell.java +++ b/src/java/org/apache/poi/hssf/usermodel/HSSFCell.java @@ -719,16 +719,16 @@ public class HSSFCell //Workbook.currentBook = null; } } - + public String getCellFormula() { //Workbook.currentBook=book; SheetReferences refs = book.getSheetReferences(); String retval = FormulaParser.toFormulaString(refs, ((FormulaRecordAggregate)record).getFormulaRecord().getParsedExpression()); //Workbook.currentBook=null; - return retval; + return retval; } - - + + /** * get the value of the cell as a number. For strings we throw an exception. * For blank cells we return a 0. @@ -954,7 +954,7 @@ public class HSSFCell { return record; } - + /** * @throws RuntimeException if the bounds are exceeded. */ @@ -962,6 +962,9 @@ public class HSSFCell if (cellNum > 255) { throw new RuntimeException("You cannot have more than 255 columns "+ "in a given row (IV). Because Excel can't handle it"); - } + } + else if (cellNum < 0) { + throw new RuntimeException("You cannot reference columns with an index of less then 0."); + } } } |