https://bugs.documentfoundation.org/show_bug.cgi?id=126415
Bug ID: 126415
Summary: Seems to be missing API to get a cell from a row
Product: LibreOffice
Version: 6.2.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: sdk
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: hi-an...@yandex.ru
Created attachment 152795
--> https://bugs.documentfoundation.org/attachment.cgi?id=152795&action=edit
connect to LO server running
A "TableRow" object doesn't seem to have any methods to access cells it stores.
There's "getCellByPosition()", however this method accepts a row index, and is
probably present in TableRow by mistake (should I report a bug on this?).
Feel free to close this report if I'm wrong, I just spent some hours trying to
understand how to loop over rows in a spreadsheet, and at this point I admit I
am lost.
# Steps to reproduce
1. Execute: soffice --calc
--accept="socket,host=localhost,port=2002;urp;StarOffice.ServiceManager"
2. Download the attachment (python script to connect to LO)
3. In directory with the script run `python`, and execute:
>>> exec(open("./connect-to-lo.py").read())
>>> row = model.CurrentController.ActiveSheet.Rows.getByIndex(0)
4. Now, try to get a cell from the row.
## Expected
There's a way to do it.
## Actual
Except the mentioned "getCellByPosition()" that is irrelevant to a row there
doesn't seem to be a way to do it.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs