Suppose I have a very large data set in Calc and I want to enter a formula into several thousand cells. Is there a way to do so besides typing the formula into one cell and then dragging it over 46 655 more cells?
Alternative to click & drag? - openoffice.org
it is free