At 15:59 15/07/2012 -0700, Andreas Säger wrote:
Vertically: =A1+MOD(ROW(A1);2) Horizontally: =A1+MOD(COLUMN(A1);2)
Do you perhaps mean: Vertically: =A1+MOD(ROW(A1)-1;2) Horizontally: =A1+MOD(COLUMN(A1)-1;2) Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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