projects
/
nucalgen
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
7deca54
)
コメント整理。
JAR_2021-02-11_0529_BUILD
author
satomichan
<git.20200328@...>
Wed, 10 Feb 2021 20:33:18 +0000
(
05:33
+0900)
committer
satomichan
<git.20200328@...>
Wed, 10 Feb 2021 20:33:18 +0000
(
05:33
+0900)
src/main/java/jp/satomichan/nucalgen/Nucalgen.java
patch
|
blob
|
history
diff --git
a/src/main/java/jp/satomichan/nucalgen/Nucalgen.java
b/src/main/java/jp/satomichan/nucalgen/Nucalgen.java
index f37b8b0dbebebaffa6402d8623e2246b283dc679..bb80aa3e9c1f0f236a804b3f28fe01af0c1e7d51 100644
(file)
--- 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();
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);
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();
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) {
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()) {
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();
String sumArea = new CellReference(rowIndex, colIndex, true, true).formatAsString();
- //namedRangeSum.setRefersToFormula(sumArea);
namedAreaMap.put("SUM_" + aColumn.getAlias(), sumArea);
}
}
namedAreaMap.put("SUM_" + aColumn.getAlias(), sumArea);
}
}