Am 16.01.2014 10:09, schrieb [email protected]: > 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 -- -- Liste abmelden mit E-Mail an: [email protected] Probleme? http://de.libreoffice.org/hilfe-kontakt/mailing-listen/abmeldung-liste/ Tipps zu Listenmails: http://wiki.documentfoundation.org/Netiquette/de Listenarchiv: http://listarchives.libreoffice.org/de/users/ Alle E-Mails an diese Liste werden unlöschbar öffentlich archiviert
