i try to copy and paste (fill up) a column with a formula.
how can this be done as i can drag things down, this won’t work for me with more than 100 cells.
tried this “paste special” but this filled up only one cell. Then there’s “alt+enter” does basically the same.
it should be any easy thing todo, right?
Does the formula refer to an adjacent column that is filled? If so, double click on the little handle on the bottom right of your formula cell to fill down to where the adjacent cell has data.
If this answer helped you, please accept it by clicking the check mark 
to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.
i get there the square dot… if i double click that nothing happens.
You have to mark the target range before you paste the formula. To mark a range without mouse enter the range address into the “Name Box” field top-left of the grid and hit Enter. Or you can name the target range via Sheet > Named Ranges and Expressions. Then you can select this range from the drop-down-list of the “Name Box” field.
Method A: Write F1:F100000 into the name field, Enter. Click in input line and write =E1*2. Press Alt+Enter.
Method B: Write =E1*2 into cell F1, Enter. Write F1:F100000 into name field, Enter. Press Ctrl+D for to fill down.
Method C: Write =E1*2 into cell F1, Enter. Set cell cursor to F1, Ctrl+C. Enter F2:F100000 into name field, Enter. Ctrl+V.
Please do exactly as I describe it, especially where to write something and when to press Enter. Try the methods with an separate spreadsheet and the simple formula =E1*2. In case your real formula is complex, it might take a while to fill and recalculate 100000 cells. Which version of LibreOffice do you use, which operating system?
well, then i can select as much as i want, but if i paste the formula i get the dialog to paste unformatted text. Am i doing something wrong?
Du you really have one formula in the clipboard? Click in cell with formula. Ctrl+C. Select the range as indicated above. Ctrl+V.
BTW: Alt+Enter is for filling using the input line. Mark the target area. Click in input line. Write formula into input line. Alt+Enter.
well, not sure what i am doing…
i mark the cell with the formula, CTRL+C, i can paste it like that anywhere else.
then i mark some cells bellow and try to paste it
i mark some cells below the formula… paste it and nothing happens.
perhaps i ask the wrong thing…
i want to create a series like i.e.
F1=E1 * 2
F2=E2 * 2
F3=E3 * 2
Fn=En * 2
but i wanna fill the cells up until about 100000.
how can i do that? any more ideas?