# 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) >>> cell_range = row.getCellRangeByName(row.AbsoluteName) 4. Try to access the first cell in the given cell_range ## Expected There's a way to do it ## Actual There's no way to do it.
Created attachment 152798 [details] script to connect to LO server
I asked on IRC: turns out, a range has a function getCellByPosition(), whose addressing is relative to the range. E.g. if your range starts at 1,1 global position, then your_range.getCellByPosition(0,0) would refer to 1,1 cell in global coordinates.