Pergunte aqui

Perfil de sdaau - atividade

2019-07-26 02:30:58 +0200 Medalha recebida  Pergunta famosa (fonte)
2019-03-12 00:05:19 +0200 Medalha recebida  Pergunta notável (fonte)
2019-03-12 00:05:19 +0200 Medalha recebida  Pergunta popular (fonte)
2019-01-15 11:51:45 +0200 Respondeu uma pergunta Python Libre office Uno: instantiating com.sun.star.drawing.LineStyle.SOLID?

Found it, here: https://docs.libreoffice.org/librelogo/html/LibreLogo_8py_source.html : from com.sun.star.drawing.LineS

2019-01-15 11:42:57 +0200 Pergunta comentada Python Libre office Uno: instantiating com.sun.star.drawing.LineStyle.SOLID?

crossposted: https://stackoverflow.com/questions/54197102/python-libre-office-uno-instantiating-com-sun-star-drawing-lin

2019-01-15 11:42:38 +0200 Perguntou Python Libre office Uno: instantiating com.sun.star.drawing.LineStyle.SOLID?

Python Libre office Uno: instantiating com.sun.star.drawing.LineStyle.SOLID? Using LibreOffice 6.0.7.3 00m0(Build:3) on

2019-01-15 09:17:06 +0200 Perguntou Select inverse and select same in LibreOffice Draw?

Select inverse and select same in LibreOffice Draw? There is already a Select All (Ctrl-A) command in LibreOffice Draw,

2018-12-27 16:37:08 +0200 Resposta comentada Read only content cannot be changed, no modifications will be accepted

Thank you - for me it was "Protect form" and "Cursor in Protected Areas"

2018-09-04 05:15:04 +0200 Medalha recebida  Autodidata (fonte)
2018-02-20 05:39:56 +0200 Medalha recebida  Pergunta famosa (fonte)
2017-12-15 12:56:06 +0200 Medalha recebida  Pergunta famosa (fonte)
2017-12-15 12:56:06 +0200 Medalha recebida  Pergunta notável (fonte)
2017-12-06 08:51:06 +0200 Medalha recebida  Pergunta popular (fonte)
2017-11-03 08:54:34 +0200 Medalha recebida  Pergunta notável (fonte)
2017-10-15 12:07:18 +0200 Medalha recebida  Pergunta popular (fonte)
2017-10-14 23:21:00 +0200 Resposta editada Python macro for Calc to correlate two columns with string data

Here is an example, you can save this as /usr/lib/libreoffice/share/Scripts/python/CorrelateCells.py on Ubuntu, so it sh

2017-10-14 23:20:14 +0200 Marcada como a melhor resposta Python macro for Calc to correlate two columns with string data

Just wanted to post this, since it took me forever to find the right commands; but to put it formally as a question: Assume in calc I have two columns of string data - one of them in column B, the other in say E, the space between them is assumed to be empty.

I can manually make a visual correlation of the values there as follows:

  • Select "original" cell in column E, Ctrl-C to copy
  • Find on which row is the same value in column B
  • Select the (empty) cell right next to the value on that row (so on found_row, column C)
  • Edit / Paste special ... , Options: Link
  • Select again "original" cell in column E; then
  • Tools / Detective / Trace Dependents

Obviously, this gets to be very long and tedious process as soon as you have more than four values to correlate.

Are there examples to automate this process in a, say, Python macro script?

2017-10-14 23:19:22 +0200 Respondeu uma pergunta Python macro for Calc to correlate two columns with string data

Here is an example, you can save this as /usr/lib/libreoffice/share/Scripts/python/CorrelateCells.py on Ubuntu, so it sh

2017-10-14 23:16:13 +0200 Perguntou Python macro for Calc to correlate two columns with string data

Python macro for Calc to correlate two columns with string data Just wanted to post this, since it took me forever to fi

2017-10-14 19:51:18 +0200 Medalha recebida  Pergunta popular (fonte)
2017-10-14 18:43:33 +0200 Resposta comentada Is there a LibreOffice BASIC (or other) REPL interactive shell?

Also, if you want to have scripts available in LO, in Ubuntu 14.04 they are in the directory /usr/lib/libreoffice/share/

2017-10-14 18:43:29 +0200 Resposta comentada Is there a LibreOffice BASIC (or other) REPL interactive shell?

Also, if you want to have scripts available in LO, in Ubuntu 14.04 they are in the directory /usr/lib/libreoffice/share/

2017-10-14 18:26:58 +0200 Resposta comentada Is there a LibreOffice BASIC (or other) REPL interactive shell?

Thanks for that @Ratslinger - I ended up finding the same post, which helped me come up with the session transcript I po

2017-10-14 18:26:07 +0200 Marcada como a melhor resposta Is there a LibreOffice BASIC (or other) REPL interactive shell?

I am on Ubuntu 14.04, LibroOffice 4.2.8.2. Does this - or any other later version - have a possibility for a BASIC REPL shell? That is, some form of a terminal program, where I could type stuff like rg = ThisComponent.CurrentSelection, and then inspect the variable rg?

I'm guessing, python could probably be used in this role somehow, instead of BASIC - note that in Ubuntu 14.04, I did:

sudo apt-get install libreoffice-script-provider-python

This installs a script /usr/lib/libreoffice/program/pythonscript.py, but if I run it, it fails:

$ python2.7 /usr/lib/libreoffice/program/pythonscript.py
Traceback (most recent call last):
  File "/usr/lib/libreoffice/program/pythonscript.py", line 19, in <module>
    import uno
ImportError: No module named uno

$ sudo apt-get install python-uno
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Package python-uno is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
  libreoffice-script-provider-python

E: Package 'python-uno' has no installation candidate

$ apt-show-versions -R python.*uno
python3-uno:amd64/trusty-security 1:4.2.8-0ubuntu5.1 uptodate
python3-uno:i386 not installed

So, there is only a python3 module of uno on this OS; still, even if I'd get an interactive shell with:

$ python3
Python 3.4.3 (default, Nov 17 2016, 01:08:31) 
[GCC 4.8.4] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import uno
>>> print(uno)
<module 'uno' from '/usr/lib/python3/dist-packages/uno.py'>
>>> dir(uno)
['Any', 'Bool', 'ByteSequence', 'Char', 'Enum', 'Type', '__builtin__', '__builtins__', '__cached__', '__doc__', '__file__', '__loader__', '__name__', '__package__', '__spec__', '_g_ctx', '_g_delegatee', '_impl_extractName', '_uno_extract_printable_stacktrace', '_uno_import', '_uno_struct__eq__', '_uno_struct__getattr__', '_uno_struct__init__', '_uno_struct__repr__', '_uno_struct__setattr__', '_uno_struct__str__', 'absolutize', 'createUnoStruct', 'fileUrlToSystemPath', 'generateUuid', 'getClass', 'getComponentContext', 'getConstantByName', 'getCurrentContext', 'getTypeByName', 'invoke', 'isInterface', 'os', 'pyuno', 'setCurrentContext', 'socket', 'sys', 'systemPathToFileUrl', 'unicode']
>>>

... I still don't know what (if anything) can I use to "get" a currently open document, or a selection in it - what could I use here?

2017-10-14 18:25:23 +0200 Respondeu uma pergunta Is there a LibreOffice BASIC (or other) REPL interactive shell?

Well, apparently there is a way with python3 on Ubuntu 14.04; you have to use (import) either the pyuno.so which is incl

2017-10-14 17:19:37 +0200 Perguntou Is there a LibreOffice BASIC (or other) REPL interactive shell?

Is there a LibreOffice BASIC (or other) REPL interactive shell? I am on Ubuntu 14.04, LibroOffice 4.2.8.2. Does this - o

2017-09-12 12:16:04 +0200 Resposta editada [Feature Request] Insert images into calc cells

I've been looking for something like this (inserting images in tables, and being able to sort rows) for a long time - an

2017-09-12 11:16:46 +0200 Resposta editada [Feature Request] Insert images into calc cells

I've been looking for something like this (inserting images in tables, and being able to sort rows) for a long time - an

2017-09-12 08:38:33 +0200 Respondeu uma pergunta [Feature Request] Insert images into calc cells

I've been looking for something like this (inserting images in tables, and being able to sort rows) for a long time - an

2017-03-24 11:54:53 +0200 Resposta comentada Exporting imported bitmap images from calc?

Excellent, that works - many thanks, @MikeKaganski !

2017-03-24 11:09:55 +0200 Perguntou Exporting imported bitmap images from calc?

I have tried to experiment with what I found in https://ask.libreoffice.org/en/questi...:

Insert images as background comments inserted into the cells. Comments "follow" cells when sorting (see ImageInCell.ods for testing). This solution also allows to display or not the images, cell by cell. Background's comment can not be defined when it is inserted. So we must first insert the comment then show it then right click > Area, Bitmaps tab> Import to select the image.

This is how the Area screen looks like:

area tab

... and here is the Bitmaps tab:

bitmaps tab

Notice here I have imported a bitmap called H37097, using the Import button. Unfortunately, there is no "Export" button.

So how could I get the original bitmap H37097 back? Is it saved somewhere in the system as a file - and if so, where should I look for it?

2017-03-24 11:02:45 +0200 Medalha recebida  Pergunta popular (fonte)
2017-03-01 16:48:17 +0200 Resposta comentada Format of time inside formula bar in Calc?

Fantastic, @pierre-yves samyn -> that worked great! First I selected the cell, right click Format Cells / Numbers and just changed Language to English (UK), whose default is HH;MM:SS and forced the formula bar to that display; then I reselected cell and applied HH:MM number format again, to have the same display as in OP - but the formula remained in 24h HH:MM:SS, which is great. Thanks for that, cheers!

2017-03-01 16:15:49 +0200 Perguntou Format of time inside formula bar in Calc?

Consider this example (LOffice/Calc v 4.2.8.2):

  • Open a new Calc document
  • select first cell, type in 12:31, then [ENTER]
  • Calc automatically shows it as 12:31:00 PM
  • Don't like this format, so select the cell, right-click, Format Cells... -> then choose Category: Time, Format: 13:37 (Format code: HH:MM), press OK
  • Now the cell itself is in 24h format

However, if I'd want to edit the cell from the formula bar, I can notice the format in the formula bar is still the same old one with AM/PM:

calc-screenshot-time

And this irritates me majorly, because I'm used to 24h display, and I tend to write say 13:00 in the bar (or cell), upon which I immediately get an error, since there is no 13 in 12h display.

So how can I change the default display of the formula bar to be 24h time display, so I can enter times like 13:00 or 19:12 without a problem?

2017-03-01 16:03:38 +0200 Marcada como a melhor resposta Deleting a table in Impress?

Same procedure as in http://ask.libreoffice.org/en/questio... :

Using LO Impress Version: 4.2.1.1, Ubuntu Natty 11.04. Start a new presentation, and then from main menu: Insert > Table. Choose 10 columns, 2 rows, then OK. When the table appears, go to the very first cell, type "blah blah blah" - I get something like this:

impress-table

The thing is - even if I select this table (it becomes all blue, and I have handles at end that resize it), I can NOT delete it?!! Why?

After it is selected, I try:

  • Hitting DEL - nothing happens, the table is still there
  • Main menu: Edit > Cut (there is no Delete option?), or via right-click context menu > Cut - nothing happens, the table is still there?

So how can I delete a table from an Impress slide?

2016-03-04 16:27:33 +0200 Marcada como a melhor resposta Please take away captcha when editing your own post

As the title says - please take away captcha when editing your own post. Why would I need captcha when editing my own post - to prevent spamming my own post? I don't get it - I make like 3-4 mistakes in the damn captcha before I can post my own edit to my own post, and each time, the entire damn page reloads before it tells me "An incorrect CAPTCHA solution was entered."