Occurs when attempting to modify a spreadsheet in Calc with the auto filter 
activated and viewing a filtered selection of data, where only the data 
required is visable on the screen. 
There is no way to specifically auto-fill the visible cells without filling all 
the hidden cells in between those filtered. This means that to change or enter 
a repetitive value in a filtered selection of cells requires the cell to be 
modified individually and performed multiple times.
Microsoft Excel is different to this and when a selection is filtered and the 
autofill feature is used, only those cells visible on the screen are filled 
with the new value.

This is one of the most frustrating issues and the only real deficiency i see 
in Calc.