This used to work, I've used it in my workflow, documented it and passed it on to the customer.
Now it doesn't.
I have a sheet, 22 columns wide.
At the top of the sheet are several rows (in this specific case 4)
The first column has a formula in it in rows 3 and 4.
Previous workflow:
1. User deletes all content from rows 5+
2. User copies data from a spreadsheet range (21 columns wide) into the 5th row, 2nd column.
3. All data is pasted correctly. The first column's formulas all auto-fill.
New behavior:
1. User deletes all content from rows 5+
2. User copies data from a spreadsheet range (21 columns wide) into the 5th row, 2nd column.
3. All data is pasted correctly. NO AUTO-FILL.
If I paste TWO rows of data, auto-fill works.
SOMETIMES, if I paste more than two rows of data, the first new row will auto-fill but the remaining do not.
I suspect this is related to changes on the server side.
Every row that I paste, whether one at at time or in a batch should check for auto-fill and update accordingly.
Like it used to.
Craig
