Hello, you can try this : 1 - put your csv files in a folder ( ex : csv) 2 - create a new base database (.odb) (ex CsvFiles.odb) connect to an existing database (select Text/Csv) and choose the folder where the csv files are (Path to text files) and select the options for the csv. In the tables wind...

Hello, you can try something like this : Sub EnumAnnotations Dim oTextFields as Object, oTextField As Object CreateDbgDlg oTextFields = ThisComponent.getTextFields() for each oTextField in oTextFields if oTextField.supportsService("com.sun.star.text.textfield.Annotation") then DebugPrint &...

karolus wrote: ↑Wed Mar 06, 2024 5:26 am A bit »longwinded« isnt it?

no loop

Hello,
your problem seems to be , the one that i have had with the example of the new version of APSO using numpy. See the README.md ( or LISEZMOI.md in french) here.
Friendly, J.P

Hello, a new version of APSO (1.4.0alpha) has just been created. This corresponds to the branch APSO with_pip in the APSO gitlab repository. It is currently in the Alpha phase, which means that it is an experimental phase to see if the features introduced are operational and do not disrupt the rest ...

Hello, sorry but it seems that it is not possible to use Xconnection2 with Basic, see here maybe you can use python macro with socket module to read data from your network device. Example in a user python script file : # coding: utf-8 from __future__ import unicode_literals import uno import unohelp...

have a look to Interface Xconnection2 with the methods available and readSomeBytes

Hello VbandOoffice,
what is your code ?
Friendly, J.P

Hello, in LibreOffice since the version 7.2 you have the ScriptForge Library (included in the installation of L.O). In this library you have the Dictionary service . Exemple of use : Sub DicoTest() GlobalScope.BasicLibraries.loadLibrary("ScriptForge") Dim myDict As Variant, keys as Variant...

Hello, Maybe instead of a button, I can use a bitmap (an image of a button), but I have the same problem : I don't know how to display a bitmap in a cell of a GridControl. Here is a code derivated from a Bernard Marcelly code, to display bitmap on the first column of a grid control. Sub Main() xgrap...

ok, it seems to be good now, thanks

Villeroy in your file in the library Csv_Dump i only see the function getActiveCell (_helpers module) ???

Villeroy wrote: ↑Mon Jan 01, 2024 1:08 pm As a matter of fact, EasyDev imports wrong data. You need to add a post-processing routine.

May be but then show me a way as easy as Easydev to import csv in calc with a macro

Hello, And all those values are text. Just try to sum them up. If your csv files have quoted string and if the numbers are not quoted your can use the option quoting = CSV.QUOTED_NONNUMERIC (2) to import CSV. Number data will be Number in calc. You can also convert the data of the columns with strin...

Hello, Got "easydev" installed and created this Basic snippet: Sub Main util = createUnoService("org.universolibre.EasyDev") Dim Options(0) as new com.sun.star.beans.PropertyValue options(0).Name = "delimiter" options(0).Value = ";" path = "/tmp/test/0702...

Hello, I have found a workaround : call the python script only if thiscomponent is loaded and recalculate all when thisComponent is loaded : function getWorkingDirectory() getWorkingDirectory = "" if thisComponent.isLoaded then oScriptProvider = ThisComponent.getScriptProvider() oScript = ...

hello, Hello, I am trying to implement in BASIC : 1. open an impress document 2. add a slide 3. add a text on the slide 4. import a picture to the same slide Thank you hello, here is an example to do what you want to do : Sub TestPierre() Dim oPresDoc,oSlideList,oSlide,TxtShp,oImagen_obj,oPos,oSize ...

hello, i can debug a python script of libreoffice with pydev : Windows 10 - pydev 8.0 - LibreOffice 6.3 (python 3.5) - pydevd 2.0 - APSO 1.2.6.2 pydevd installed with pip install in pydev. i can't use breakpoints in events handler. To Debug in the event handler i use mri to see variables. Not workin...

hello,

brauart wrote:there is an old thread saying external ( i would also accept internal ) python debugging is possible

internal python debugging in LibreOffice/OpenOffice is possible with the APSO extension

Friendly, J.P

certainly but it will be more complicated or use a python macro

hello, with the extension EasyDev (see here ) it's easy :) : to compress some files and see the crc : REM ***** BASIC ***** Sub Tst_7za() util = createUnoService("org.universolibre.EasyDev") res = util.execute(Array("cmd.exe","/c","F:\7zip\7za.exe",_ "a&q...

hello, you can use the descriptor object to get the infos. Example : Sub RefreshDBRanges Dim oDBRangesEnum as Object Dim oNext as Object Dim Descriptor as Object oDBRangesEnum = thisComponent.DatabaseRanges.createEnumeration() While oDBRangesEnum.hasMoreElements() oNext = oDBRangesEnum.nextElement()...

hello,

Zizi64 wrote:OFF:

Jurassic Pork,

How you created that small sized animated gif picture above? It is very useful tool to demonstrate the implemented ACTIONS for the Forum users...

OFF for Zizi64 : with LiceCap a free software easy to use (windows & OSX).

Friendly, J.P

hello, It is important to note that it is written for Python 3 and therefore cannot be relied on to work with OpenOffice's Python 2.7. the last version of Easydev ( here ) can be installed with A.O.O 4.1.3. May be there are few functions not working because Python 2 in A.O.O . I have made a demo cal...