Re: [de-users] Re: Herzlich Willkommen bei users -AT- de.libreoffice.org

Am 16.01.2014 10:09, schrieb schrox-com@yahoo.com:
> 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: users+unsubscribe@de.libreoffice.org
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