Herzlich Willkommen bei users@de.libreoffice.org

de-users
#1

Hello,

I need basic help with LibreOffice Calc.

I have a data sheet (no empty cells, rows or columns) and now want to copy only the numbers of certain cells of one column into a new sheet.

It should be like this: cell D4; cell D4+8cells down, cell D4+16cells down...
Or for another function cells D4+D5; Cells D4+8cells down + D5+8cells down; cells D4+16cells down + D5+16cells down...
And then copy these numbers into a new spreadsheet..
How can I do that very quickly? Does anybody have a solution?

Thanks a lot in advance,

Anna
PS: enclosed a screenshot of my data sheet

#2

I need basic help with LibreOffice Calc.

FYI: This is actually a german spoken mailing list. For talking english
it might would be a better idea, if you were looking for an english one.

I have a data sheet (no empty cells, rows or columns) and now want to copy only the numbers of certain cells of one column into a new sheet.

It should be like this: cell D4;

=sheet1.D4

cell D4+8cells down,

=VERSCHIEBUNG(sheet1.D4;8;0)

(AFAIK the english function is called OFFSET)

cell D4+16cells down...

=VERSCHIEBUNG(sheet1.D4;16;0)

Or for another function cells D4+D5;

=sheet1.D4+sheet1.D5

Cells D4+8cells down + D5+8cells down;

=VERSCHIEBUNG(sheet1.D4;8;0)+VERSCHIEBUNG(sheet1.D5;8;0)

cells D4+16cells down + D5+16cells down...

=VERSCHIEBUNG(sheet1.D4;16;0)+VERSCHIEBUNG(sheet1.D5;16;0)

And then copy these numbers into a new spreadsheet..
How can I do that very quickly? Does anybody have a solution?

I don't understand; any reference prefixed by the source sheet name can
be used directly within another sheet.

Wolfgang