Entering data into a spreadsheet.

[phedlund]

I am working with a spreadsheet (libreoffice) Windows 11 (or windows 10). When i am filling out data to cells (read from a file) using a loop, the script runs correctly for the first 5 entries then fails to move right 1 cell, moves to next line as expected, then fails to move right 1 cell and enters the rest of the data correctly. 

INI FIle

[Bills]
Aqua Il=100
Com Ed=100
Farm & Fleet=0
Frontier=191.90
Meijers=0
Nicor=60
Sears=0
State Farm=103.73
Verizon=171.84

Code Snippit

Func Data2($v1, $v2)
    Send($v1 & "{RIGHT}" & $v2 & "{RIGHT}{Down}{Left 2}")
    Sleep($iTimeOut)
EndFunc

Func Create_Bills()
    Local $ary
    $ary = IniReadSection($INI_FILE, "SAVINGS")
    For $i = 1 to $ary[0][0] Step 2
        Data3($ary[$i][1], $ary[$i+1][0], $ary[$i+1][1])
    Next    
    Send("{RIGHT}")
    $ary = IniReadSection($INI_FILE, "Bills")
    For $i = 1 to $ary[0][0]
        Data2($ary[$i][0], $ary[$i][1])
    Next
EndFunc

Spreadsheet outpupt

	Aqua Il	100
	Com Ed	100
	Farm & Fleet	0
	Frontier	191.9
	Meijers0
Nicor	60
Sears	0
State Farm	103.73
Verizon	171.84

As you can see the meijers entry ignores the {right} command and the following line has the same issue.

I have used a function that brute forces the entry into the cells with the same effect.

I am currently at a loss and could use a new set of eyes on this. 

Thanks

[water]

There is an UDF available for LibreOffice. This way you can easily write data to a spreadsheet.