Apache OpenOffice (AOO) Bugzilla – Issue 53262
function INDIRECT produces ERR 508 when using a range
Last modified: 2005-09-13 10:19:48 UTC
When you import a spreadsheet from Excel with the function "INDIRECT" or use the Excel-Convention for the function "INDIRECT" ERR 508 might occure as follows: If you use INDIRECT as single arguments it works proper. If you use INDIRECT within a range-arguments ERR 508 is produced. Example: Content of Cell B1 is "2" Content of Cell C1 is "5" Content of Cell A1 is “=SUM(INDIRECT(ADDRESS(1;2));INDIRECT(ADDRESS(1;3)))†Content of Cell A2 is “=SUM(INDIRECT(ADDRESS(1;2)):INDIRECT(ADDRESS(1;3)))†The same happens with the function "INDIRECT" (see extra issue)
Created attachment 28710 [details] Function INDIRECT produces ERR 508 when used as argument in ranges
I checked with 2.0 (1.9.m122) German version WIN XP: [680m122(Build8941)] and also with 1.1.4 (German) WIN XP: [645m52 (Build 8824)], both same result. Seems to be the same problem as in issue 53263 (pls also read comments there!): SUMME (samd as SUM) does not work for ranage if formula contains INDIRECT, but it works for discrete values separated by semicolon.
it's a double to Issue 4904 please check also the comments on the other duplicates. *** This issue has been marked as a duplicate of 4904 ***
closed double