[Libreoffice-bugs] [Bug 126415] New: Seems to be missing API to get a cell from a row

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: hi-angel at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190715/c3ff2f83/attachment-0001.html>