From: satomichan Date: Wed, 10 Feb 2021 20:33:18 +0000 (+0900) Subject: コメント整理。 X-Git-Tag: JAR_2021-02-11_0529_BUILD X-Git-Url: https://satomichan.jp/gitweb/?p=nucalgen;a=commitdiff_plain;h=ae346b58f26e920407f6abc8315068ffe6fb2579 コメント整理。 --- diff --git a/src/main/java/jp/satomichan/nucalgen/Nucalgen.java b/src/main/java/jp/satomichan/nucalgen/Nucalgen.java index f37b8b0..bb80aa3 100644 --- a/src/main/java/jp/satomichan/nucalgen/Nucalgen.java +++ b/src/main/java/jp/satomichan/nucalgen/Nucalgen.java @@ -122,11 +122,8 @@ public class Nucalgen { } - //摂取量 名前付き範囲 + //摂取量 範囲を記憶 String intakeArea = new CellReference(3, 3, true, true).formatAsString() + ":" + new CellReference(rowIndex -1, 3, true, true).formatAsString(); - //XSSFName intakeNamedRangeArea = (XSSFName) outputWorkbook.createName(); - //intakeNamedRangeArea.setNameName("AREA_INTAKE"); - //intakeNamedRangeArea.setRefersToFormula(intakeArea); namedAreaMap.put("AREA_INTAKE", intakeArea); @@ -139,18 +136,12 @@ public class Nucalgen { Cell thisCell = sumRow.createCell(colIndex); String sumTargetArea = new CellReference(3, colIndex, true, true).formatAsString() + ":" + new CellReference(rowIndex -1, colIndex, true, true).formatAsString(); - //名前付き範囲(alias あれば設定) + //範囲を記憶(alias あれば設定) if(aColumn.getAlias().length() > 0) { - //XSSFName namedRangeArea = (XSSFName) outputWorkbook.createName(); - //namedRangeArea.setNameName("AREA_" + aColumn.getAlias()); - //namedRangeArea.setRefersToFormula(sumTargetArea); namedAreaMap.put("AREA_" + aColumn.getAlias(), sumTargetArea); if(aColumn.isUseSum()) { - //XSSFName namedRangeSum = (XSSFName) outputWorkbook.createName(); - //namedRangeSum.setNameName("SUM_" + aColumn.getAlias()); String sumArea = new CellReference(rowIndex, colIndex, true, true).formatAsString(); - //namedRangeSum.setRefersToFormula(sumArea); namedAreaMap.put("SUM_" + aColumn.getAlias(), sumArea); } }