pivot-table: Change the default format to omit empty rows and columns.
authorBen Pfaff <blp@cs.stanford.edu>
Mon, 21 Dec 2020 04:30:18 +0000 (20:30 -0800)
committerBen Pfaff <blp@cs.stanford.edu>
Mon, 21 Dec 2020 04:30:18 +0000 (20:30 -0800)
commit0200682d517fd4b7cfc4e333378de03bcf74be43
treed159540977d9e2e12f3bb37773d9f60339b09a13
parent556481e5944e4c9a9f9a0ef74ceddb005a199eea
pivot-table: Change the default format to omit empty rows and columns.

By making this the default, it doesn't become necessary to make a lot of
procedures that yield output change the format to produce reasonable
output.  This means that the user's settings for the format won't get
overridden.

This changes a lot of output that had empty columns, in particular
anything that used DISPLAY DICTIONARY with a dictionary that had no
variable labels or missing values.  This commit also updates the expected
output to match.

An unexpected side effect was that some tables became empty entirely, for
example LIST with no rows.  This seemed undesirable, so I changed
pivot_table_enumerate_axis() so if an axis was entirely empty due to
omit_empty, then omit_empty was suppressed for that axis.
29 files changed:
perl-module/t/Pspp.t
src/language/stats/crosstabs.q
src/language/stats/examine.c
src/language/stats/factor.c
src/language/stats/means.c
src/language/stats/oneway.c
src/language/stats/rank.c
src/language/stats/roc.c
src/output/pivot-table.c
tests/data/pc+-file-reader.at
tests/data/por-file.at
tests/data/sys-file-reader.at
tests/data/sys-file.at
tests/language/data-io/get-data-psql.at
tests/language/data-io/get-data-spreadsheet.at
tests/language/data-io/list.at
tests/language/data-io/matrix-data.at
tests/language/dictionary/apply.at
tests/language/dictionary/formats.at
tests/language/dictionary/missing-values.at
tests/language/dictionary/sys-file-info.at
tests/language/dictionary/value-labels.at
tests/language/dictionary/variable-display.at
tests/language/stats/autorecode.at
tests/language/stats/crosstabs.at
tests/language/stats/frequencies.at
tests/language/stats/glm.at
tests/language/stats/rank.at
tests/perl-module.at