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
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