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.

[phedlund]

I think your missing my point. I am trying to debug a script. I am trying to figure out if there is some buffer limit on the send command or if

i need to do something else. 

Is there a wait till done type command that would finish a group of send commands before proceeding.

I would like to get this working properly.

This script is meant to help my wife to do our bills if i am unable to.

[argumentum]

21 hours ago, phedlund said:

...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,...

35 minutes ago, phedlund said:

I think your missing my point. I am trying to debug a script. I am trying to figure out if there is some buffer limit on the send command or ...

The help that was given was good for the question you had.

[Nine]

When you post code, please use the method provided in the link.  You should always post runnable code, not just part of it.  That way you are helping us helping you.  Understandable, that you just want to send keys to your spreadsheet.  Although, using a UDF is much more robust.  Anyway I tried to use your code with OnlyOffice, and it works well with an empty spreadsheet.  Here the code that I used (notice that I had to make it runnable).

Opt("WinTitleMatchMode", -2)

WinActivate ("Livre1.xlsx - ONLYOFFICE")
WinWaitActive("Livre1.xlsx - ONLYOFFICE")

Global $INI_FILE = "Test.ini", $iTimeOut = 125
Send("{RIGHT}")

Create_Bills()

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

Func Create_Bills()
    $ary = IniReadSection($INI_FILE, "Bills")
    For $i = 1 to $ary[0][0]
        Data2($ary[$i][0], $ary[$i][1])
    Next
EndFunc

My guess is that maybe something is interfering with your send keys.  Try with a blank sheet.  You could also try adding some sleep after $v1 and $v2.

ps. take a look at SendKeepActive in help file, that could also remove some interferences. 

Edited Saturday at 07:37 PM by Nine

[donnyh13]

@phedlund, I have a hunch I was wanting to pass by you. In LibreOffice Calc, when you enter the same (string?) value several times, it sometimes offers a "suggestion", where it has a black background suggested text. If you push the "right" key, this will accept the suggestion, but not move to the next cell, which may be what you are encountering? You could confirm this by manually typing Meijers, and see if it offers a suggested text? If so, I'm thinking it's your problem.

I could offer one suggestion, if you modify your entry method to send the Delete key once, then press tab once, instead of just "right", this will ensure no suggestion is accepted, and tab will move right once.

Edited Sunday at 01:42 PM by donnyh13

[phedlund]

Thank you so much donnyh13, That did the trick. I guess i never though of the suggestion filling the cell since  it was only one of the entries creating the problem.