1import { A1Key } from "../../../main/js/models/common/A1Key";
 2import { SheetColumnRowKey } from "../../../main/js/models/common/SheetColumnRowKey";
 3import { CellQuery } from "../../../main/js/models/nodes/CellQuery";
 4
 5export class CommonModels {
 6  static A1 = SheetColumnRowKey.from("Alpha", A1Key.fromString("A1").toColumnRowKey());
 7  static M22 = SheetColumnRowKey.from("Alpha", A1Key.fromString("M22").toColumnRowKey());
 8  static M22_RANGE = CellQuery.builder()
 9    .setSheet("Alpha")
10    .columnsBetween(CommonModels.M22.column, CommonModels.M22.column)
11    .rowsBetween(CommonModels.M22.row, CommonModels.M22.row)
12    .build();
13
14  static G19 = SheetColumnRowKey.from("Alpha", A1Key.fromString("G19").toColumnRowKey());
15  static G19_RANGE = CellQuery.builder()
16    .setSheet("Alpha")
17    .columnsBetween(CommonModels.G19.column, CommonModels.G19.column)
18    .rowsBetween(CommonModels.G19.row, CommonModels.G19.row)
19    .build();
20
21  static J6 = SheetColumnRowKey.from("Alpha", A1Key.fromString("J6").toColumnRowKey());
22  static J6_RANGE = CellQuery.builder()
23    .setSheet("Alpha")
24    .columnsBetween(CommonModels.J6.column, CommonModels.J6.column)
25    .rowsBetween(CommonModels.J6.row, CommonModels.J6.row)
26    .build();
27
28  static D1 = SheetColumnRowKey.from("Alpha", A1Key.fromString("D1").toColumnRowKey());
29  static D3 = SheetColumnRowKey.from("Alpha", A1Key.fromString("D3").toColumnRowKey());
30  static D5 = SheetColumnRowKey.from("Alpha", A1Key.fromString("D5").toColumnRowKey());
31  static D1_TO_D3_RANGE = CellQuery.builder()
32    .setSheet("Alpha")
33    .columnsBetween(CommonModels.D1.column, CommonModels.D3.column)
34    .rowsBetween(CommonModels.D1.row, CommonModels.D3.row)
35    .build();
36  static D1_TO_D5_RANGE = CellQuery.builder()
37    .setSheet("Alpha")
38    .columnsBetween(CommonModels.D1.column, CommonModels.D5.column)
39    .rowsBetween(CommonModels.D1.row, CommonModels.D5.row)
40    .build();
41
42  static M44 = A1Key.fromString("M44").toColumnRowKey();
43  static M44_RANGE = CellQuery.builder()
44    .setSheet("Alpha")
45    .columnsBetween(CommonModels.M44.column, CommonModels.M44.column)
46    .rowsBetween(CommonModels.M44.row, CommonModels.M44.row)
47    .build();
48  static B1 = A1Key.fromString("B1").toColumnRowKey();
49  static B4 = A1Key.fromString("B4").toColumnRowKey();
50  static B1_B4_RANGE = CellQuery.builder()
51    .setSheet("Alpha")
52    .columnsBetween(CommonModels.B1.column, CommonModels.B4.column)
53    .rowsBetween(CommonModels.B1.row, CommonModels.B4.row)
54    .build();
55}