Hi, Am 19.09.2014 um 09:01 schrieb martin f krafft:
> If a cell A1 contains '=B1' and I fill-down from A1 to A3, I get > references to B2 and B3 for the two new cells. > > Is it possible to fill down, but scan right? E.g. make A2 become C1 > and A3 become D1? This formula in A1 should behave as you desire: =OFFSET($B$1;0;ROW()-ROW($B$1)) Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
