Another unexpected behaviour of the tables feed, (which is probably co-incidental to the 'table definition updates values of cells in the header' behaviour above), is that if you were lazy in your spreadsheet and put a validation rule on an entire column, and neglected to 'remove validation' from the non-compliant header cell, then when you define your table (ie. attempt to insert the table <entry/> into the tables feed, you get:
403 Forbidden strictValidationFailed Actually, no you don't. Just while I was qualifying this issue, it's been fixed so that when you define a table, and the header has a strict validation, it automatically removes the strict validation from the cell before updating it. It got fixed just before I could say whether the behaviour was triggered only when the header cell's value was different from the name in the newly-defined table. That's reasonable behaviour, I guess, providing you're going to have this tight mutual relationship between tables and worksheets that seems to be happening.
