https://bugs.freedesktop.org/show_bug.cgi?id=43262
Bug #: 43262
Summary: : OFFSET function's third argument is mandatory,
contradicting Help
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.4 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
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.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
