replacing value in array

[Hasher]

hi all

Having trouble with replacing a string in a dimensional array. basically i grab the first row in a Open office calc spreadsheet which are the column headers and want to change the names. I keep getting :

C:\Users\TurboLister\Packer.au3 (37) : ==> Array variable has incorrect number of subscripts or subscript dimension range exceeded.:

$array[1][5] = "TEST"

^ ERROR

Im sure Im doing something stupidly wrong here :-/

Thanks in Advance Paul

Global $array[1][30]
_OOInit()
_OOOpenBook(@ScriptDir & "/" & $file)
winwait("OpenOffice")
WinActivate("OpenOffice", "")
$array = _OOSheetRangetoArray(0, "A1", "AC1", "")
$array[1][5] = "TEST"
$OutString = StringReplace($string, $farray[$i][0], $farray[$i][1])
_ArrayDisplay($array, "Test")

[kylomas]

Hasher,

What do you expect the value of $i to be?

kylomas

[BrewManNH]

Actually the problem is that when you dimension an array with a dimension size of 1, the only valid value that subitem can have is $array[0], not $array[1].

[kylomas]

Yes, that would be problem #2 with this code...based on the error message

$array[1][5] = "TEST"

we are not seeing the code that produced the error.

kylomas

edit: assumption

of course I am assuming that $array[1][0] - [1][4] worked

Edited January 3, 2012 by kylomas

[goldenix]

first array row, 5-th column is $array[0][5]

$array[1][5] is the second row, 5-th column in the array

I recommend you use _ArrayDisplay($array) before trying to output data.

[BrewManNH]

BTW, kylomas you're also correct that his code in the line following the error line is also going to be causing him issues later because $i isn't defined anywhere in the snippet he showed us. I should have made note of that, but forgot to last night.

[kylomas]

BremanNH,

yea, I'm hanging up my fingers for now...I'm something like 4 for 7 correct in my last posts...if I was an Air Traffic Controlman there would be a lot of people in deep shit...

till head re-engages,

kylomas