teratail header banner
teratail header banner
質問するログイン新規登録

質問編集履歴

1

コードを追記しました。

2020/10/14 02:51

投稿

happy9235
happy9235

スコア1

title CHANGED
File without changes
body CHANGED
@@ -21,4 +21,74 @@
21
21
 
22
22
  ### 補足情報(FW/ツールのバージョンなど)
23
23
 
24
+ ```ここに言語を入力
25
+
26
+
27
+ function myFunction() {
28
+ //ソート・星式コピー
29
+ var spreadsheet = SpreadsheetApp.getActive();
30
+ spreadsheet.getRange('H4').activate();
31
+ var criteria = SpreadsheetApp.newFilterCriteria()
32
+ .setHiddenValues(['××', '××', '××', '××', '××', '××', '××'])
33
+ .build();
34
+ spreadsheet.getActiveSheet().getFilter().setColumnFilterCriteria(8, criteria);
35
+ spreadsheet.getCurrentCell().offset(40, 2).activate();
36
+ var destinationRange = spreadsheet.getActiveRange().offset(0, 0, 530);
37
+ spreadsheet.getActiveRange().autoFill(destinationRange, SpreadsheetApp.AutoFillSeries.DEFAULT_SERIES);
38
+ spreadsheet.getCurrentCell().offset(0, 0, 530, 1).activate();
39
+ spreadsheet.getRange('H4').activate();
40
+ criteria = SpreadsheetApp.newFilterCriteria()
24
- ここにより詳細な情報を記載してください。
41
+ .setHiddenValues([])
42
+ .build();
43
+ spreadsheet.getActiveSheet().getFilter().setColumnFilterCriteria(8, criteria);
44
+ spreadsheet.getRange('G4').activate();
45
+ criteria = SpreadsheetApp.newFilterCriteria()
46
+ .setHiddenValues(['××', '××'])
47
+ .build();
48
+ spreadsheet.getActiveSheet().getFilter().setColumnFilterCriteria(7, criteria);
49
+ spreadsheet.getCurrentCell().offset(1, 3).activate();
50
+ destinationRange = spreadsheet.getActiveRange().offset(0, 0, 530);
51
+ spreadsheet.getActiveRange().autoFill(destinationRange, SpreadsheetApp.AutoFillSeries.DEFAULT_SERIES);
52
+ spreadsheet.getCurrentCell().offset(0, 0, 530, 1).activate();
53
+ spreadsheet.getRange('G4').activate();
54
+ criteria = SpreadsheetApp.newFilterCriteria()
55
+ .setHiddenValues([])
56
+ .build();
57
+ spreadsheet.getActiveSheet().getFilter().setColumnFilterCriteria(7, criteria);
58
+ //列挿入
59
+ var spreadsheet = SpreadsheetApp.getActive();
60
+ spreadsheet.getRange('I:I').activate();
61
+ spreadsheet.getActiveSheet().insertColumnsAfter(spreadsheet.getActiveRange().getLastColumn(), 2);
62
+ spreadsheet.getActiveRange().offset(0, spreadsheet.getActiveRange().getNumColumns(), spreadsheet.getActiveRange().getNumRows(), 2).activate();
63
+ var spreadsheet = SpreadsheetApp.getActive();
64
+ spreadsheet.getRange('L:L').activate();
65
+ spreadsheet.getActiveSheet().insertColumnsAfter(spreadsheet.getActiveRange().getLastColumn(), 2);
66
+ spreadsheet.getActiveRange().offset(0, spreadsheet.getActiveRange().getNumColumns(), spreadsheet.getActiveRange().getNumRows(), 2).activate();
67
+ var spreadsheet = SpreadsheetApp.getActive();
68
+ spreadsheet.getRange('O:O').activate();
69
+ spreadsheet.getActiveSheet().insertColumnsAfter(spreadsheet.getActiveRange().getLastColumn(), 2);
70
+ spreadsheet.getActiveRange().offset(0, spreadsheet.getActiveRange().getNumColumns(), spreadsheet.getActiveRange().getNumRows(), 2).activate();
71
+ //数式入力・オートフィル・値コピー
72
+ var spreadsheet = SpreadsheetApp.getActive();
73
+ spreadsheet.getRange('J5').activate()
74
+ .setFormula('=MAXIFS(I:I,D:D,D5)');
75
+ spreadsheet.getActiveRange().autoFill(spreadsheet.getRange('J5:J538'), SpreadsheetApp.AutoFillSeries.DEFAULT_SERIES);
76
+ spreadsheet.getRange('K5').activate();
77
+ spreadsheet.getRange('J5').copyTo(spreadsheet.getActiveRange(), {contentsOnly:true});
78
+ var spreadsheet = SpreadsheetApp.getActive();
79
+ spreadsheet.getRange('M5').activate()
80
+ .setFormula('=SUMIFS(L:L,D:D,D5)');
81
+ spreadsheet.getActiveRange().autoFill(spreadsheet.getRange('M5:M538'), SpreadsheetApp.AutoFillSeries.DEFAULT_SERIES);
82
+ spreadsheet.getRange('N5').activate();
83
+ spreadsheet.getRange('M5').copyTo(spreadsheet.getActiveRange(), {contentsOnly:true});
84
+ var spreadsheet = SpreadsheetApp.getActive();
85
+ spreadsheet.getRange('P5').activate()
86
+ .setFormula('=MAXIFS(O:O,D:D,D5)');
87
+ spreadsheet.getActiveRange().autoFill(spreadsheet.getRange('P5:P538'), SpreadsheetApp.AutoFillSeries.DEFAULT_SERIES);
88
+ var sheet = SpreadsheetApp.getActiveSheet()
89
+ var range = sheet.getRange('M:M');
90
+ var target = sheet.getRange('N:N');
91
+ range.copyTo(target, {contentsOnly:true});
92
+ };
93
+
94
+ ```