Apache OpenOffice (AOO) Bugzilla – Issue 53263
Function INDEX produces ERR 508 when used as argument in ranges
Last modified: 2005-09-13 10:20:01 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: When you import a spreadsheet from Excel with the function "INDEX" or use the Excel-Convention for the function "INDEX" ERR 508 might occure as follows: If you use INDEX as single arguments it works proper. If you use INDEX 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(INDEX(($B$1:$C$1);1;1;1);INDEX(($B$1:$C$1);1;2;1))†Content of Cell A2 is “=SUM(INDEX(($B$1:$C$1);1;1;1):INDEX(($B$1:$C$1);1;2;1))†The same happens with the function "INDIRECT" (see extra issue).
Created attachment 28711 [details] Function INDEX 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. I created a new attachment 'index10.ods' to demonstrate the problem, because index.ods contained some problems, example text-formula did not correspond with content of formulas in calculation fields. The difference between both lines is the kind of using =SUMME() In the first line, the sum is calculated from the numbers, separated by semicolon, that works. In the second line, the sum is calculated for a Range, what does not work. =summe(function) works fine for both lines if I replace the index-Pointers by field-names. Use of INDEX() seems to be possble only for the first possibility, not for the second one with the range. I do not believe that that is ok, so NEW
Created attachment 28720 [details] new testfile with screenshot
Reassign
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