Download it now!
Bug 30900 - OFFSET function doesn't work when used within named range.
Summary: OFFSET function doesn't work when used within named range.
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
(earliest affected)
Hardware: Other All
: medium normal
Assignee: Kohei Yoshida
Depends on:
Reported: 2010-10-15 08:48 UTC by Kohei Yoshida
Modified: 2010-11-01 10:50 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Exemple of List with OFFSET (11.07 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-10-26 01:55 UTC, GerardF

Note You need to log in before you can comment on or make changes to this bug.
Description Kohei Yoshida 2010-10-15 08:48:14 UTC
Originally reported here:

I quote:

I frequently use OFFSET in Insert > Name > Define for create Drop down lists.

The array formula =OFFSET(A1;0;0;1;COUNTA(A1:H1)) returns Error 504 with LibO Beta2.

May be it's a collateral damage of the resolution of this bug :

Thanks to have a look.

Comment 1 Kohei Yoshida 2010-10-25 18:26:44 UTC
Adding the original reporter to the CC.
Comment 2 Kohei Yoshida 2010-10-25 18:28:37 UTC
Gérard, could you attach a minimal test document that contains the problem you reported to this bugzilla page?  Note that the attachment will become publicly accessible.  Thanks.
Comment 3 GerardF 2010-10-26 01:55:17 UTC
Created attachment 39779 [details]
Exemple of List with OFFSET

May be this bug is fixed with resolution of this issue :
Comment 4 Kohei Yoshida 2010-10-28 16:51:25 UTC
Ok.  In the test document, the validity drop-down list shows item1 through item10, so I assume this document is now working properly.

Thanks a lot for the test document, Gérard. :-)
Comment 5 sophie 2010-11-01 10:50:11 UTC
Verified in 10_10_28_Cedric.rpm build - Closing - Sophie