1 AT_BANNER([pivot table rendering])
3 AT_SETUP([1-d pivot table])
4 AT_DATA([pivot.txt], [[
5 /col "a"*("a1", "a2", "a3")
7 /title "Columns" /display
8 /title "Rows" /transpose.
10 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [dnl
31 AT_SETUP([2-d pivot table])
32 AT_DATA([pivot.txt], [[
33 /col "a"("a1", "a2", "a3")
34 /col "b"("b1", "b2", "b3")
36 /title "Columns" /display
37 /title "Rows" /transpose /display
38 /title "Column x Row" /move "a" column /display
39 /title "Row x Column" /transpose
41 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [dnl
43 ╭────────┬────────┬────────╮
45 ├──┬──┬──┼──┬──┬──┼──┬──┬──┤
46 │a1│a2│a3│a1│a2│a3│a1│a2│a3│
47 ├──┼──┼──┼──┼──┼──┼──┼──┼──┤
48 │ 0│ 1│ 2│ 3│ 4│ 5│ 6│ 7│ 8│
49 ╰──┴──┴──┴──┴──┴──┴──┴──┴──╯
86 AT_SETUP([2-d pivot table - dimension labels])
87 AT_DATA([pivot.txt], [[
88 /col "a"*("a1", "a2", "a3")
89 /col "b"*("b1", "b2", "b3")
91 /title "Columns" /display
92 /title "Rows - Corner" /transpose /display
93 /title "Rows - Nested" /look rowlabels=nested /display
94 /title "Column x Row - Corner" /move "a" column /look rowlabels=corner /display
95 /title "Column x Row - Nested" /look rowlabels=nested /display
96 /title "Row x Column - Corner" /transpose /look rowlabels=corner /display
97 /title "Row x Column - Nested" /look rowlabels=nested
99 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [dnl
101 ╭──────────────────────────╮
103 ├────────┬────────┬────────┤
105 ├────────┼────────┼────────┤
107 ├──┬──┬──┼──┬──┬──┼──┬──┬──┤
108 │a1│a2│a3│a1│a2│a3│a1│a2│a3│
109 ├──┼──┼──┼──┼──┼──┼──┼──┼──┤
110 │ 0│ 1│ 2│ 3│ 4│ 5│ 6│ 7│ 8│
111 ╰──┴──┴──┴──┴──┴──┴──┴──┴──╯
145 Column x Row - Corner
156 Column x Row - Nested
167 Row x Column - Corner
178 Row x Column - Nested
191 AT_SETUP([2-d pivot table - groups])
192 AT_DATA([pivot.txt], [[
193 /col "a"("a1", "ag1"("a2", "a3"))
194 /col "b"("bg1"("b1", "b2"), "b3")
196 /title "Columns" /display
197 /title "Rows" /transpose /display
198 /title "Column x Row" /move "a" column /display
199 /title "Row x Column" /transpose /display
200 /title "Row x Column - delete b2" /cells[all,1]=delete /display
201 /title "Row x Column - delete b2 - show empty" /look empty=show /display
202 /title "Row x Column - delete b1" /cells[all,0]=delete /look empty=hide /display
203 /title "Row x Column - delete b1 - show empty" /look empty=show.
205 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [dnl
207 ╭─────────────────┬────────╮
209 ├────────┬────────┤ │
211 ├──┬─────┼──┬─────┼──┬─────┤
212 │ │ ag1 │ │ ag1 │ │ ag1 │
213 │ ├──┬──┤ ├──┬──┤ ├──┬──┤
214 │a1│a2│a3│a1│a2│a3│a1│a2│a3│
215 ├──┼──┼──┼──┼──┼──┼──┼──┼──┤
216 │ 0│ 1│ 2│ 3│ 4│ 5│ 6│ 7│ 8│
217 ╰──┴──┴──┴──┴──┴──┴──┴──┴──╯
261 Row x Column - delete b2
273 Row x Column - delete b2 - show empty
285 Row x Column - delete b1
295 Row x Column - delete b1 - show empty
309 AT_SETUP([2-d pivot table - layers])
310 AT_DATA([pivot.txt], [[
311 /col "a"("a1", "a2", "a3")
312 /layer "b"("b1", "b2", "b3")
314 /title "Column x b1" /display
315 /title "Row x b1" /transpose /display
316 /title "Column x b2" /show layer 1 /transpose /display
317 /title "Row x b2" /transpose /display
318 /title "Column (All Layers)" /look layers=all /display
319 /title "Row (All Layers)" /transpose /look layers=all
321 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [dnl
404 AT_SETUP([3-d pivot table - layers])
405 AT_DATA([pivot.txt], [[
406 /layer "a"("a1", "a2", "a3")
407 /layer "b"("b1", "b2", "b3", "b4")
408 /col "c"("c1", "c2", "c3", "c4", "c5")
410 /title "Column x b1 x a1" /display
411 /title "Column x b2 x a1" /show layer 0 1 /display
412 /title "Column x b3 x a2" /show layer 1 2 /display
414 AT_DATA([expout], [dnl
442 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [expout])
445 AT_SETUP([pivot table title and caption])
446 AT_DATA([pivot.txt], [[
450 /title "Title + Caption" /caption "Title + Caption" /display
451 /title "Title Only" /caption "(Not Shown)" /show title=yes caption=no /display
452 /title "(Not Shown)" /caption "Caption Only" /show title=no caption=yes /display
453 /title "(Not Shown)" /caption "(Not Shown)" /show title=no caption=no
455 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [dnl
490 AT_SETUP([pivot table footnotes])
491 AT_KEYWORDS([footnote])
492 AT_DATA([pivot.txt], [[
493 /footnote[0] "First footnote" marker="*"
494 /footnote[1] "Second footnote"
495 /col "A"[footnote 0]*("B"[footnote 1], "C"[footnote 0 1])
496 /row "D"[footnote 1]*("E"[footnote 0], "F"[footnote 1 0])
497 /look rowlabels=nested
499 /cell[1, 0]=1[footnote 0]
500 /cell[0, 1]=2[footnote 1]
501 /cell[1, 1]=3[footnote 0 1]
502 /caption "Caption"[footnote 0]
503 /corner "Corner"[footnote 0 1]
504 /title "Pivot Table with Alphabetic Subscript Footnotes"[footnote 0]
505 /look marker=alpha level=sub
507 /title "Pivot Table with Alphabetic Superscript Footnotes"[footnote 0]
508 /look marker=alpha level=super
510 /title "Pivot Table with Numeric Subscript Footnotes"[footnote 0]
511 /look marker=numeric level=sub
513 /title "Pivot Table with Numeric Superscript Footnotes"[footnote 0]
514 /look marker=numeric level=super
516 /title "Hidden Footnote"[footnote 0]
517 /footnote[0] "First footnote" marker="*" hide
519 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0],
520 [[Pivot Table with Alphabetic Subscript Footnotes[*]
521 ╭────────────┬──────────────────╮
523 │ ├───────┬──────────┤
524 │Corner[*][b]│ B[b] │ C[*][b] │
525 ├────────────┼───────┼──────────┤
526 │D[b] E[*] │ .00│ 1.00[*]│
527 │ F[*][b]│2.00[b]│3.00[*][b]│
528 ╰────────────┴───────┴──────────╯
533 Pivot Table with Alphabetic Superscript Footnotes[*]
534 ╭────────────┬──────────────────╮
536 │ ├───────┬──────────┤
537 │Corner[*][b]│ B[b] │ C[*][b] │
538 ├────────────┼───────┼──────────┤
539 │D[b] E[*] │ .00│ 1.00[*]│
540 │ F[*][b]│2.00[b]│3.00[*][b]│
541 ╰────────────┴───────┴──────────╯
546 Pivot Table with Numeric Subscript Footnotes[*]
547 ╭────────────┬──────────────────╮
549 │ ├───────┬──────────┤
550 │Corner[*][2]│ B[2] │ C[*][2] │
551 ├────────────┼───────┼──────────┤
552 │D[2] E[*] │ .00│ 1.00[*]│
553 │ F[*][2]│2.00[2]│3.00[*][2]│
554 ╰────────────┴───────┴──────────╯
559 Pivot Table with Numeric Superscript Footnotes[*]
560 ╭────────────┬──────────────────╮
562 │ ├───────┬──────────┤
563 │Corner[*][2]│ B[2] │ C[*][2] │
564 ├────────────┼───────┼──────────┤
565 │D[2] E[*] │ .00│ 1.00[*]│
566 │ F[*][2]│2.00[2]│3.00[*][2]│
567 ╰────────────┴───────┴──────────╯
573 ╭────────────┬──────────────────╮
575 │ ├───────┬──────────┤
576 │Corner[*][2]│ B[2] │ C[*][2] │
577 ├────────────┼───────┼──────────┤
578 │D[2] E[*] │ .00│ 1.00[*]│
579 │ F[*][2]│2.00[2]│3.00[*][2]│
580 ╰────────────┴───────┴──────────╯
586 AT_SETUP([pivot table with no dimensions])
587 AT_DATA([pivot.txt], [[
588 /title "No Dimensions"
590 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [dnl
597 AT_SETUP([pivot table with empty dimensions])
598 AT_DATA([pivot.txt], [[
601 /title "One Empty Dimension" /display
602 /title "Two Empty Dimensions" /row "b"*() /display
603 /title "Three Dimensions, Two Empty" /row "c"("c1", "c2")
605 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [dnl
610 Three Dimensions, Two Empty
614 AT_SETUP([pivot table with empty groups])
615 AT_DATA([pivot.txt], [[
616 /col "a"("a1", "a2"(), "a3")
617 /row "b"("b1"(), "b2", "b3")
622 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [dnl
633 AT_SETUP([pivot table - category and dimension borders])
634 AT_DATA([pivot.txt], [[
635 /col "a"("a1", "ag1"("a2", "a3"))
636 /col "b"("bg1"("b1", "b2"), "b3")
637 /row "c"("c1", "cg1"("c2", "c3"))
638 /row "d"("dg1"("d1", "d2"), "d3")
639 /cell[all, all, all, all]
641 /border "dim-row-horz" (solid "blue")
642 "cat-row-horz" (dashed "red")
643 "dim-row-vert" (solid "blue")
644 "cat-row-vert" (dashed "red")
645 "dim-col-horz" (solid "blue")
646 "cat-col-horz" (dashed "red")
647 "dim-col-vert" (solid "blue")
648 "cat-col-vert" (dashed "red")
649 /title "Category and Dimension Borders"
651 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [dnl
652 Category and Dimension Borders
656 ╶──┬─────┼──┬─────┼──┬─────
657 │ ag1 │ │ ag1 │ │ ag1
658 ├╌╌┬╌╌┤ ├╌╌┬╌╌┤ ├╌╌┬╌╌
659 a1│a2┊a3│a1│a2┊a3│a1│a2┊a3
660 dg1┊d1│c1 0│ 1┊ 2│ 3│ 4┊ 5│ 6│ 7┊ 8
661 ┊ ├───┬─────┼──┼──┼──┼──┼──┼──┼──┼──
662 ┊ │cg1┊c2 9│10┊11│12│13┊14│15│16┊17
663 ┊ │ ├╌╌╌╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌
664 ┊ │ ┊c3 18│19┊20│21│22┊23│24│25┊26
665 ├──┼───┴─────┼──┼──┼──┼──┼──┼──┼──┼──
666 ┊d2│c1 27│28┊29│30│31┊32│33│34┊35
667 ┊ ├───┬─────┼──┼──┼──┼──┼──┼──┼──┼──
668 ┊ │cg1┊c2 36│37┊38│39│40┊41│42│43┊44
669 ┊ │ ├╌╌╌╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌
670 ┊ │ ┊c3 45│46┊47│48│49┊50│51│52┊53
671 ───┴──┼───┴─────┼──┼──┼──┼──┼──┼──┼──┼──
672 d3 │c1 54│55┊56│57│58┊59│60│61┊62
673 ├───┬─────┼──┼──┼──┼──┼──┼──┼──┼──
674 │cg1┊c2 63│64┊65│66│67┊68│69│70┊71
675 │ ├╌╌╌╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌
676 │ ┊c3 72│73┊74│75│76┊77│78│79┊80
680 AT_SETUP([pivot table - small numbers])
681 AT_DATA([pivot.txt], [[
682 /title "small numbers"
683 /row "exponent"*("0", "-1", "-2", "-3", "-4", "-5", "-6", "-7", "-8", "-9")
684 /col "sign"*("positive", "negative")
685 /col "result class"*("general" RC_OTHER, "specific" RC_RESIDUAL)
689 /cell[3, 0, 0] = .001
690 /cell[4, 0, 0] = .0001
691 /cell[5, 0, 0] = .00001
692 /cell[6, 0, 0] = .000001
693 /cell[7, 0, 0] = .0000001
694 /cell[8, 0, 0] = .00000001
695 /cell[9, 0, 0] = .000000001
698 /cell[2, 0, 1] = -.01
699 /cell[3, 0, 1] = -.001
700 /cell[4, 0, 1] = -.0001
701 /cell[5, 0, 1] = -.00001
702 /cell[6, 0, 1] = -.000001
703 /cell[7, 0, 1] = -.0000001
704 /cell[8, 0, 1] = -.00000001
705 /cell[9, 0, 1] = -.000000001
709 /cell[3, 1, 0] = .001
710 /cell[4, 1, 0] = .0001
711 /cell[5, 1, 0] = .00001
712 /cell[6, 1, 0] = .000001
713 /cell[7, 1, 0] = .0000001
714 /cell[8, 1, 0] = .00000001
715 /cell[9, 1, 0] = .000000001
718 /cell[2, 1, 1] = -.01
719 /cell[3, 1, 1] = -.001
720 /cell[4, 1, 1] = -.0001
721 /cell[5, 1, 1] = -.00001
722 /cell[6, 1, 1] = -.000001
723 /cell[7, 1, 1] = -.0000001
724 /cell[8, 1, 1] = -.00000001
725 /cell[9, 1, 1] = -.000000001
727 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [dnl
729 ╭────────┬─────────────────────────────────────╮
731 │ ├───────────────────┬─────────────────┤
732 │ │ general │ specific │
733 │ ├───────────────────┼─────────────────┤
735 │ ├─────────┬─────────┼────────┬────────┤
736 │exponent│ positive│ negative│positive│negative│
737 ├────────┼─────────┼─────────┼────────┼────────┤
738 │0 │ 1.00│ 1.00│ -1.00│ -1.00│
739 │-1 │ .10│ .10│ -.10│ -.10│
740 │-2 │ .01│ .01│ -.01│ -.01│
741 │-3 │ .00│ .00│ .00│ .00│
742 │-4 │ .00│ .00│ .00│ .00│
743 │-5 │1.00E-005│1.00E-005│ .00│ .00│
744 │-6 │1.00E-006│1.00E-006│ .00│ .00│
745 │-7 │1.00E-007│1.00E-007│ .00│ .00│
746 │-8 │1.00E-008│1.00E-008│ .00│ .00│
747 │-9 │1.00E-009│1.00E-009│ .00│ .00│
748 ╰────────┴─────────┴─────────┴────────┴────────╯