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_DATA([expout], [dnl
29 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [expout])
30 AT_CHECK([pspp-output -O box=unicode convert render.spv -], [0], [expout])
33 AT_SETUP([2-d pivot table])
34 AT_DATA([pivot.txt], [[
35 /col "a"("a1", "a2", "a3")
36 /col "b"("b1", "b2", "b3")
38 /title "Columns" /display
39 /title "Rows" /transpose /display
40 /title "Column x Row" /move "a" column /display
41 /title "Row x Column" /transpose
43 AT_DATA([expout], [dnl
45 ╭────────┬────────┬────────╮
47 ├──┬──┬──┼──┬──┬──┼──┬──┬──┤
48 │a1│a2│a3│a1│a2│a3│a1│a2│a3│
49 ├──┼──┼──┼──┼──┼──┼──┼──┼──┤
50 │ 0│ 1│ 2│ 3│ 4│ 5│ 6│ 7│ 8│
51 ╰──┴──┴──┴──┴──┴──┴──┴──┴──╯
86 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [expout])
87 AT_CHECK([pspp-output -O box=unicode convert render.spv -], [0], [expout])
90 AT_SETUP([2-d pivot table - dimension labels])
91 AT_DATA([pivot.txt], [[
92 /col "a"*("a1", "a2", "a3")
93 /col "b"*("b1", "b2", "b3")
95 /title "Columns" /display
96 /title "Rows - Corner" /transpose /display
97 /title "Rows - Nested" /look rowlabels=nested /display
98 /title "Column x Row - Corner" /move "a" column /look rowlabels=corner /display
99 /title "Column x Row - Nested" /look rowlabels=nested /display
100 /title "Row x Column - Corner" /transpose /look rowlabels=corner /display
101 /title "Row x Column - Nested" /look rowlabels=nested
103 AT_DATA([expout], [dnl
105 ╭──────────────────────────╮
107 ├────────┬────────┬────────┤
109 ├────────┼────────┼────────┤
111 ├──┬──┬──┼──┬──┬──┼──┬──┬──┤
112 │a1│a2│a3│a1│a2│a3│a1│a2│a3│
113 ├──┼──┼──┼──┼──┼──┼──┼──┼──┤
114 │ 0│ 1│ 2│ 3│ 4│ 5│ 6│ 7│ 8│
115 ╰──┴──┴──┴──┴──┴──┴──┴──┴──╯
149 Column x Row - Corner
160 Column x Row - Nested
171 Row x Column - Corner
182 Row x Column - Nested
193 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [expout])
194 AT_CHECK([pspp-output -O box=unicode convert render.spv -], [0], [expout])
197 AT_SETUP([2-d pivot table - groups])
198 AT_DATA([pivot.txt], [[
199 /col "a"("a1", "ag1"("a2", "a3"))
200 /col "b"("bg1"("b1", "b2"), "b3")
202 /title "Columns" /display
203 /title "Rows" /transpose /display
204 /title "Column x Row" /move "a" column /display
205 /title "Row x Column" /transpose /display
206 /title "Row x Column - delete b2" /cells[all,1]=delete /display
207 /title "Row x Column - delete b2 - show empty" /look empty=show /display
208 /title "Row x Column - delete b1" /cells[all,0]=delete /look empty=hide /display
209 /title "Row x Column - delete b1 - show empty" /look empty=show.
211 AT_DATA([expout], [dnl
213 ╭─────────────────┬────────╮
215 ├────────┬────────┤ │
217 ├──┬─────┼──┬─────┼──┬─────┤
218 │ │ ag1 │ │ ag1 │ │ ag1 │
219 │ ├──┬──┤ ├──┬──┤ ├──┬──┤
220 │a1│a2│a3│a1│a2│a3│a1│a2│a3│
221 ├──┼──┼──┼──┼──┼──┼──┼──┼──┤
222 │ 0│ 1│ 2│ 3│ 4│ 5│ 6│ 7│ 8│
223 ╰──┴──┴──┴──┴──┴──┴──┴──┴──╯
267 Row x Column - delete b2
279 Row x Column - delete b2 - show empty
291 Row x Column - delete b1
301 Row x Column - delete b1 - show empty
313 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [expout])
314 AT_CHECK([pspp-output -O box=unicode convert render.spv -], [0], [expout])
317 AT_SETUP([2-d pivot table - layers])
318 AT_DATA([pivot.txt], [[
319 /col "a"("a1", "a2", "a3")
320 /layer "b"("b1", "b2", "b3")
322 /title "Column x b1" /display
323 /title "Row x b1" /transpose /display
324 /title "Column x b2" /show layer 1 /transpose /display
325 /title "Row x b2" /transpose /display
326 /title "Column (All Layers)" /look layers=all /display
327 /title "Row (All Layers)" /transpose /look layers=all
329 AT_DATA([expout], [dnl
410 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [expout])
411 AT_CHECK([pspp-output -O box=unicode convert render.spv -], [0], [expout])
414 AT_SETUP([3-d pivot table - layers])
415 AT_DATA([pivot.txt], [[
416 /layer "a"("a1", "a2", "a3")
417 /layer "b"("b1", "b2", "b3", "b4")
418 /col "c"("c1", "c2", "c3", "c4", "c5")
420 /title "Column x b1 x a1" /display
421 /title "Column x b2 x a1" /show layer 0 1 /display
422 /title "Column x b3 x a2" /show layer 1 2 /display
424 AT_DATA([expout], [dnl
452 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [expout])
453 AT_CHECK([pspp-output -O box=unicode convert render.spv -], [0], [expout])
456 AT_SETUP([pivot table title and caption])
457 AT_DATA([pivot.txt], [[
461 /title "Title + Caption" /caption "Title + Caption" /display
462 /title "Title Only" /caption "(Not Shown)" /show title=yes caption=no /display
463 /title "(Not Shown)" /caption "Caption Only" /show title=no caption=yes /display
464 /title "(Not Shown)" /caption "(Not Shown)" /show title=no caption=no
466 AT_DATA([expout], [dnl
499 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [expout])
500 AT_CHECK([pspp-output -O box=unicode convert render.spv -], [0], [expout])
503 AT_SETUP([pivot table footnotes])
504 AT_KEYWORDS([footnote])
505 AT_DATA([pivot.txt], [[
506 /footnote[0] "First footnote" marker="*"
507 /footnote[1] "Second footnote"
508 /col "A"[footnote 0]*("B"[footnote 1], "C"[footnote 0 1])
509 /row "D"[footnote 1]*("E"[footnote 0], "F"[footnote 1 0])
510 /look rowlabels=nested
512 /cell[1, 0]=1[footnote 0]
513 /cell[0, 1]=2[footnote 1]
514 /cell[1, 1]=3[footnote 0 1]
515 /caption "Caption"[footnote 0]
516 /corner "Corner"[footnote 0 1]
517 /title "Pivot Table with Alphabetic Subscript Footnotes"[footnote 0]
518 /look marker=alpha level=sub
520 /title "Pivot Table with Alphabetic Superscript Footnotes"[footnote 0]
521 /look marker=alpha level=super
523 /title "Pivot Table with Numeric Subscript Footnotes"[footnote 0]
524 /look marker=numeric level=sub
526 /title "Pivot Table with Numeric Superscript Footnotes"[footnote 0]
527 /look marker=numeric level=super
529 /title "Hidden Footnote"[footnote 0]
530 /footnote[0] "First footnote" marker="*" hide
533 [[Pivot Table with Alphabetic Subscript 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 Alphabetic Superscript Footnotes[*]
547 ╭────────────┬──────────────────╮
549 │ ├───────┬──────────┤
550 │Corner[*][b]│ B[b] │ C[*][b] │
551 ├────────────┼───────┼──────────┤
552 │D[b] E[*] │ .00│ 1.00[*]│
553 │ F[*][b]│2.00[b]│3.00[*][b]│
554 ╰────────────┴───────┴──────────╯
559 Pivot Table with Numeric Subscript 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 ╰────────────┴───────┴──────────╯
572 Pivot Table with Numeric Superscript Footnotes[*]
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 ╭────────────┬──────────────────╮
588 │ ├───────┬──────────┤
589 │Corner[*][2]│ B[2] │ C[*][2] │
590 ├────────────┼───────┼──────────┤
591 │D[2] E[*] │ .00│ 1.00[*]│
592 │ F[*][2]│2.00[2]│3.00[*][2]│
593 ╰────────────┴───────┴──────────╯
597 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [expout])
598 AT_CHECK([pspp-output -O box=unicode convert render.spv -], [0], [expout])
601 AT_SETUP([pivot table with no dimensions])
602 AT_DATA([pivot.txt], [[
603 /title "No Dimensions"
605 AT_DATA([expout], [dnl
610 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [expout])
611 AT_CHECK([pspp-output -O box=unicode convert render.spv -], [0], [expout])
614 AT_SETUP([pivot table with empty dimensions])
615 AT_DATA([pivot.txt], [[
618 /title "One Empty Dimension" /display
619 /title "Two Empty Dimensions" /row "b"*() /display
620 /title "Three Dimensions, Two Empty" /row "c"("c1", "c2")
622 AT_DATA([expout], [dnl
627 Three Dimensions, Two Empty
629 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [expout])
630 AT_CHECK([pspp-output -O box=unicode convert render.spv -], [0], [expout])
633 AT_SETUP([pivot table with empty groups])
634 AT_DATA([pivot.txt], [[
635 /col "a"("a1", "a2"(), "a3")
636 /row "b"("b1"(), "b2", "b3")
641 AT_DATA([expout], [dnl
650 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [expout])
651 AT_CHECK([pspp-output -O box=unicode convert render.spv -], [0], [expout])
654 AT_SETUP([pivot table - category and dimension borders 1])
655 AT_DATA([pivot.txt], [[
656 /col "a"*("a1", "ag1"("a2", "a3"))
657 /col "b"*("bg1"("b1", "b2"), "b3")
658 /row "c"*("c1", "cg1"("c2", "c3"))
659 /row "d"*("dg1"("d1", "d2"), "d3")
660 /cell[all, all, all, all]
662 /border "dim-row-horz" (solid "blue")
663 /border "dim-col-vert" (solid "blue")
664 /title "Dimension Borders 1"
667 /border "cat-row-horz" (dashed "red")
668 /border "cat-col-vert" (dashed "red")
669 /title "Category Borders 1"
672 /border "dim-row-horz" (solid "blue")
673 /border "dim-col-vert" (solid "blue")
674 /border "cat-row-horz" (dashed "red")
675 /border "cat-col-vert" (dashed "red")
676 /title "Category and Dimension Borders 1"
678 AT_DATA([expout], [dnl
684 │ ag1 │ │ ag1 │ │ ag1
685 d c a1│a2 a3│a1│a2 a3│a1│a2 a3
686 dg1 d1 c1 0│ 1 2│ 3│ 4 5│ 6│ 7 8
687 ╶─────────┼─────┼──┼─────┼──┼─────
688 cg1 c2 9│10 11│12│13 14│15│16 17
689 c3 18│19 20│21│22 23│24│25 26
690 ╶────────────┼─────┼──┼─────┼──┼─────
691 d2 c1 27│28 29│30│31 32│33│34 35
692 ╶─────────┼─────┼──┼─────┼──┼─────
693 cg1 c2 36│37 38│39│40 41│42│43 44
694 c3 45│46 47│48│49 50│51│52 53
695 ────────────────┼─────┼──┼─────┼──┼─────
696 d3 c1 54│55 56│57│58 59│60│61 62
697 ╶─────────┼─────┼──┼─────┼──┼─────
698 cg1 c2 63│64 65│66│67 68│69│70 71
699 c3 72│73 74│75│76 77│78│79 80
707 d c a1 a2┊a3 a1 a2┊a3 a1 a2┊a3
708 dg1 d1 c1 0 1┊ 2 3 4┊ 5 6 7┊ 8
709 cg1 c2 9 10┊11 12 13┊14 15 16┊17
710 ╶╌╌╌╌╌╌╌╌+╌╌╌╌╌╌╌╌+╌╌╌╌╌╌╌╌+╌╌
711 c3 18 19┊20 21 22┊23 24 25┊26
712 d2 c1 27 28┊29 30 31┊32 33 34┊35
713 cg1 c2 36 37┊38 39 40┊41 42 43┊44
714 ╶╌╌╌╌╌╌╌╌+╌╌╌╌╌╌╌╌+╌╌╌╌╌╌╌╌+╌╌
715 c3 45 46┊47 48 49┊50 51 52┊53
716 d3 c1 54 55┊56 57 58┊59 60 61┊62
717 cg1 c2 63 64┊65 66 67┊68 69 70┊71
718 ╶╌╌╌╌╌╌╌╌+╌╌╌╌╌╌╌╌+╌╌╌╌╌╌╌╌+╌╌
719 c3 72 73┊74 75 76┊77 78 79┊80
721 Category and Dimension Borders 1
726 │ ag1 │ │ ag1 │ │ ag1
727 d c a1│a2┊a3│a1│a2┊a3│a1│a2┊a3
728 dg1 d1 c1 0│ 1┊ 2│ 3│ 4┊ 5│ 6│ 7┊ 8
729 ╶─────────┼──┼──┼──┼──┼──┼──┼──┼──
730 cg1 c2 9│10┊11│12│13┊14│15│16┊17
731 ╶╌╌╌╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌
732 c3 18│19┊20│21│22┊23│24│25┊26
733 ╶────────────┼──┼──┼──┼──┼──┼──┼──┼──
734 d2 c1 27│28┊29│30│31┊32│33│34┊35
735 ╶─────────┼──┼──┼──┼──┼──┼──┼──┼──
736 cg1 c2 36│37┊38│39│40┊41│42│43┊44
737 ╶╌╌╌╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌
738 c3 45│46┊47│48│49┊50│51│52┊53
739 ────────────────┼──┼──┼──┼──┼──┼──┼──┼──
740 d3 c1 54│55┊56│57│58┊59│60│61┊62
741 ╶─────────┼──┼──┼──┼──┼──┼──┼──┼──
742 cg1 c2 63│64┊65│66│67┊68│69│70┊71
743 ╶╌╌╌╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌
744 c3 72│73┊74│75│76┊77│78│79┊80
746 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [expout])
747 AT_CHECK([pspp-output -O box=unicode convert render.spv -], [0], [expout])
750 AT_SETUP([pivot table - category and dimension borders 2])
751 AT_DATA([pivot.txt], [[
752 /col "a"*("a1", "ag1"("a2", "a3"))
753 /col "b"*("bg1"("b1", "b2"), "b3")
754 /row "c"*("c1", "cg1"("c2", "c3"))
755 /row "d"*("dg1"("d1", "d2"), "d3")
756 /cell[all, all, all, all]
758 /border "dim-row-vert" (solid "blue")
759 /border "dim-col-horz" (solid "blue")
760 /title "Dimension Borders 2"
763 /border "cat-row-vert" (dashed "red")
764 /border "cat-col-horz" (dashed "red")
765 /title "Category Borders 2"
768 /border "dim-row-vert" (solid "blue")
769 /border "cat-row-vert" (dashed "red")
770 /border "dim-col-horz" (solid "blue")
771 /border "cat-col-horz" (dashed "red")
772 /title "Category and Dimension Borders 2"
774 AT_DATA([expout], [dnl
779 ╶──────────────────────────
782 d c a1 a2 a3 a1 a2 a3 a1 a2 a3
783 dg1 d1│c1 0 1 2 3 4 5 6 7 8
784 │cg1 c2 9 10 11 12 13 14 15 16 17
785 │ c3 18 19 20 21 22 23 24 25 26
786 d2│c1 27 28 29 30 31 32 33 34 35
787 │cg1 c2 36 37 38 39 40 41 42 43 44
788 │ c3 45 46 47 48 49 50 51 52 53
789 d3 │c1 54 55 56 57 58 59 60 61 62
790 │cg1 c2 63 64 65 66 67 68 69 70 71
791 │ c3 72 73 74 75 76 77 78 79 80
795 ╶╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌
800 ╶╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌
802 ╶╌╌╌╌╌╴ ╶╌╌╌╌╌╴ ╶╌╌╌╌╌
803 d c a1 a2 a3 a1 a2 a3 a1 a2 a3
804 dg1┊d1 c1 0 1 2 3 4 5 6 7 8
805 ┊ cg1┊c2 9 10 11 12 13 14 15 16 17
806 ┊ ┊c3 18 19 20 21 22 23 24 25 26
807 ┊d2 c1 27 28 29 30 31 32 33 34 35
808 ┊ cg1┊c2 36 37 38 39 40 41 42 43 44
809 ┊ ┊c3 45 46 47 48 49 50 51 52 53
810 d3 c1 54 55 56 57 58 59 60 61 62
811 cg1┊c2 63 64 65 66 67 68 69 70 71
812 ┊c3 72 73 74 75 76 77 78 79 80
814 Category and Dimension Borders 2
816 ╶╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌
820 ╶──────────────────────────
822 ╶╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌
824 ╶╌╌╌╌╌╴ ╶╌╌╌╌╌╴ ╶╌╌╌╌╌
825 d c a1 a2 a3 a1 a2 a3 a1 a2 a3
826 dg1┊d1│c1 0 1 2 3 4 5 6 7 8
827 ┊ │cg1┊c2 9 10 11 12 13 14 15 16 17
828 ┊ │ ┊c3 18 19 20 21 22 23 24 25 26
829 ┊d2│c1 27 28 29 30 31 32 33 34 35
830 ┊ │cg1┊c2 36 37 38 39 40 41 42 43 44
831 ┊ │ ┊c3 45 46 47 48 49 50 51 52 53
832 d3 │c1 54 55 56 57 58 59 60 61 62
833 │cg1┊c2 63 64 65 66 67 68 69 70 71
834 │ ┊c3 72 73 74 75 76 77 78 79 80
836 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [expout])
837 AT_CHECK([pspp-output -O box=unicode convert render.spv -], [0], [expout])
840 AT_SETUP([pivot table - category and dimension borders 3])
841 AT_DATA([pivot.txt], [[
842 /col "a"("a1", "ag1"("a2", "a3"))
843 /col "b"("bg1"("b1", "b2"), "b3")
844 /row "c"("c1", "cg1"("c2", "c3"))
845 /row "d"("dg1"("d1", "d2"), "d3")
846 /cell[all, all, all, all]
848 /border "dim-row-horz" (solid "blue")
849 "cat-row-horz" (dashed "red")
850 "dim-row-vert" (solid "blue")
851 "cat-row-vert" (dashed "red")
852 "dim-col-horz" (solid "blue")
853 "cat-col-horz" (dashed "red")
854 "dim-col-vert" (solid "blue")
855 "cat-col-vert" (dashed "red")
856 /title "Category and Dimension Borders 3"
858 AT_DATA([expout], [dnl
859 Category and Dimension Borders 3
863 ╶──┬─────┼──┬─────┼──┬─────
864 │ ag1 │ │ ag1 │ │ ag1
865 ├╌╌┬╌╌┤ ├╌╌┬╌╌┤ ├╌╌┬╌╌
866 a1│a2┊a3│a1│a2┊a3│a1│a2┊a3
867 dg1┊d1│c1 0│ 1┊ 2│ 3│ 4┊ 5│ 6│ 7┊ 8
868 ┊ ├───┬─────┼──┼──┼──┼──┼──┼──┼──┼──
869 ┊ │cg1┊c2 9│10┊11│12│13┊14│15│16┊17
870 ┊ │ ├╌╌╌╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌
871 ┊ │ ┊c3 18│19┊20│21│22┊23│24│25┊26
872 ├──┼───┴─────┼──┼──┼──┼──┼──┼──┼──┼──
873 ┊d2│c1 27│28┊29│30│31┊32│33│34┊35
874 ┊ ├───┬─────┼──┼──┼──┼──┼──┼──┼──┼──
875 ┊ │cg1┊c2 36│37┊38│39│40┊41│42│43┊44
876 ┊ │ ├╌╌╌╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌
877 ┊ │ ┊c3 45│46┊47│48│49┊50│51│52┊53
878 ───┴──┼───┴─────┼──┼──┼──┼──┼──┼──┼──┼──
879 d3 │c1 54│55┊56│57│58┊59│60│61┊62
880 ├───┬─────┼──┼──┼──┼──┼──┼──┼──┼──
881 │cg1┊c2 63│64┊65│66│67┊68│69│70┊71
882 │ ├╌╌╌╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌┼╌╌┼╌╌+╌╌
883 │ ┊c3 72│73┊74│75│76┊77│78│79┊80
885 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [expout])
886 AT_CHECK([pspp-output -O box=unicode convert render.spv -], [0], [expout])
889 AT_SETUP([pivot table - small numbers])
890 AT_DATA([pivot.txt], [[
891 /title "small numbers"
892 /row "exponent"*("0", "-1", "-2", "-3", "-4", "-5", "-6", "-7", "-8", "-9")
893 /col "sign"*("positive", "negative")
894 /col "result class"*("general" RC_OTHER, "specific" RC_RESIDUAL)
898 /cell[3, 0, 0] = .001
899 /cell[4, 0, 0] = .0001
900 /cell[5, 0, 0] = .00001
901 /cell[6, 0, 0] = .000001
902 /cell[7, 0, 0] = .0000001
903 /cell[8, 0, 0] = .00000001
904 /cell[9, 0, 0] = .000000001
907 /cell[2, 0, 1] = -.01
908 /cell[3, 0, 1] = -.001
909 /cell[4, 0, 1] = -.0001
910 /cell[5, 0, 1] = -.00001
911 /cell[6, 0, 1] = -.000001
912 /cell[7, 0, 1] = -.0000001
913 /cell[8, 0, 1] = -.00000001
914 /cell[9, 0, 1] = -.000000001
918 /cell[3, 1, 0] = .001
919 /cell[4, 1, 0] = .0001
920 /cell[5, 1, 0] = .00001
921 /cell[6, 1, 0] = .000001
922 /cell[7, 1, 0] = .0000001
923 /cell[8, 1, 0] = .00000001
924 /cell[9, 1, 0] = .000000001
927 /cell[2, 1, 1] = -.01
928 /cell[3, 1, 1] = -.001
929 /cell[4, 1, 1] = -.0001
930 /cell[5, 1, 1] = -.00001
931 /cell[6, 1, 1] = -.000001
932 /cell[7, 1, 1] = -.0000001
933 /cell[8, 1, 1] = -.00000001
934 /cell[9, 1, 1] = -.000000001
936 AT_DATA([expout], [dnl
938 ╭────────┬─────────────────────────────────────╮
940 │ ├───────────────────┬─────────────────┤
941 │ │ general │ specific │
942 │ ├───────────────────┼─────────────────┤
944 │ ├─────────┬─────────┼────────┬────────┤
945 │exponent│ positive│ negative│positive│negative│
946 ├────────┼─────────┼─────────┼────────┼────────┤
947 │0 │ 1.00│ 1.00│ -1.00│ -1.00│
948 │-1 │ .10│ .10│ -.10│ -.10│
949 │-2 │ .01│ .01│ -.01│ -.01│
950 │-3 │ .00│ .00│ .00│ .00│
951 │-4 │ .00│ .00│ .00│ .00│
952 │-5 │1.00E-005│1.00E-005│ .00│ .00│
953 │-6 │1.00E-006│1.00E-006│ .00│ .00│
954 │-7 │1.00E-007│1.00E-007│ .00│ .00│
955 │-8 │1.00E-008│1.00E-008│ .00│ .00│
956 │-9 │1.00E-009│1.00E-009│ .00│ .00│
957 ╰────────┴─────────┴─────────┴────────┴────────╯
959 AT_CHECK([pivot-table-test --table-look $srcdir/output/look.stt pivot.txt --box unicode], [0], [expout])
960 AT_CHECK([pspp-output -O box=unicode convert render.spv -], [0], [expout])