Xlsx Tool of Computer controller seems to transpose rows and columns.

[kita-sato]

Describe the bug

Xlsx Tool of Computer controller seems to transpose rows and columns.

To Reproduce
Steps to reproduce the behavior:

1. Enable Computer Controller
2. on Chat, Send 'Get the velue from A2 of ...FinancialSample.xlsx'
3. Allow execute
4. Returns the wrong value (it seems like B1's value)

Expected behavior
In step 4, returns the value of A2.

Screenshots
If applicable, add screenshots to help explain your problem.

:

Please provide following information:

• OS & Arch: [Ubuntu 24.04 x86]
• Interface: [UI]
• Version: [v1.7.0]
• Extensions enabled: [Computer Controller, Memory]
• Provider & Model: [OpenRouter - deepseek/deepseek-chat-v3.1]

[katzdave]

Looks like we have 2 potential fixes here.

I'm thinking we go with #4622 since it keeps the (row, column) convention for getting cells.

[kita-sato]

I agree with #4622 works fine as well. However, the umya_spredsheet API expects a tuple in col, row order, but it looks vise versa. so it might be a bit confusion when we consider extending it to retrieve cell formatting etc.

[kita-sato]

I'm afraid this issue remains unresolved.

I agree with #4622 works fine as well. ...
I'm sorry for my misunderstanding of the PR #4622.

It seems there is an issue with the test cases in PR #4622.
I added a comment to #4622.