Working with lots of data in LibreOffice

Yes - you can define the range of selected cells manually, and after that, "fill" the formula into all selected cells. This may take some time if the formula is applied to 150,000 data sets, so maybe you should proceed stepwise (applying for rows 1 to 50,000, 51.000 to 100,000 and so on - or use a database as proposed by m0skit0).

The cell that's currently selected is displayed in the "Name Box":

You can modify the selection by simply clicking into the "Name Box" and change its value:

After you've set the selection's range this way, you can copy the the formula from cell B1 down into all selected cells using Fill -> Down from Edit menu:

or using the shortcut CTRL+D: this operation will only affect the selected cells; in my example: B1:B3.

As result, the formula is pasted only inside the cell range defined in the "Name Box".

Try double-clicking on the bottom right hand corner of the cell (ie on the box that you would otherwise drag).

Copied verbatim from this stackoverflow answer.

Select a formula. Copy it. Select all cells where you want to copy it. Paste.