Bug 43262 - : OFFSET function's third argument is mandatory, contradicting Help
Summary: : OFFSET function's third argument is mandatory, contradicting Help
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
(earliest affected)
3.4.4 release
Hardware: Other All
: medium minor
Assignee: Not Assigned
Whiteboard: BSA target:5.2.0
Depends on:
Reported: 2011-11-26 11:36 UTC by Ed
Modified: 2017-12-16 14:09 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Ed 2011-11-26 11:36:50 UTC
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.
Comment 1 sasha.libreoffice 2012-04-27 02:31:38 UTC
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
Comment 2 A (Andy) 2014-10-11 16:46:10 UTC
Reproducible with LO (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).
Comment 3 QA Administrators 2015-10-14 19:56:30 UTC Comment hidden (obsolete)
Comment 4 Commit Notification 2016-01-30 22:51:04 UTC
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":


tdf#43262: Correct OFFSET function's help page
Comment 5 Xisco Faulí 2016-09-15 21:15:58 UTC Comment hidden (obsolete)
Comment 6 Xisco Faulí 2017-11-05 21:58:14 UTC
A polite ping to Olivier Hallot: is this bug fixed? if so, could you please
close it as RESOLVED FIXED ? Thanks