OpenSpreadsheet icon indicating copy to clipboard operation
OpenSpreadsheet copied to clipboard

[Feature] Transpose columns and rows prior to applying reading rules

Open jzabroski opened this issue 5 years ago • 0 comments

We have some spreadsheets where users would rather enter data as rows instead of columns, and our plan is to just use Excel Paste as Transpose manually for now, but it would be great if a library did this automatically. This is done for practical reasons: There are about 180 fields but only 2-3 data points per day, so it's easier for users to enter things vertically and use a freeze pane and scroll vertically than to scroll horizontally.

Here is a heavily blurred image to give you an idea of what I mean.

image

jzabroski avatar Apr 19 '19 16:04 jzabroski