Feature request: more flexible headers

[jackfoxy]

Description

Enable more flexibility to declaring headers. Currently header can only be the first row in a selected range.

Frequently headers will span 2 or more cells in a column. Sometimes headers are followed by a blank, or otherwise useless row. Including this row in selection range breaks column type inference.

Expected behavior

1. allow skipping one or more rows in a range after the header, such that type inference only takes place on remaining cells in column

2. allow for merging 2 or more contiguous cells in a column to be the column header

Actual behavior

Currently header can only be the first row in a selected range.

Known workarounds

1. alter the spreadsheet
2. use range without headers