Originally reported here:
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.
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