In the position I’m in, I occasionally need to scan devices to a spreadsheet. This usually includes an asset tag and serial number per device. My scanner is set to input a Tab after a scan, which moves to the next column.
In Excel, when you format a group of cells as a table, tabbing will stay within the column bounds of the table, so that at the last column, another tab will move to the first column of the next row.
In Calc, by default, tabbing will continue moving to the column, regardless of how any table is formatted. Protecting the other columns will keep the selected cell from moving to unwanted columns, but tabbing at that barrier keeps the same cell selected, instead of moving to the first column of the next row.
I would like to replicate the table behavior that Excel has in Calc. Is this even possible?