RestApi/SheetsApi4/Request/Spreadsheet/Worksheet.pm

filter: Statementstmt 74.8% 149 / 199 Branchbran 41.3% 19 / 46 Conditioncond 36.8% 7 / 19 MC/DCmcdc 0.0% 0 / 11 Subroutinesub 70.6% 41 / 58 Podpod 0.0% 0 / 52 totaltotal 56.1% 216 / 385 CC 32 SCAR 21.8
CC
32
Cov
66%
update_banding
72.0
update_conditional_format_rule
12.0
_ws_tab_rgba
6.0
CRAP 8.8
« RestApi/DriveApi3/File.pm ↑ Summary RestApi/SheetsApi4/Range.pm »
1 package Google::RestApi::SheetsApi4::Request::Spreadsheet::Worksheet;
2  
3 2 our $VERSION = '2.2.5';
4  
5 2 ▶use Google::RestApi::Setup;
Subroutine BEGIN: called CC=1 SCAR=0.0
6  
7 2 ▶use aliased "Google::RestApi::SheetsApi4::Request";
Subroutine BEGIN: called CC=1 SCAR=0.0
8  
9 2 ▶use parent "Google::RestApi::SheetsApi4::Request::Spreadsheet";
Subroutine BEGIN: called CC=1 SCAR=0.0
10  
11 0 ▶sub worksheet_id { LOGDIE "Pure virtual function 'worksheet_id' must be overridden"; }
Subroutine worksheet_id: not called CC=1 SCAR=6.9
Pod undocumented
12  
13 1 ▶sub ws_rename { shift->update_worksheet_properties(properties => { title => shift }); }
Subroutine ws_rename: called CC=1 SCAR=0.0
Pod undocumented
14 1 ▶sub ws_index { shift->update_worksheet_properties(properties => { index => shift }); }
Subroutine ws_index: called CC=1 SCAR=0.0
Pod undocumented
15 1 ▶sub ws_hide { shift->update_worksheet_properties(properties => { hidden => bool(shift) }); }
Subroutine ws_hide: called CC=1 SCAR=0.0
Pod undocumented
16 0 ▶sub ws_hidden { ws_hide(@_); }
Subroutine ws_hidden: not called CC=1 SCAR=6.9
Pod undocumented
17 4 ▶sub ws_right_to_left { shift->update_worksheet_properties(properties => { rightToLeft => bool(shift) }); }
Subroutine ws_right_to_left: called CC=1 SCAR=0.0
Pod undocumented
18 2 ▶sub ws_left_to_right { shift->ws_right_to_left(bool(shift) eq 'true' ? 0 : 1); }
Subroutine ws_left_to_right: called CC=2 SCAR=7.6
Pod undocumented
Branch: 1 branch
BranchTrueFalseTotal
bool(shift()) eq 'true' ? : 2 0 2
19  
20 0 ▶sub _ws_tab_rgba { shift->ws_tab_color({ (shift) => (shift // 1) }); }
Subroutine _ws_tab_rgba: not called CC=2 SCAR=17.9
Condition0%0/2
shift() // 1
l!l
00
MC/DC0%0/1
shift() // 1
shift()
Truth table0%0/2
A
A= shift()
Aresult
11
00
21 0 ▶sub ws_tab_red { shift->_ws_tab_rgba('red' => shift); }
Subroutine ws_tab_red: not called CC=1 SCAR=6.9
Pod undocumented
22 0 ▶sub ws_tab_blue { shift->_ws_tab_rgba('blue' => shift); }
Subroutine ws_tab_blue: not called CC=1 SCAR=6.9
Pod undocumented
23 0 ▶sub ws_tab_green { shift->_ws_tab_rgba('green' => shift); }
Subroutine ws_tab_green: not called CC=1 SCAR=6.9
Pod undocumented
24 0 ▶sub ws_tab_alpha { shift->_ws_tab_rgba('alpha' => shift); }
Subroutine ws_tab_alpha: not called CC=1 SCAR=6.9
Pod undocumented
25 0 ▶sub ws_tab_black { shift->ws_tab_color(cl_black()); }
Subroutine ws_tab_black: not called CC=1 SCAR=6.9
Pod undocumented
26 0 ▶sub ws_tab_white { shift->ws_tab_color(cl_white()); }
Subroutine ws_tab_white: not called CC=1 SCAR=6.9
Pod undocumented
27 0 ▶sub ws_tab_color { shift->update_worksheet_properties(properties => { tabColor => shift }); }
Subroutine ws_tab_color: not called CC=1 SCAR=6.9
Pod undocumented
28  
29 28 ▶sub freeze_cols { shift->_freeze('col', @_); }
Subroutine freeze_cols: called CC=1 SCAR=0.0
Pod undocumented
30 28 ▶sub freeze_rows { shift->_freeze('row', @_); }
Subroutine freeze_rows: called CC=1 SCAR=0.0
Pod undocumented
31 28 ▶sub unfreeze_cols { shift->freeze_cols(); }
Subroutine unfreeze_cols: called CC=1 SCAR=0.0
Pod undocumented
32 28 ▶sub unfreeze_rows { shift->freeze_rows(); }
Subroutine unfreeze_rows: called CC=1 SCAR=0.0
Pod undocumented
33 56 ▶sub _freeze {
Subroutine _freeze: called CC=2 SCAR=6.9
34 56 my $self = shift;
35  
36 56 my $dim = shift;
37 56 state $check = signature(positional => [PositiveOrZeroInt, { default => 0 }]);
38 56 my ($count) = $check->(@_);
39  
40 # "frozenColumnCount" or "frozenRowCount".
41 56 ▶ my $frozen = "frozen" . ($dim eq 'col' ? "Column" : "Row") . "Count";
Branch: 1 branch
BranchTrueFalseTotal
$dim eq 'col' ? : 28 28 56
42  
43 56 return $self->update_worksheet_properties(
44 properties => { gridProperties => { $frozen => $count }, },
45 fields => "gridProperties.$frozen",
46 );
47 }
48  
49 63 ▶sub update_worksheet_properties {
Subroutine update_worksheet_properties: called CC=2 SCAR=7.0
Pod undocumented
50 63 my $self = shift;
51  
52 63 state $check = signature(
53 bless => !!0,
54 named => [
55 properties => HashRef,
56 fields => Str, { optional => 1 },
57 ],
58 );
59 63 my $p = $check->(@_);
60  
61 63 my $properties = $p->{properties};
62 63 ▶ my $fields = $p->{fields} || join(',', sort keys %$properties);
Condition66%2/3
$$p{'fields'} || join(',', sort(keys %$properties))
l!l&&r!l&&!r
5670
MC/DC0%0/2
$$p{'fields'} || join(',', sort(keys %$properties))
$$p{'fields'} join(',', sort(keys %$properties))
Truth table66%2/3
A || B
A= $$p{'fields'}B= join(',', sort(keys %$properties))
ABresult
1X1
011
000
63  
64 63 $self->batch_requests(
65 updateSheetProperties => {
66 properties => {
67 sheetId => $self->worksheet_id(),
68 %$properties,
69 },
70 fields => $fields,
71 },
72 );
73  
74 63 return $self;
75 }
76  
77 28 ▶sub clear_values { shift->_clear("userEnteredValue"); }
Subroutine clear_values: called CC=1 SCAR=0.0
Pod undocumented
78 28 ▶sub clear_formatting { shift->_clear("userEnteredFormat"); }
Subroutine clear_formatting: called CC=1 SCAR=0.0
Pod undocumented
79 56 ▶sub _clear {
Subroutine _clear: called CC=2 SCAR=7.0
80 56 my $self = shift;
81  
82 56 my $fields = shift;
83 56 ▶ my $range = shift || { sheetId => $self->worksheet_id() };
Condition50%1/2
shift() || {'sheetId', $self->worksheet_id}
l!l
560
MC/DC0%0/1
shift() || {'sheetId', $self->worksheet_id}
shift()
Truth table50%1/2
A
A= shift()
Aresult
11
00
84 56 $self->batch_requests(
85 updateCells => {
86 range => $range,
87 fields => $fields,
88 },
89 );
90  
91 56 return $self;
92 }
93  
94 28 ▶sub reset { shift->clear_formatting()->clear_values()->unfreeze_cols()->unfreeze_rows(); }
Subroutine reset: called CC=1 SCAR=0.0
Pod undocumented
95  
96 0 ▶sub delete_worksheet {
Subroutine delete_worksheet: not called CC=1 SCAR=6.9
Pod undocumented
97 0 my $self = shift;
98 0 $self->batch_requests(
99 deleteSheet => { sheetId => $self->worksheet_id() }
100 );
101 0 return $self;
102 }
103  
104 1 ▶sub duplicate_worksheet {
Subroutine duplicate_worksheet: called CC=4 SCAR=14.2
Pod undocumented
105 1 my $self = shift;
106  
107 1 state $check = signature(
108 bless => !!0,
109 named => [
110 new_name => Optional[Str],
111 insert_index => Optional[Int],
112 new_sheet_id => Optional[Int],
113 ],
114 );
115 1 my $p = $check->(@_);
116  
117 1 my %request = (sourceSheetId => $self->worksheet_id());
118 1 ▶ $request{newSheetName} = $p->{new_name} if defined $p->{new_name};
Branch: 1 branch
BranchTrueFalseTotal
if defined $$p{"new_name"} 1 0 1
119 1 ▶ $request{insertSheetIndex} = $p->{insert_index} if defined $p->{insert_index};
Branch: 1 branch
BranchTrueFalseTotal
if defined $$p{"insert_index"} 0 1 1
120 1 ▶ $request{newSheetId} = $p->{new_sheet_id} if defined $p->{new_sheet_id};
Branch: 1 branch
BranchTrueFalseTotal
if defined $$p{"new_sheet_id"} 0 1 1
121  
122 1 $self->batch_requests(duplicateSheet => \%request);
123  
124 1 return $self;
125 }
126  
127 4 ▶sub update_dimension_properties {
Subroutine update_dimension_properties: called CC=4 SCAR=14.1
Pod undocumented
128 4 my $self = shift;
129  
130 4 state $check = signature(
131 bless => !!0,
132 named => [
133 dimension => Str,
134 start => Int,
135 end => Optional[Int],
136 properties => HashRef,
137 fields => Str, { optional => 1 },
138 ],
139 );
140 4 my $p = $check->(@_);
141  
142 4 ▶ my $dim = uc($p->{dimension}) eq 'COL' ? 'COLUMNS' : 'ROWS';
Branch: 1 branch
BranchTrueFalseTotal
uc $$p{'dimension'} eq 'COL' ? : 2 2 4
143 4 ▶ my $end = $p->{end} // ($p->{start} + 1);
Condition50%1/2
$$p{"end"} // $$p{"start"} + 1
l!l
40
MC/DC0%0/1
$$p{"end"} // $$p{"start"} + 1
$$p{"end"}
Truth table50%1/2
A
A= $$p{"end"}
Aresult
11
00
144 4 ▶ my $fields = $p->{fields} || join(',', sort keys %{ $p->{properties} });
Condition33%1/3
$$p{'fields'} || join(',', sort(keys %{$$p{'properties'};}))
l!l&&r!l&&!r
040
MC/DC0%0/2
$$p{'fields'} || join(',', sort(keys %{$$p{'properties'};}))
$$p{'fields'} join(',', sort(keys %{$$p{'properties'};}))
Truth table33%1/3
A || B
A= $$p{'fields'}B= join(',', sort(keys %{$$p{'properties'};}))
ABresult
1X1
011
000
145  
146 $self->batch_requests(
147 updateDimensionProperties => {
148 range => {
149 sheetId => $self->worksheet_id(),
150 dimension => $dim,
151 startIndex => $p->{start},
152 endIndex => $end,
153 },
154 properties => $p->{properties},
155 4 fields => $fields,
156 },
157 );
158  
159 4 return $self;
160 }
161  
162 1 ▶sub row_height {
Subroutine row_height: called CC=1 SCAR=0.0
Pod undocumented
163 1 my $self = shift;
164 1 my ($start, $end, $height) = @_;
165 1 $self->update_dimension_properties(
166 dimension => 'row',
167 start => $start,
168 end => $end,
169 properties => { pixelSize => $height },
170 );
171 }
172  
173 1 ▶sub col_width {
Subroutine col_width: called CC=1 SCAR=0.0
Pod undocumented
174 1 my $self = shift;
175 1 my ($start, $end, $width) = @_;
176 1 $self->update_dimension_properties(
177 dimension => 'col',
178 start => $start,
179 end => $end,
180 properties => { pixelSize => $width },
181 );
182 }
183  
184 1 ▶sub hide_rows {
Subroutine hide_rows: called CC=1 SCAR=0.0
Pod undocumented
185 1 my $self = shift;
186 1 my ($start, $end) = @_;
187 1 $self->update_dimension_properties(
188 dimension => 'row',
189 start => $start,
190 end => $end,
191 properties => { hiddenByUser => bool(1) },
192 );
193 }
194  
195 0 ▶sub hide_cols {
Subroutine hide_cols: not called CC=1 SCAR=6.9
Pod undocumented
196 0 my $self = shift;
197 0 my ($start, $end) = @_;
198 0 $self->update_dimension_properties(
199 dimension => 'col',
200 start => $start,
201 end => $end,
202 properties => { hiddenByUser => bool(1) },
203 );
204 }
205  
206 0 ▶sub show_rows {
Subroutine show_rows: not called CC=1 SCAR=6.9
Pod undocumented
207 0 my $self = shift;
208 0 my ($start, $end) = @_;
209 0 $self->update_dimension_properties(
210 dimension => 'row',
211 start => $start,
212 end => $end,
213 properties => { hiddenByUser => bool(0) },
214 );
215 }
216  
217 1 ▶sub show_cols {
Subroutine show_cols: called CC=1 SCAR=0.0
Pod undocumented
218 1 my $self = shift;
219 1 my ($start, $end) = @_;
220 1 $self->update_dimension_properties(
221 dimension => 'col',
222 start => $start,
223 end => $end,
224 properties => { hiddenByUser => bool(0) },
225 );
226 }
227  
228 2 ▶sub append_dimension {
Subroutine append_dimension: called CC=2 SCAR=6.9
Pod undocumented
229 2 my $self = shift;
230  
231 2 state $check = signature(
232 bless => !!0,
233 named => [
234 dimension => Str,
235 length => Int,
236 ],
237 );
238 2 my $p = $check->(@_);
239  
240 2 ▶ my $dim = uc($p->{dimension}) eq 'COL' ? 'COLUMNS' : 'ROWS';
Branch: 1 branch
BranchTrueFalseTotal
uc $$p{'dimension'} eq 'COL' ? : 1 1 2
241  
242 $self->batch_requests(
243 appendDimension => {
244 sheetId => $self->worksheet_id(),
245 dimension => $dim,
246 length => $p->{length},
247 },
248 2 );
249  
250 2 return $self;
251 }
252  
253 1 ▶sub append_rows { shift->append_dimension(dimension => 'row', length => shift); }
Subroutine append_rows: called CC=1 SCAR=0.0
Pod undocumented
254 1 ▶sub append_cols { shift->append_dimension(dimension => 'col', length => shift); }
Subroutine append_cols: called CC=1 SCAR=0.0
Pod undocumented
255  
256 2 ▶sub auto_resize_dimensions {
Subroutine auto_resize_dimensions: called CC=3 SCAR=11.0
Pod undocumented
257 2 my $self = shift;
258  
259 2 state $check = signature(
260 bless => !!0,
261 named => [
262 dimension => Str,
263 start => Int,
264 end => Optional[Int],
265 ],
266 );
267 2 my $p = $check->(@_);
268  
269 2 ▶ my $dim = uc($p->{dimension}) eq 'COL' ? 'COLUMNS' : 'ROWS';
Branch: 1 branch
BranchTrueFalseTotal
uc $$p{'dimension'} eq 'COL' ? : 1 1 2
270 2 ▶ my $end = $p->{end} // ($p->{start} + 1);
Condition50%1/2
$$p{"end"} // $$p{"start"} + 1
l!l
20
MC/DC0%0/1
$$p{"end"} // $$p{"start"} + 1
$$p{"end"}
Truth table50%1/2
A
A= $$p{"end"}
Aresult
11
00
271  
272 $self->batch_requests(
273 autoResizeDimensions => {
274 dimensions => {
275 sheetId => $self->worksheet_id(),
276 dimension => $dim,
277 startIndex => $p->{start},
278 2 endIndex => $end,
279 },
280 },
281 );
282  
283 2 return $self;
284 }
285  
286 1 ▶sub auto_resize_rows {
Subroutine auto_resize_rows: called CC=1 SCAR=0.0
Pod undocumented
287 1 my $self = shift;
288 1 my ($start, $end) = @_;
289 1 $self->auto_resize_dimensions(dimension => 'row', start => $start, end => $end);
290 }
291  
292 1 ▶sub auto_resize_cols {
Subroutine auto_resize_cols: called CC=1 SCAR=0.0
Pod undocumented
293 1 my $self = shift;
294 1 my ($start, $end) = @_;
295 1 $self->auto_resize_dimensions(dimension => 'col', start => $start, end => $end);
296 }
297  
298 1 ▶sub set_basic_filter {
Subroutine set_basic_filter: called CC=4 SCAR=14.2
Pod undocumented
299 1 my $self = shift;
300  
301 1 state $check = signature(
302 bless => !!0,
303 named => [
304 range => Optional[HashRef],
305 criteria => Optional[HashRef],
306 sort_specs => Optional[ArrayRef],
307 ],
308 );
309 1 my $p = $check->(@_);
310  
311 1 ▶ my $range = $p->{range} || { sheetId => $self->worksheet_id() };
Condition50%1/2
$$p{'range'} || {'sheetId', $self->worksheet_id}
l!l
01
MC/DC0%0/1
$$p{'range'} || {'sheetId', $self->worksheet_id}
$$p{'range'}
Truth table50%1/2
A
A= $$p{'range'}
Aresult
11
00
312 1 my %filter = (range => $range);
313 1 ▶ $filter{criteria} = $p->{criteria} if $p->{criteria};
Branch: 1 branch
BranchTrueFalseTotal
if $$p{"criteria"} 0 1 1
314 1 ▶ $filter{sortSpecs} = $p->{sort_specs} if $p->{sort_specs};
Branch: 1 branch
BranchTrueFalseTotal
if $$p{"sort_specs"} 0 1 1
315  
316 1 $self->batch_requests(
317 setBasicFilter => {
318 filter => \%filter,
319 },
320 );
321  
322 1 return $self;
323 }
324  
325 1 ▶sub clear_basic_filter {
Subroutine clear_basic_filter: called CC=1 SCAR=0.0
Pod undocumented
326 1 my $self = shift;
327  
328 1 $self->batch_requests(
329 clearBasicFilter => {
330 sheetId => $self->worksheet_id(),
331 },
332 );
333  
334 1 return $self;
335 }
336  
337 1 ▶sub add_conditional_format_rule {
Subroutine add_conditional_format_rule: called CC=1 SCAR=0.0
Pod undocumented
338 1 my $self = shift;
339  
340 1 state $check = signature(
341 bless => !!0,
342 named => [
343 ranges => ArrayRef,
344 rule => HashRef,
345 index => Int, { default => 0 },
346 ],
347 );
348 1 my $p = $check->(@_);
349  
350 $self->batch_requests(
351 addConditionalFormatRule => {
352 rule => {
353 ranges => $p->{ranges},
354 1 %{ $p->{rule} },
355 },
356 index => $p->{index},
357 },
358 1 );
359  
360 1 return $self;
361 }
362  
363 0 ▶sub update_conditional_format_rule {
Subroutine update_conditional_format_rule: not called CC=3 SCAR=24.8
Pod undocumented
364 0 my $self = shift;
365  
366 0 state $check = signature(
367 bless => !!0,
368 named => [
369 index => Int,
370 rule => Optional[HashRef],
371 new_index => Optional[Int],
372 ],
373 );
374 0 my $p = $check->(@_);
375  
376 0 my %request = (index => $p->{index});
377 0 ▶ $request{rule} = $p->{rule} if $p->{rule};
Branch: 1 branch
BranchTrueFalseTotal
if $$p{"rule"} 0 0 0
378 0 ▶ $request{newIndex} = $p->{new_index} if defined $p->{new_index};
Branch: 1 branch
BranchTrueFalseTotal
if defined $$p{"new_index"} 0 0 0
379  
380 0 $self->batch_requests(updateConditionalFormatRule => \%request);
381  
382 0 return $self;
383 }
384  
385 1 ▶sub delete_conditional_format_rule {
Subroutine delete_conditional_format_rule: called CC=1 SCAR=0.0
Pod undocumented
386 1 my $self = shift;
387  
388 1 state $check = signature(positional => [Int]);
389 1 my ($index) = $check->(@_);
390  
391 1 $self->batch_requests(
392 deleteConditionalFormatRule => {
393 sheetId => $self->worksheet_id(),
394 index => $index,
395 },
396 );
397  
398 1 return $self;
399 }
400  
401 1 ▶sub add_banding {
Subroutine add_banding: called CC=3 SCAR=11.1
Pod undocumented
402 1 my $self = shift;
403  
404 1 state $check = signature(
405 bless => !!0,
406 named => [
407 range => HashRef,
408 row_properties => Optional[HashRef],
409 column_properties => Optional[HashRef],
410 ],
411 );
412 1 my $p = $check->(@_);
413  
414 1 my %banded_range = (range => $p->{range});
415 1 ▶ $banded_range{rowProperties} = $p->{row_properties} if $p->{row_properties};
Branch: 1 branch
BranchTrueFalseTotal
if $$p{"row_properties"} 1 0 1
416 1 ▶ $banded_range{columnProperties} = $p->{column_properties} if $p->{column_properties};
Branch: 1 branch
BranchTrueFalseTotal
if $$p{"column_properties"} 0 1 1
417  
418 1 $self->batch_requests(
419 addBanding => {
420 bandedRange => \%banded_range,
421 },
422 );
423  
424 1 return $self;
425 }
426  
427 0 ▶sub update_banding {
Subroutine update_banding: not called CC=8 SCAR=42.8
Pod undocumented
428 0 my $self = shift;
429  
430 0 state $check = signature(
431 bless => !!0,
432 named => [
433 id => Str,
434 range => Optional[HashRef],
435 row_properties => Optional[HashRef],
436 column_properties => Optional[HashRef],
437 fields => Str, { optional => 1 },
438 ],
439 );
440 0 my $p = $check->(@_);
441  
442 0 my %banded_range = (bandedRangeId => $p->{id});
443 0 ▶ $banded_range{range} = $p->{range} if $p->{range};
Branch: 1 branch
BranchTrueFalseTotal
if $$p{"range"} 0 0 0
444 0 ▶ $banded_range{rowProperties} = $p->{row_properties} if $p->{row_properties};
Branch: 1 branch
BranchTrueFalseTotal
if $$p{"row_properties"} 0 0 0
445 0 ▶ $banded_range{columnProperties} = $p->{column_properties} if $p->{column_properties};
Branch: 1 branch
BranchTrueFalseTotal
if $$p{"column_properties"} 0 0 0
446  
447 0 my @field_list;
448 0 ▶ push @field_list, 'range' if $p->{range};
Branch: 1 branch
BranchTrueFalseTotal
if $$p{"range"} 0 0 0
449 0 ▶ push @field_list, 'rowProperties' if $p->{row_properties};
Branch: 1 branch
BranchTrueFalseTotal
if $$p{"row_properties"} 0 0 0
450 0 ▶ push @field_list, 'columnProperties' if $p->{column_properties};
Branch: 1 branch
BranchTrueFalseTotal
if $$p{"column_properties"} 0 0 0
451 0 ▶ my $fields = $p->{fields} || join(',', @field_list);
Condition0%0/3
$$p{'fields'} || join(',', @field_list)
l!l&&r!l&&!r
000
MC/DC0%0/2
$$p{'fields'} || join(',', @field_list)
$$p{'fields'} join(',', @field_list)
Truth table0%0/3
A || B
A= $$p{'fields'}B= join(',', @field_list)
ABresult
1X1
011
000
452  
453 0 $self->batch_requests(
454 updateBanding => {
455 bandedRange => \%banded_range,
456 fields => $fields,
457 },
458 );
459  
460 0 return $self;
461 }
462  
463 1 ▶sub delete_banding {
Subroutine delete_banding: called CC=1 SCAR=0.0
Pod undocumented
464 1 my $self = shift;
465  
466 1 state $check = signature(positional => [Str]);
467 1 my ($id) = $check->(@_);
468  
469 1 $self->batch_requests(
470 deleteBanding => {
471 bandedRangeId => $id,
472 },
473 );
474  
475 1 return $self;
476 }
477  
478 2 ▶sub add_dimension_group {
Subroutine add_dimension_group: called CC=2 SCAR=6.9
Pod undocumented
479 2 my $self = shift;
480  
481 2 state $check = signature(
482 bless => !!0,
483 named => [
484 dimension => Str,
485 start => Int,
486 end => Int,
487 ],
488 );
489 2 my $p = $check->(@_);
490  
491 2 ▶ my $dim = uc($p->{dimension}) eq 'COL' ? 'COLUMNS' : 'ROWS';
Branch: 1 branch
BranchTrueFalseTotal
uc $$p{'dimension'} eq 'COL' ? : 1 1 2
492  
493 $self->batch_requests(
494 addDimensionGroup => {
495 range => {
496 sheetId => $self->worksheet_id(),
497 dimension => $dim,
498 startIndex => $p->{start},
499 endIndex => $p->{end},
500 },
501 },
502 2 );
503  
504 2 return $self;
505 }
506  
507 1 ▶sub delete_dimension_group {
Subroutine delete_dimension_group: called CC=2 SCAR=7.0
Pod undocumented
508 1 my $self = shift;
509  
510 1 state $check = signature(
511 bless => !!0,
512 named => [
513 dimension => Str,
514 start => Int,
515 end => Int,
516 ],
517 );
518 1 my $p = $check->(@_);
519  
520 1 ▶ my $dim = uc($p->{dimension}) eq 'COL' ? 'COLUMNS' : 'ROWS';
Branch: 1 branch
BranchTrueFalseTotal
uc $$p{'dimension'} eq 'COL' ? : 0 1 1
521  
522 $self->batch_requests(
523 deleteDimensionGroup => {
524 range => {
525 sheetId => $self->worksheet_id(),
526 dimension => $dim,
527 startIndex => $p->{start},
528 endIndex => $p->{end},
529 },
530 },
531 1 );
532  
533 1 return $self;
534 }
535  
536 0 ▶sub update_dimension_group {
Subroutine update_dimension_group: not called CC=2 SCAR=17.9
Pod undocumented
537 0 my $self = shift;
538  
539 0 state $check = signature(
540 bless => !!0,
541 named => [
542 dimension => Str,
543 start => Int,
544 end => Int,
545 depth => Int,
546 collapsed => Bool,
547 ],
548 );
549 0 my $p = $check->(@_);
550  
551 0 ▶ my $dim = uc($p->{dimension}) eq 'COL' ? 'COLUMNS' : 'ROWS';
Branch: 1 branch
BranchTrueFalseTotal
uc $$p{'dimension'} eq 'COL' ? : 0 0 0
552  
553 $self->batch_requests(
554 updateDimensionGroup => {
555 dimensionGroup => {
556 range => {
557 sheetId => $self->worksheet_id(),
558 dimension => $dim,
559 startIndex => $p->{start},
560 endIndex => $p->{end},
561 },
562 depth => $p->{depth},
563 0 collapsed => bool($p->{collapsed}),
564 },
565 fields => 'collapsed',
566 },
567 );
568  
569 0 return $self;
570 }
571  
572 1 ▶sub group_rows {
Subroutine group_rows: called CC=1 SCAR=0.0
Pod undocumented
573 1 my $self = shift;
574 1 my ($start, $end) = @_;
575 1 $self->add_dimension_group(dimension => 'row', start => $start, end => $end);
576 }
577  
578 1 ▶sub group_cols {
Subroutine group_cols: called CC=1 SCAR=0.0
Pod undocumented
579 1 my $self = shift;
580 1 my ($start, $end) = @_;
581 1 $self->add_dimension_group(dimension => 'col', start => $start, end => $end);
582 }
583  
584 1 ▶sub ungroup_rows {
Subroutine ungroup_rows: called CC=1 SCAR=0.0
Pod undocumented
585 1 my $self = shift;
586 1 my ($start, $end) = @_;
587 1 $self->delete_dimension_group(dimension => 'row', start => $start, end => $end);
588 }
589  
590 0 ▶sub ungroup_cols {
Subroutine ungroup_cols: not called CC=1 SCAR=6.9
Pod undocumented
591 0 my $self = shift;
592 0 my ($start, $end) = @_;
593 0 $self->delete_dimension_group(dimension => 'col', start => $start, end => $end);
594 }
595  
596 2 1;
597  
598 __END__
« RestApi/DriveApi3/File.pm ↑ Summary RestApi/SheetsApi4/Range.pm »