Pergunte aqui

Perfil de mauricio - atividade

2020-10-23 18:32:49 +0100 Medalha recebida  Resposta legal (fonte)
2020-10-23 18:32:18 +0100 Medalha recebida  Resposta legal (fonte)
2020-10-23 18:31:39 +0100 Medalha recebida  Resposta boa (fonte)
2020-10-23 18:31:13 +0100 Medalha recebida  Resposta boa (fonte)
2020-10-23 18:30:44 +0100 Medalha recebida  Iluminado (fonte)
2020-10-23 18:30:44 +0100 Medalha recebida  Resposta boa (fonte)
2020-10-23 17:09:20 +0100 Respondeu uma pergunta ¿Como puedo agregar subprocess.call() dentro de una macro en Python?

No necesitas subprocess, puedes abrir el archivo que quieras con la codificación que quieras. with open(path, 'r', enco

2020-10-21 02:24:40 +0100 Respondeu uma pergunta libreoffice calc python macro data validity list and if statement

Property Type is Enum not String from com.sun.star.sheet.ValidationType import LIST def main(): doc = XSCRIPTCONTE

2020-10-21 02:11:34 +0100 Pergunta editada libreoffice calc python macro data validity list and if statement

libreoffice calc python macro data validity list and if statement I don't know how to over came this problem the validit

2020-10-20 23:16:59 +0100 Resposta editada Macro to manipulate an AutoFilter without a Database Range

ok, try: Sub main() sel = ThisComponent.CurrentController.Selection range = show_rows(sel) fd = range.creat

2020-10-20 23:04:48 +0100 Respondeu uma pergunta Macro to manipulate an AutoFilter without a Database Range

ok, try: Sub main() sel = ThisComponent.CurrentController.Selection range = show_rows(sel) fd = range.creat

2020-10-20 20:23:24 +0100 Resposta comentada ¿Cómo conectar LibreOffice Base con MySQL remoto? Resuelto

Por favor, marca el icono de ✓ para marcar como resuelto.

2020-10-20 20:15:34 +0100 Pergunta comentada Macro to manipulate an AutoFilter without a Database Range

Using the data ranges is simple and is the best way to use the filters. Just out of curiosity, why would you want to use

2020-10-19 18:56:42 +0100 Resposta comentada Macro Automatic filter or Standard filter in Calc.

Not, variables in code Basic work perfectly with not-English words

2020-10-19 17:24:35 +0100 Respondeu uma pergunta Macro Automatic filter or Standard filter in Calc.

I don't understand what not work. I attach file with code that work fine. C:\fakepath\ask.ods P.D. I need rewrite my

2020-10-19 17:14:51 +0100 Respondeu uma pergunta ¿Cómo conectar LibreOffice Base con MySQL remoto? Resuelto

Cuando inicias una nueva base de datos y le indicas que te conectaras con MySQL, te da la opción de meter los valores co

2020-10-11 01:42:49 +0100 Respondeu uma pergunta Macro Displays Err

It's estrange, I set separator argument in function a ",", but in your code work with ";" cell = workSheet.getCellRang

2020-10-11 01:23:11 +0100 Pergunta comentada Macro Displays Err

If formula not change... Why you set every execute?

2020-10-10 02:40:02 +0100 Pergunta comentada Can you help me understand this exception: type detection failed

Perhaps: file:///E:/Gem%20Invoices/BT1V000023.pdf"

2020-10-03 19:31:00 +0100 Respondeu uma pergunta macro para buscar en selección con python

Crea el descriptor a partir de la hoja, por ejemplo, la hoja activa: doc = XSCRIPTCONTEXT.getDocument() sheet = doc.Cur

2020-10-02 18:37:29 +0100 Resposta comentada How do I use LO's proxy settings in python scripts?

Check the mark (✓) to the left of the answer that solves your question.

2020-10-01 16:54:59 +0100 Respondeu uma pergunta How do I use LO's proxy settings in python scripts?

You can add access proxy in your script, look: https://stackoverflow.com/questions/22967084/urllib-request-urlretrieve-

2020-09-30 16:38:07 +0100 Pergunta comentada Refreshable Control in LibreOffice Writer

Maybe property "Tag", but, I don't now what is "content control".

2020-09-29 20:07:47 +0100 Respondeu uma pergunta Is the "create my first extension" tutorial up-to-date

Yes... Look example for most simple extension: <?xml version="1.0" encoding="utf-8"?> <oor:component-data xml

2020-09-29 16:32:08 +0100 Resposta comentada How to use VBA as a Calc library available to all documents

Yes, is better migrate macros from VBA to LOBasic.

2020-09-28 16:30:29 +0100 Resposta comentada Macro: Set transparency of selection

Please, check the mark (✓) to the left of the answer that solves your question.

2020-09-28 01:20:52 +0100 Respondeu uma pergunta Macro: Set transparency of selection

In impress, selection always is a group, so, you need access to first index. selection = ThisComponent.CurrentSelection

2020-09-23 20:13:59 +0100 Pergunta comentada Save to Google Drive Requires PIN. Work-arounds?

You already did a search? your question is frequently asked

2020-09-22 20:46:58 +0100 Respondeu uma pergunta Page Numbering Addon Error

I thing I fix it... Please, help me test it. Download and try: https://gitlab.com/mauriciobaeza/lo-page-numbering/-/r

2020-09-22 18:58:13 +0100 Pergunta comentada Page Numbering Addon Error

I can reproduce error in LO 7. I've clone extension, maybe I can fix it. P.D. Some time is better not comment.

2020-09-21 05:13:25 +0100 Pergunta comentada Anchor image to full page

Please, just asking once is enough.

2020-09-19 20:09:06 +0100 Respondeu uma pergunta Actualizado a v. 7 pero calc sigue sin poder guardar archivo remoto

He probado con mi FTP en una maquina virtual con Win 10 y se ha guardado correctamente. ¿Estas seguro que no es un pr

2020-09-19 06:19:14 +0100 Resposta comentada Actualizado a v. 7 pero calc sigue sin poder guardar archivo remoto

con un cliente estándar FTP... ¿te puedes conectar a tu servidor, con esos datos?

2020-09-18 00:11:57 +0100 Resposta comentada On-the-fly dialogs in LO Calc - text size on buttons?

Please, mark like correct with ✓

2020-09-17 18:01:19 +0100 Respondeu uma pergunta On-the-fly dialogs in LO Calc - text size on buttons?

You need properties: FontHeight = 25 FontWeight = 150 FontSlant = 1 FontHeight: Size font FontWeight: Bo

2020-09-17 01:25:14 +0100 Pergunta comentada print problem

Please, published your ask, only one time.

2020-09-17 00:09:14 +0100 Resposta comentada Load a Python Library with Portable Apps LibreOffice 5.4.2.2 on Windows 7?

Right, don't look at the date

2020-09-16 23:10:20 +0100 Respondeu uma pergunta Load a Python Library with Portable Apps LibreOffice 5.4.2.2 on Windows 7?

I don't have Win 7, but I test in Win 10 (virtual) with LibreOffice Portable 6.4 and I can install pip in and other libr

2020-09-16 19:09:38 +0100 Pergunta comentada Python script unable to print to console in libreoffice-gtk3

Is much better, if you show you code and error that you get. LO version too.

2020-09-13 19:05:38 +0100 Pergunta comentada Live link from Calc to Base

With Macros, maybe is possible, but... data in Calc generally are simple (String, Integer, Long), in DB could be more co

2020-09-12 21:49:27 +0100 Pergunta comentada Live link from Calc to Base

Yes, but the user say I am using Base with Calc as the data source (NOT Firebird, HSQLDB, etc.).

2020-09-12 21:19:40 +0100 Pergunta comentada Live link from Calc to Base

If you used Base, only Base, you used Firebird or HSQLDB, someone.

2020-09-12 19:50:29 +0100 Pergunta comentada Live link from Calc to Base

What Base? HSQLDB? Firebird? Others?

2020-09-12 05:51:13 +0100 Pergunta editada [RESUELTO] Anidar función SI con 3 condiciones

Anidar función SI con 3 condiciones Hola a todos, estoy descubriendo hace poco el libreoffice y este foro y la verdad e

2020-09-12 05:04:19 +0100 Pergunta editada Log in with Google Chrome

LOG IN WITH GOOGLE CHROME My default settings is Google Chrome but when I try to download Libre it tells me to go to the

2020-09-12 02:26:22 +0100 Pergunta comentada Log in with Google Chrome

Please, published you ask, only one time.

2020-09-12 02:25:53 +0100 Pergunta editada Log in with Google Chrome

LOG IN WITH GOOGLE CHROME My default settings is Google Chrome but when I try to download Libre it tells me to go to the

2020-09-11 21:53:12 +0100 Respondeu uma pergunta Trying to use Macro to Hide Subform on Chkbox value

This code work: Sub chk_show_subform_change(event) form = event.Source.Model.Parent show = CBool(event.Source.S