From df16f03172c33968ef96d2d6f484ace61460719a Mon Sep 17 00:00:00 2001 From: Yegor Kozlov Date: Wed, 5 Aug 2009 17:02:04 +0000 Subject: Fixed XSSFCell to correctly parse column indexes greater than 702 (ZZ), see Bugzilla #47606 git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@801305 13f79535-47bb-0310-9956-ffa450edef68 --- .../java/org/apache/poi/xssf/usermodel/XSSFCell.java | 17 +---------------- 1 file changed, 1 insertion(+), 16 deletions(-) (limited to 'src/ooxml/java/org') diff --git a/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFCell.java b/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFCell.java index e817553a4c..f6615b73e8 100644 --- a/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFCell.java +++ b/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFCell.java @@ -97,7 +97,7 @@ public final class XSSFCell implements Cell { this.cell = cell; this.row = row; if (cell.getR() != null) { - this.cellNum = parseCellNum(cell.getR()); + this.cellNum = new CellReference(cell.getR()).getCol(); } this.sharedStringSource = row.getSheet().getWorkbook().getSharedStringSource(); this.stylesSource = row.getSheet().getWorkbook().getStylesSource(); @@ -647,21 +647,6 @@ public final class XSSFCell implements Cell { cell.setR(ref); } - /** - * Converts A1 style reference into 0-based column index - * - * @param r an A1 style reference to the location of this cell - * @return 0-based column index - */ - protected static short parseCellNum(String r) { - r = r.split("\\d+")[0]; - if (r.length() == 1) { - return (short) (r.charAt(0) - 'A'); - } else { - return (short) (r.charAt(1) - 'A' + 26 * (r.charAt(0) - '@')); - } - } - /** * Set the cells type (numeric, formula or string) * -- cgit v1.2.3