I have a large list of settings (with variations for different builds) I'm importing from a Google Sheet but at the moment I don't see an easy way of transposing the data at the BakingSheet end so that the 'rows' of data are laid out horizontally and the 'columns' are on the left hand side, vertically.
I think a property in the Sheet definition would be required ie bool importTransposed = true
And then maybe just adding a toggle in the GetCell to reverse the SheetConverter - thing is that currently doesn't have access to the Sheet definition. Also the record/row count would be wrong as the last empty column should be used rather than the row.
Anyway - a feature suggestion as it came to mind really.
Currently possible to transpose in the Google Sheet using reference formula cells in the Google Sheet, hide the Import Sheet and only work on the referenced sheet - so it's not vital or anything. Or manually before import etc.
I have a large list of settings (with variations for different builds) I'm importing from a Google Sheet but at the moment I don't see an easy way of transposing the data at the BakingSheet end so that the 'rows' of data are laid out horizontally and the 'columns' are on the left hand side, vertically.
I think a property in the Sheet definition would be required ie bool importTransposed = true
And then maybe just adding a toggle in the GetCell to reverse the SheetConverter - thing is that currently doesn't have access to the Sheet definition. Also the record/row count would be wrong as the last empty column should be used rather than the row.
Anyway - a feature suggestion as it came to mind really.
Currently possible to transpose in the Google Sheet using reference formula cells in the Google Sheet, hide the Import Sheet and only work on the referenced sheet - so it's not vital or anything. Or manually before import etc.