From ae346b58f26e920407f6abc8315068ffe6fb2579 Mon Sep 17 00:00:00 2001 From: satomichan Date: Thu, 11 Feb 2021 05:33:18 +0900 Subject: [PATCH] =?utf8?q?=E3=82=B3=E3=83=A1=E3=83=B3=E3=83=88=E6=95=B4?= =?utf8?q?=E7=90=86=E3=80=82?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- src/main/java/jp/satomichan/nucalgen/Nucalgen.java | 13 ++----------- 1 file changed, 2 insertions(+), 11 deletions(-) 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); } } -- 2.24.4