Originally reported here: http://the-document-foundation.969070.n3.nabble.com/OFFSET-function-don-t-works-tt1700974.html I quote: --- Hi, 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 : http://qa.openoffice.org/issues/show_bug.cgi?id=103331 Thanks to have a look. Gérard ---
Adding the original reporter to the CC.
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.
Created attachment 39779 [details] Exemple of List with OFFSET May be this bug is fixed with resolution of this issue : https://bugs.freedesktop.org/show_bug.cgi?id=30946
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. :-)
Verified in 10_10_28_Cedric.rpm build - Closing - Sophie