I am running Calc on Windows XP. The OFFSET function, according to the Help, takes two mandatory arguments (Reference and Rows) and three optional ones (Columns, Height and Width). However, entering it with only two arguments (as, for example, OFFSET(A3,3)) gives 'Err:511' in the cell. The error value goes away if you supply a value for the third argument (as, for example, OFFSET(A3,3,0)). This behaviour clearly contradicts the Help entry for this function, and I would venture that the function SHOULD behave as per the Help: the commonest use of this function will surely be to 'move' a certain number of rows from a given cell, staying in the same column.
Reproduced in 3.5.2 on Fedora 64 bit help has this text: Columns (optional) is the number of columns by which the reference was corrected to the left (negative value) or to the right. but this is mandatory argument
Reproducible with LO 4.3.2.2 (Win 8.1), UK English and German UI The LO English and German online and offline help does not say that the column argument is mandatory. The function wizard in contrast shows it correctly (make a double mouse click on OFFSET / VERSCHIEBUNG in German UI).
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.