pyoo

pyoo copied to clipboard

OSError: [Errno pyuno object

1

 Hi, I just installed pyoo and I can't create a desktop. Is it possible to help me please?

super-eye

pyoo method for obtaining cell address

1

Apologies if I have this wrong, but it seems that cells can only be referenced by index (eg, 0, 0, not A1). It should be possible to use the native...

bje-

Is there a way to input a multiline string value into a cell? Doing `cell.value = 'a\nb'` does produce a cell that seems to contain "ab". The newline is there...

tauferp

Inserting rows seems to break the indexing of later cell referencing. This sample code captures the problem: ``` import pyoo desktop = pyoo.Desktop(pipe="pyoo_pipe") doc_st = desktop.create_spreadsheet() sheet = doc_st.sheets[0] n...

brackleian

Error: com.sun.star.uno.RuntimeException: C++ code threw St9bad_alloc: std::bad_alloc

1

In Ubuntu 20.04.1 LTS x86_64 , LibreOffice Version: 6.4.5.2 I get an error when opening a file: ``` os.system('libreoffice --accept="socket,host=localhost,port=2002;urp;" --norestore --nologo &' ) time.sleep(3) desktop = pyoo.Desktop('localhost', 2002) desktop.open_spreadsheet('myfile.ods')...

roth-a

open_spreadsheet() returns invalid SpreadsheetDocument for a locked file

2

If I open e.g. "1.ods" in LibreOffice through mouse clicking then run ``` desktop = pyoo.Desktop(pipe='libreoffice') doc = desktop.open_spreadsheet('1.ods') ``` under the hood loadComponentFromURL() returns None and then SpreadsheetDocument(None) is...

n-epifanov

Question: Is there also a way to call a function from libreoffice?

2

I open a document using pyoo. If I then do a certain action, e.g. press a macro button, I would like to call a function in the running python process....

roth-a

Error when importing pyoo on alpine 3.9

1

` >>> import sys >>> sys.path.append('/usr/lib/libreoffice/program') >>> import pyoo Traceback (most recent call last): File "", line 1, in File "/usr/lib/python3.6/site-packages/pyoo.py", line 29, in FORMAT_TEXT = uno.getConstantByName('com.sun.star.i18n.NumberFormatIndex.TEXT') File "/usr/lib/libreoffice/program/uno.py", line...

dmarkey

Also enabled macros by default and added the option that the user can pass extra arguments to _open_url

roth-a

Add read only option to open_spreadsheet()

tsingletonacic