Spreadsheet transposition

Description

Implemented the transposition of rows and columns in the spreadsheet.

Possible for numeric data only and also for spreadsheets having a text column as first column and numeric data in the other columns - the first column will be used to name the new transposed columns. The column mode of the new columns is determined automatically to hold all data without loss (choosing the "largest" mode of all original columns).

The implemented handling for the first text column is handy when pasting some data from an external source with text identifiers in the first column that should be used as column names after the transposition. Example of such a spreadsheet before

and after the transposition

Conformity

• Changelog entry
• Unit tests
• Update INSTALL
• Downport