Lines Matching refs:currentsheet
81 XSpreadsheet currentsheet = SCUtil.getCurrentSheet(scDocument); in testForSecondGroup() local
83 XCellRange.class, currentsheet); in testForSecondGroup()
84 XCellRange sourceRange = currentsheet.getCellRangeByName("A1:E8"); in testForSecondGroup()
116 assertEquals("10 Sum", SCUtil.getTextFromCell(currentsheet, 1, 2)); in testForSecondGroup()
119 SCUtil.getFormulaFromCell(currentsheet, 2, 2)); in testForSecondGroup()
121 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 2, 2), in testForSecondGroup()
125 assertEquals("20 Sum", SCUtil.getTextFromCell(currentsheet, 1, 4)); in testForSecondGroup()
128 SCUtil.getFormulaFromCell(currentsheet, 2, 4)); in testForSecondGroup()
130 assertEquals(2, SCUtil.getValueFromCell(currentsheet, 2, 4), in testForSecondGroup()
134 assertEquals("30 Sum", SCUtil.getTextFromCell(currentsheet, 1, 6)); in testForSecondGroup()
137 SCUtil.getFormulaFromCell(currentsheet, 2, 6)); in testForSecondGroup()
139 assertEquals(5, SCUtil.getValueFromCell(currentsheet, 2, 6), in testForSecondGroup()
143 assertEquals("A Sum", SCUtil.getTextFromCell(currentsheet, 3, 7)); in testForSecondGroup()
146 SCUtil.getFormulaFromCell(currentsheet, 1, 7)); in testForSecondGroup()
148 assertEquals(60, SCUtil.getValueFromCell(currentsheet, 1, 7), in testForSecondGroup()
152 assertEquals("10 Sum", SCUtil.getTextFromCell(currentsheet, 1, 9)); in testForSecondGroup()
155 SCUtil.getFormulaFromCell(currentsheet, 2, 9)); in testForSecondGroup()
157 assertEquals(3, SCUtil.getValueFromCell(currentsheet, 2, 9), in testForSecondGroup()
161 assertEquals("20 Sum", SCUtil.getTextFromCell(currentsheet, 1, 11)); in testForSecondGroup()
164 SCUtil.getFormulaFromCell(currentsheet, 2, 11)); in testForSecondGroup()
166 assertEquals(4, SCUtil.getValueFromCell(currentsheet, 2, 11), in testForSecondGroup()
170 assertEquals("B Sum", SCUtil.getTextFromCell(currentsheet, 3, 12)); in testForSecondGroup()
173 SCUtil.getFormulaFromCell(currentsheet, 1, 12)); in testForSecondGroup()
175 assertEquals(30, SCUtil.getValueFromCell(currentsheet, 1, 12), in testForSecondGroup()
179 assertEquals("20 Sum", SCUtil.getTextFromCell(currentsheet, 1, 14)); in testForSecondGroup()
182 SCUtil.getFormulaFromCell(currentsheet, 2, 14)); in testForSecondGroup()
184 assertEquals(6, SCUtil.getValueFromCell(currentsheet, 2, 14), in testForSecondGroup()
188 assertEquals("30 Sum", SCUtil.getTextFromCell(currentsheet, 1, 16)); in testForSecondGroup()
191 SCUtil.getFormulaFromCell(currentsheet, 2, 16)); in testForSecondGroup()
193 assertEquals(7, SCUtil.getValueFromCell(currentsheet, 2, 16), in testForSecondGroup()
197 assertEquals("C Sum", SCUtil.getTextFromCell(currentsheet, 3, 17)); in testForSecondGroup()
200 SCUtil.getFormulaFromCell(currentsheet, 1, 17)); in testForSecondGroup()
202 assertEquals(50, SCUtil.getValueFromCell(currentsheet, 1, 17), in testForSecondGroup()
206 assertEquals("Grand Total", SCUtil.getTextFromCell(currentsheet, 3, 18)); in testForSecondGroup()
209 SCUtil.getFormulaFromCell(currentsheet, 1, 18)); in testForSecondGroup()
211 assertEquals(140, SCUtil.getValueFromCell(currentsheet, 1, 18), in testForSecondGroup()
219 currentsheet = SCUtil.getCurrentSheet(scDocument); in testForSecondGroup()
223 assertEquals("10 Sum", SCUtil.getTextFromCell(currentsheet, 1, 2)); in testForSecondGroup()
226 SCUtil.getFormulaFromCell(currentsheet, 2, 2)); in testForSecondGroup()
228 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 2, 2), in testForSecondGroup()
232 assertEquals("20 Sum", SCUtil.getTextFromCell(currentsheet, 1, 4)); in testForSecondGroup()
235 SCUtil.getFormulaFromCell(currentsheet, 2, 4)); in testForSecondGroup()
237 assertEquals(2, SCUtil.getValueFromCell(currentsheet, 2, 4), in testForSecondGroup()
241 assertEquals("30 Sum", SCUtil.getTextFromCell(currentsheet, 1, 6)); in testForSecondGroup()
244 SCUtil.getFormulaFromCell(currentsheet, 2, 6)); in testForSecondGroup()
246 assertEquals(5, SCUtil.getValueFromCell(currentsheet, 2, 6), in testForSecondGroup()
250 assertEquals("A Sum", SCUtil.getTextFromCell(currentsheet, 3, 7)); in testForSecondGroup()
253 SCUtil.getFormulaFromCell(currentsheet, 1, 7)); in testForSecondGroup()
255 assertEquals(60, SCUtil.getValueFromCell(currentsheet, 1, 7), in testForSecondGroup()
259 assertEquals("10 Sum", SCUtil.getTextFromCell(currentsheet, 1, 9)); in testForSecondGroup()
262 SCUtil.getFormulaFromCell(currentsheet, 2, 9)); in testForSecondGroup()
264 assertEquals(3, SCUtil.getValueFromCell(currentsheet, 2, 9), in testForSecondGroup()
268 assertEquals("20 Sum", SCUtil.getTextFromCell(currentsheet, 1, 11)); in testForSecondGroup()
271 SCUtil.getFormulaFromCell(currentsheet, 2, 11)); in testForSecondGroup()
273 assertEquals(4, SCUtil.getValueFromCell(currentsheet, 2, 11), in testForSecondGroup()
277 assertEquals("B Sum", SCUtil.getTextFromCell(currentsheet, 3, 12)); in testForSecondGroup()
280 SCUtil.getFormulaFromCell(currentsheet, 1, 12)); in testForSecondGroup()
282 assertEquals(30, SCUtil.getValueFromCell(currentsheet, 1, 12), in testForSecondGroup()
286 assertEquals("20 Sum", SCUtil.getTextFromCell(currentsheet, 1, 14)); in testForSecondGroup()
289 SCUtil.getFormulaFromCell(currentsheet, 2, 14)); in testForSecondGroup()
291 assertEquals(6, SCUtil.getValueFromCell(currentsheet, 2, 14), in testForSecondGroup()
295 assertEquals("30 Sum", SCUtil.getTextFromCell(currentsheet, 1, 16)); in testForSecondGroup()
298 SCUtil.getFormulaFromCell(currentsheet, 2, 16)); in testForSecondGroup()
300 assertEquals(7, SCUtil.getValueFromCell(currentsheet, 2, 16), in testForSecondGroup()
304 assertEquals("C Sum", SCUtil.getTextFromCell(currentsheet, 3, 17)); in testForSecondGroup()
307 SCUtil.getFormulaFromCell(currentsheet, 1, 17)); in testForSecondGroup()
309 assertEquals(50, SCUtil.getValueFromCell(currentsheet, 1, 17), in testForSecondGroup()
313 assertEquals("Grand Total", SCUtil.getTextFromCell(currentsheet, 3, 18)); in testForSecondGroup()
316 SCUtil.getFormulaFromCell(currentsheet, 1, 18)); in testForSecondGroup()
318 assertEquals(140, SCUtil.getValueFromCell(currentsheet, 1, 18), in testForSecondGroup()
327 XSpreadsheet currentsheet = SCUtil.getCurrentSheet(scDocument); in testForThirdGroup() local
329 XCellRange.class, currentsheet); in testForThirdGroup()
330 XCellRange sourceRange = currentsheet.getCellRangeByName("A1:E8"); in testForThirdGroup()
370 assertEquals("MS Count", SCUtil.getTextFromCell(currentsheet, 0, 2)); in testForThirdGroup()
373 SCUtil.getFormulaFromCell(currentsheet, 4, 2)); in testForThirdGroup()
375 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 4, 2), in testForThirdGroup()
379 assertEquals("10 Sum", SCUtil.getTextFromCell(currentsheet, 1, 3)); in testForThirdGroup()
382 SCUtil.getFormulaFromCell(currentsheet, 2, 3)); in testForThirdGroup()
384 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 2, 3), in testForThirdGroup()
388 assertEquals("BS Count", SCUtil.getTextFromCell(currentsheet, 0, 5)); in testForThirdGroup()
390 SCUtil.getFormulaFromCell(currentsheet, 4, 5)); in testForThirdGroup()
391 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 4, 5), in testForThirdGroup()
395 assertEquals("20 Sum", SCUtil.getTextFromCell(currentsheet, 1, 6)); in testForThirdGroup()
397 SCUtil.getFormulaFromCell(currentsheet, 2, 6)); in testForThirdGroup()
398 assertEquals(2, SCUtil.getValueFromCell(currentsheet, 2, 6), in testForThirdGroup()
402 assertEquals("CS Count", SCUtil.getTextFromCell(currentsheet, 0, 8)); in testForThirdGroup()
404 SCUtil.getFormulaFromCell(currentsheet, 4, 8)); in testForThirdGroup()
405 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 4, 8), in testForThirdGroup()
409 assertEquals("30 Sum", SCUtil.getTextFromCell(currentsheet, 1, 9)); in testForThirdGroup()
411 SCUtil.getFormulaFromCell(currentsheet, 2, 9)); in testForThirdGroup()
412 assertEquals(5, SCUtil.getValueFromCell(currentsheet, 2, 9), in testForThirdGroup()
416 assertEquals("A Sum", SCUtil.getTextFromCell(currentsheet, 3, 10)); in testForThirdGroup()
418 SCUtil.getFormulaFromCell(currentsheet, 1, 10)); in testForThirdGroup()
419 assertEquals(60, SCUtil.getValueFromCell(currentsheet, 1, 10), in testForThirdGroup()
423 assertEquals("MS Count", SCUtil.getTextFromCell(currentsheet, 0, 12)); in testForThirdGroup()
425 SCUtil.getFormulaFromCell(currentsheet, 4, 12)); in testForThirdGroup()
426 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 4, 12), in testForThirdGroup()
430 assertEquals("10 Sum", SCUtil.getTextFromCell(currentsheet, 1, 13)); in testForThirdGroup()
432 SCUtil.getFormulaFromCell(currentsheet, 2, 13)); in testForThirdGroup()
433 assertEquals(3, SCUtil.getValueFromCell(currentsheet, 2, 13), in testForThirdGroup()
437 assertEquals("BS Count", SCUtil.getTextFromCell(currentsheet, 0, 15)); in testForThirdGroup()
439 SCUtil.getFormulaFromCell(currentsheet, 4, 15)); in testForThirdGroup()
440 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 4, 15), in testForThirdGroup()
444 assertEquals("20 Sum", SCUtil.getTextFromCell(currentsheet, 1, 16)); in testForThirdGroup()
447 SCUtil.getFormulaFromCell(currentsheet, 2, 16)); in testForThirdGroup()
449 assertEquals(4, SCUtil.getValueFromCell(currentsheet, 2, 16), in testForThirdGroup()
453 assertEquals("B Sum", SCUtil.getTextFromCell(currentsheet, 3, 17)); in testForThirdGroup()
456 SCUtil.getFormulaFromCell(currentsheet, 1, 17)); in testForThirdGroup()
458 assertEquals(30, SCUtil.getValueFromCell(currentsheet, 1, 17), in testForThirdGroup()
462 assertEquals("BS Count", SCUtil.getTextFromCell(currentsheet, 0, 19)); in testForThirdGroup()
464 SCUtil.getFormulaFromCell(currentsheet, 4, 19)); in testForThirdGroup()
465 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 4, 19), in testForThirdGroup()
469 assertEquals("20 Sum", SCUtil.getTextFromCell(currentsheet, 1, 20)); in testForThirdGroup()
471 SCUtil.getFormulaFromCell(currentsheet, 2, 20)); in testForThirdGroup()
472 assertEquals(6, SCUtil.getValueFromCell(currentsheet, 2, 20), in testForThirdGroup()
476 assertEquals("CS Count", SCUtil.getTextFromCell(currentsheet, 0, 22)); in testForThirdGroup()
478 SCUtil.getFormulaFromCell(currentsheet, 4, 22)); in testForThirdGroup()
479 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 4, 22), in testForThirdGroup()
483 assertEquals("30 Sum", SCUtil.getTextFromCell(currentsheet, 1, 23)); in testForThirdGroup()
486 SCUtil.getFormulaFromCell(currentsheet, 2, 23)); in testForThirdGroup()
487 assertEquals(7, SCUtil.getValueFromCell(currentsheet, 2, 23), in testForThirdGroup()
491 assertEquals("C Sum", SCUtil.getTextFromCell(currentsheet, 3, 24)); in testForThirdGroup()
494 SCUtil.getFormulaFromCell(currentsheet, 1, 24)); in testForThirdGroup()
495 assertEquals(50, SCUtil.getValueFromCell(currentsheet, 1, 24), in testForThirdGroup()
499 assertEquals("Grand Total", SCUtil.getTextFromCell(currentsheet, 3, 25)); in testForThirdGroup()
501 SCUtil.getFormulaFromCell(currentsheet, 1, 25)); in testForThirdGroup()
502 assertEquals(140, SCUtil.getValueFromCell(currentsheet, 1, 25), in testForThirdGroup()
510 currentsheet = SCUtil.getCurrentSheet(scDocument); in testForThirdGroup()
514 assertEquals("MS Count", SCUtil.getTextFromCell(currentsheet, 0, 2)); in testForThirdGroup()
517 SCUtil.getFormulaFromCell(currentsheet, 4, 2)); in testForThirdGroup()
519 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 4, 2), in testForThirdGroup()
523 assertEquals("10 Sum", SCUtil.getTextFromCell(currentsheet, 1, 3)); in testForThirdGroup()
526 SCUtil.getFormulaFromCell(currentsheet, 2, 3)); in testForThirdGroup()
528 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 2, 3), in testForThirdGroup()
532 assertEquals("BS Count", SCUtil.getTextFromCell(currentsheet, 0, 5)); in testForThirdGroup()
534 SCUtil.getFormulaFromCell(currentsheet, 4, 5)); in testForThirdGroup()
535 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 4, 5), in testForThirdGroup()
539 assertEquals("20 Sum", SCUtil.getTextFromCell(currentsheet, 1, 6)); in testForThirdGroup()
541 SCUtil.getFormulaFromCell(currentsheet, 2, 6)); in testForThirdGroup()
542 assertEquals(2, SCUtil.getValueFromCell(currentsheet, 2, 6), in testForThirdGroup()
546 assertEquals("CS Count", SCUtil.getTextFromCell(currentsheet, 0, 8)); in testForThirdGroup()
548 SCUtil.getFormulaFromCell(currentsheet, 4, 8)); in testForThirdGroup()
549 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 4, 8), in testForThirdGroup()
553 assertEquals("30 Sum", SCUtil.getTextFromCell(currentsheet, 1, 9)); in testForThirdGroup()
555 SCUtil.getFormulaFromCell(currentsheet, 2, 9)); in testForThirdGroup()
556 assertEquals(5, SCUtil.getValueFromCell(currentsheet, 2, 9), in testForThirdGroup()
560 assertEquals("A Sum", SCUtil.getTextFromCell(currentsheet, 3, 10)); in testForThirdGroup()
562 SCUtil.getFormulaFromCell(currentsheet, 1, 10)); in testForThirdGroup()
563 assertEquals(60, SCUtil.getValueFromCell(currentsheet, 1, 10), in testForThirdGroup()
567 assertEquals("MS Count", SCUtil.getTextFromCell(currentsheet, 0, 12)); in testForThirdGroup()
569 SCUtil.getFormulaFromCell(currentsheet, 4, 12)); in testForThirdGroup()
570 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 4, 12), in testForThirdGroup()
574 assertEquals("10 Sum", SCUtil.getTextFromCell(currentsheet, 1, 13)); in testForThirdGroup()
576 SCUtil.getFormulaFromCell(currentsheet, 2, 13)); in testForThirdGroup()
577 assertEquals(3, SCUtil.getValueFromCell(currentsheet, 2, 13), in testForThirdGroup()
581 assertEquals("BS Count", SCUtil.getTextFromCell(currentsheet, 0, 15)); in testForThirdGroup()
583 SCUtil.getFormulaFromCell(currentsheet, 4, 15)); in testForThirdGroup()
584 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 4, 15), in testForThirdGroup()
588 assertEquals("20 Sum", SCUtil.getTextFromCell(currentsheet, 1, 16)); in testForThirdGroup()
591 SCUtil.getFormulaFromCell(currentsheet, 2, 16)); in testForThirdGroup()
593 assertEquals(4, SCUtil.getValueFromCell(currentsheet, 2, 16), in testForThirdGroup()
597 assertEquals("B Sum", SCUtil.getTextFromCell(currentsheet, 3, 17)); in testForThirdGroup()
600 SCUtil.getFormulaFromCell(currentsheet, 1, 17)); in testForThirdGroup()
602 assertEquals(30, SCUtil.getValueFromCell(currentsheet, 1, 17), in testForThirdGroup()
606 assertEquals("BS Count", SCUtil.getTextFromCell(currentsheet, 0, 19)); in testForThirdGroup()
608 SCUtil.getFormulaFromCell(currentsheet, 4, 19)); in testForThirdGroup()
609 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 4, 19), in testForThirdGroup()
613 assertEquals("20 Sum", SCUtil.getTextFromCell(currentsheet, 1, 20)); in testForThirdGroup()
615 SCUtil.getFormulaFromCell(currentsheet, 2, 20)); in testForThirdGroup()
616 assertEquals(6, SCUtil.getValueFromCell(currentsheet, 2, 20), in testForThirdGroup()
620 assertEquals("CS Count", SCUtil.getTextFromCell(currentsheet, 0, 22)); in testForThirdGroup()
622 SCUtil.getFormulaFromCell(currentsheet, 4, 22)); in testForThirdGroup()
623 assertEquals(1, SCUtil.getValueFromCell(currentsheet, 4, 22), in testForThirdGroup()
627 assertEquals("30 Sum", SCUtil.getTextFromCell(currentsheet, 1, 23)); in testForThirdGroup()
630 SCUtil.getFormulaFromCell(currentsheet, 2, 23)); in testForThirdGroup()
631 assertEquals(7, SCUtil.getValueFromCell(currentsheet, 2, 23), in testForThirdGroup()
635 assertEquals("C Sum", SCUtil.getTextFromCell(currentsheet, 3, 24)); in testForThirdGroup()
638 SCUtil.getFormulaFromCell(currentsheet, 1, 24)); in testForThirdGroup()
639 assertEquals(50, SCUtil.getValueFromCell(currentsheet, 1, 24), in testForThirdGroup()
643 assertEquals("Grand Total", SCUtil.getTextFromCell(currentsheet, 3, 25)); in testForThirdGroup()
645 SCUtil.getFormulaFromCell(currentsheet, 1, 25)); in testForThirdGroup()
646 assertEquals(140, SCUtil.getValueFromCell(currentsheet, 1, 25), in testForThirdGroup()