Re: Q: How to get the path of all opened spreadsheet documents

Zhang in basic i use this function Function TaskonDesktop(DocPath as String) as Boolean Dim oComponents as Object ' Search if one of the active Components ist the one that you search for oComponents = StarDesktop.Components.CreateEnumeration While oComponents.HasmoreElements

Re: Fwd: Re: Ask for help, Young developer request

probably you must use xStorable.store_As_URL hope it help Fernand On 24/02/2015 10:48, Bartłomiej Mikos PrimeSoft Polska wrote: Good Morning, I tried use XModifiable to close xlsx file, my method for making pdf looks like that: public void convertToPdf(String sourcePath, String destinyP

Re: LibreOffice crash

Piet, first i alayw provide some information when storing not a empty array a you did Thiscomponent.storeToURL( ConvertToURL(sfile), Array( MakePropertyValue("FilterName", "writer8", "ReadOnly", "False" )) and i allways do convertToURL(myURL) to been sure it's a correct URL

Re: Inserting Graphics in a Writer document

On 15/04/2015 16:00, Piet van Oostrum wrote: Hello, I am in the process of converting several Java LO programming examples to Python. My plan is to do all (or most) of them. Also I try to extend them. However I encountered some surprises. I converted LibreOffice4.4_SDK/examples/java/Text/Gra

Re: Uno sidebar API proposal

Laurent , More properties: Size , colors, background ? What about having the DialogControls available (ProgressBar, Watch, Images, listbox.) Greetz Fernand Hi all The libreoffice sidebar can be enhanced by adding Decks and Panels via extensions Unfortunatelly, there is no available UNO

Macro encryption different in between 4.2 and 5.1

A extension made with password protected Basic Libraries using LO 5.1 do not "load" properly the libraries under LO 4.2 We load a password protected library using the folowing code. If (Not GlobalScope.BasicLibraries.isLibraryLoaded("DbUtils")) Then GlobalScope.BasicLibraries.LoadLibrary("DbUt

Re: Macro encryption different in between 4.2 and 5.1

ctions and the sub's available in memory. Build in 4.2 and used in 5.1 gives no problems greetz Fernand On 11/07/2016 17:05, SOS wrote: A extension made with password protected Basic Libraries using LO 5.1 do not "load" properly the libraries under LO 4.2 We load a passwo

Re: Macro encryption different in between 4.2 and 5.1

On 12/07/2016 15:07, Michael Stahl wrote: On 12.07.2016 08:57, SOS wrote: sorry i mixed up the situation extension *Build in 4.2 and used in 5.1*: must be: extension *Build in 5.1 and used in 4.2*: the functions and Sub's in the libraries are not available, its only after opening the li

Re: Setting data in Writer chart from Basic

Did you tran Sent from my Samsung Galaxy smartphone.Did you translate the solution into basic code? Hi Fernand, thanks for the ideas. Sadly nothing you or anybody else posted helped. Finally I found this hack (here xChart has type Reference< XTextContent > xChart):   Reference < XEmbeddedObjec

Re: DPI and screen resolution on OS X

On 3/02/2016 3:55, Kohei Yoshida wrote: On Wed, 2016-02-03 at 10:52 +1100, Chris Sherlock wrote: The other question is: why would we not want to the actual DPI and screen resolution? My understanding is that, historically, the OS provided a function to query DPI but what gets returned from suc

Re: DPI and screen resolution on OS X

On 3/02/2016 11:32, Chris Sherlock wrote: On 3 Feb 2016, at 7:24 PM, SOS wrote: On 3/02/2016 3:55, Kohei Yoshida wrote: On Wed, 2016-02-03 at 10:52 +1100, Chris Sherlock wrote: The other question is: why would we not want to the actual DPI and screen resolution? My understanding is that

Re: DPI and screen resolution on OS X

On 3/02/2016 13:01, Chris Sherlock wrote: On 3 Feb 2016, at 10:35 PM, SOS wrote: On 3/02/2016 11:32, Chris Sherlock wrote: On 3 Feb 2016, at 7:24 PM, SOS wrote: On 3/02/2016 3:55, Kohei Yoshida wrote: On Wed, 2016-02-03 at 10:52 +1100, Chris Sherlock wrote: The other question is: why

Re: DPI and screen resolution on OS X

hallo Armin new comments inline on your remarks On 3/02/2016 14:10, Armin Le Grand wrote: Hi, comments inline Am 03.02.2016 um 12:35 schrieb SOS: On 3/02/2016 11:32, Chris Sherlock wrote: On 3 Feb 2016, at 7:24 PM, SOS wrote: On 3/02/2016 3:55, Kohei Yoshida wrote: On Wed, 2016-02-03 at

Re: Change in use of basic (uno) api since version 5.1?

Halo Winfried works as normal for me on (windows) LO 5.1.2.2 greetz Fernand On 31/05/2016 9:17, Winfried Donkers wrote: Hi all, I use basic scripts in our ERP system to open, create, modify, etc. Calc documents. This worked fine with LibreOffice for years till version 5.1. The LO-part of the

Re: Change in use of basic (uno) api since version 5.1?

Winfried, On 31/05/2016 11:46, Winfried Donkers wrote: Hi Fernand, works as normal for me on (windows) LO 5.1.2.2 greetz Fernand On The LO-part of the scripts start with the line Set oServiceManager = CreateObject( "com.sun.star.ServiceManager" ) Do you mean that the following vbsc

Re: alternatives to Firebird: sqlite

A disruptive solution could be to abandon the "embedded" idea and replace the current embedded engine by a new engine who use a spreadsheet file as a "editable" storage who is protected for accidental editing. Currently the use off a spreadsheet as database works fine en is fast enough for mo

Re: alternatives to Firebird: sqlite

On 8/03/2016 15:47, Dan Lewis wrote: On 03/08/2016 06:47 AM, SOS wrote: A disruptive solution could be to abandon the "embedded" idea and replace the current embedded engine by a new engine who use a spreadsheet file as a "editable" storage who is protected for

Re: alternatives to Firebird: sqlite

On 8/03/2016 17:33, Norbert Thiebaud wrote: On Tue, Mar 8, 2016 at 5:47 AM, SOS wrote: A disruptive solution could be to abandon the "embedded" idea and replace the current embedded engine by a new engine who use a spreadsheet file as a "editable" storage who is prot

Re: Writer Table Columns Access via Java API

hallo how it works with basic "iFotW" is the with off a collumn   Twidth = oViewCursor.TextTable.width     TTotalpercent = oViewCursor.TextTable.TableColumnRelativeSum     startcell = oViewCursor.cell.cellname     Kindex = asc(left(oViewCursor.cell.cellname,1))-65     tabstops = CurRow.Tab

Re: Two svg import filters

+1 for Thorsten For editing graphics there is Draw and we need a filter who makes the original graphic editable For publishing graphics there is Writer and we need a filter who just imports and do not touch the original graphic if the "one" filter can do both: OK Greetz Fernand ps. a fil

Re: Two svg import filters

On 16/12/2015 13:13, Dennis Roczek wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Hi SOS, Am 16.12.2015 um 10:54 schrieb SOS: Greetz Fernand ps. a filter who imports PDF in to Writer: +10 We do already such. File --> open --> PDF (open in writer) OK this is a filter who ope

Re: zip/unzip jar archive or add/remove file using a Basic macro?

Regina, found some basic code from Laurent Godard '* ' Zip Routines by Laurent Godard '* Sub ZipFolderToFile(source as string,

Is there a limit to the number of layers in a Writer Doc

Different objects (Images , Shapes...) can been moved (Arranged) back en forward in a Writer Doc. Bring to Front Bring forward Send Backward Send to back Our editors are some times confronted with a situation where Writer (after saving and reopening) lost the saved position (layer) of some ob

Re: Is there a limit to the number of layers in a Writer Doc

Chris Sherlock wrote: Hey guys, cc’ing in the mailing list :-) FWIW, can any developer point to the location of code that handles z-order within Writer drawings? I’m curious now myself! On 7 Jan 2016, at 3:54 AM, SOS wrote: On 6/01/2016 17:35, Chris Sherlock wrote: This is most certainly a bug.

Re: Remove ActiveX from LibreOffice

On 11/01/2016 20:32, Bryan Quigley wrote: I propose we add it to the 5.1 release notes (and 5.2 notes too) as: Intent to Remove ActiveX support in the 5.2 release. If this change negatively affects your Windows application please email the LibreOffice development list with your use case and pl

Re: Remove ActiveX from LibreOffice

s that ATL can do the same thing with or without ActiveX. https://en.wikipedia.org/wiki/Active_Template_Library Although as I mentioned previously I'm not much of a Windows developer. Thanks, bryan On Tue, Jan 12, 2016 at 3:25 AM, SOS wrote: On 11/01/2016 20:32, Bryan Quigley wrote: I pr

Re: Remove ActiveX from LibreOffice

On 13/01/2016 5:27, Bryan Quigley wrote: Hi Rick, ActiveX is deprecated by Microsoft and will be less useful (or not at all) on newer MS browsers. I'm unsure if it ever worked (or was supposed to) let you embed ActiveX controls into LibreOffice itself. Basic code running a Windows Mediaplaye

Re: swriter drawing

On 14/01/2016 3:00, meilin wrote: Hi! we can draw some shapes in writer doc such as rect, line, circle and so on. now i want to know how to draw these shapes to a virtual device. i have already saw some code about drawing,but it's too hard for me to understand. so i ask you for help, if you h

Re: Two svg import filters

From a users point of view: Inserting a SVG-image in Writer, Calc or Impress must been done "unchanged" because users will in 99% off all cases not edit a Image. Opening in Draw is a different game where in most cases the user has the intention tot edit a image and save back SVG or as a othe

Re: suggested method to create LibreOffice Extensions

Bernard Marcelly not only made Xray but also a exellent Extention Compiler writen in Basic and and adabtable to all your needs greetz Fernand On 16/11/2015 10:52, Thomas Krumbein wrote: Hey Andrea, hmm, I will do an

Re: Internal API for LO supported formats

found in the API samples from OO hope it helps greetz Fernand REM * BASIC * Sub Main oFF= createUnoService( "com.sun.star.document.FilterFactory" ) oFilterNames= oFF.getElementNames() ' Now print the filter names. ' For i = LBound( oFilterNames ) To UBound( oFilter

Re: Headless mail merge

Hallo, I can send the macro's for mailmerge (email & print) starting from selected variable data in the Beamer (Datasource Browser) and using a writer document as template Greetz Fernand On 4/7/2022 9:38 AM, mcmurchy1917techy wrote: Hi Marco I have a Base application with forms. On one f

Re: #tdf51510: Change the DPI to get better resolution, but failed the unit test

Hi, Tomaž, maybe you over looked that there is now a user defined property '*Image Preferred DPI*" for the document, so the resolution off any image must depend on this settings, who are standard 96 DPI. greetz Fernand On 18/08/2023 16:01, Lodev wrote: U ontvangt niet vaak e-mail

Re: #tdf51510: Change the DPI to get better resolution, but failed the unit test

that the SVG's are  not included in the "Graphic SIze Check.."? grtz Fernand On 22/08/2023 14:22, Tomaž Vajngerl wrote: Hi, On Tue, Aug 22, 2023 at 11:43 AM sos wrote: Hi, Tomaž, maybe you over looked that there is now a user defined property '*Imag

Re: #tdf51510: Change the DPI to get better resolution, but failed the unit test

Sorry to come back to this: every document has a property called "Image Preferred DPI" that can be used to represent the printing intentions of that document. Apparent dimensions are a result of deviding the available pixels in the Image by the print intentions . if the user like to send the d

Re: paste html using API

We do it with the functions below Function ClipboardAsText As String Dim oClip As Variant, oClipContents As Variant, oTypes As Variant Dim oConverter, convertedString As String Dim i As Integer, iPlainLoc As Integer iPlainLoc = -1 oClip = createUnoService("com.sun.star.datatransfer.clipboard.Sys

Re: Implementing interface for importing external data in calc

hallo, you can import data into a spreadsheet in 2 ways Fast = connecting the Calcdoc to a databasedoc and using buildin "Importer" service oDBRange.getReferredCells.doImport(oDesc()) Slow = import cell by cell using a dataset or a array fast function ConnectCalc_to_DBdoc(Optional sqlcalc as

Re: HTML import filter very (too) basic

Jens We build or proper HTML export, for email-html-body's, using the API and basic macro's, send me your odt file and we give it a try. You can then always adapt our macro's to the HTML output you prefere Greetz Fernand On 1/9/2019 7:06 AM, Noel Grandin wrote: Nobody owns it, and you're we

Re: need advices and help about Bookmark API.

Hallo, We did some test to use RDF (also Miklos his advice) to store some information about images in a Writerdoc, before we stored the information in the ImageObject , what was not a good idea. Greetz Fernand below the code who works well const BASE_TYPE = "http://PMGopmaak.writer/Allgraphics

Re: need help to insert an image with a caption with the Libo java API

On 2/13/2019 10:45 AM, Miklos Vajna via LibreOffice wrote: Hi, On Tue, Feb 12, 2019 at 09:27:15AM +, LORENZO Vincent wrote: I would like to add a caption, to an inserted image in a text document, but I don't find how to do that... Please do you have pointer

Re: API-CHANGE - dropping string properties which use vnd.sun.star.GraphicObject URL

Hallo Tomaž, We are heavy users off the Image API so lots off code repair ahead :-) Reading your blog comments, it is not clear for me where the Original ImageURL (URL adress on a server) could been stored. Can you add a aditional propterty to the graphicobject or to the graphic ? We mostly uses

Re: API-CHANGE - dropping string properties which use vnd.sun.star.GraphicObject URL

On 13/03/2018 13:23, Tomaž Vajngerl wrote: Hi, On Tue, Mar 13, 2018 at 8:54 PM, sos wrote: Hallo Tomaž, We are heavy users off the Image API so lots off code repair ahead :-) Reading your blog comments, it is not clear for me where the Original ImageURL (URL adress on a server) could been

Handling the sidbar with API and macro's

hallo, Any news on if and how we can handle the sidebar using the API and Macro's ? Thanks for any hints Fernand ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Handling the sidbar with API and macro's

Hallo Katerina,Thanks, Laurent Goddard pointed me already in this direction.Problem is the need of a extension to make the "mydeck" sidebar.Secondly I need also to create some private controls to call some macro,s from the sidebar. I mean: how to call a macro from the sidebar in the same way we

re: Usage of ActiveX in Libre Office

Bryan,Please clarify, will stuff like oShell = CreateObject("WScript.Shell") Still working after removing ActiveX?If not: then lots off API code will been broken and this will been a BIG regression ? Greetz Fernand Sent from my Samsung Galaxy smartphone. Original message From: B

Re: Usage of ActiveX in Libre Office

OkAny idea how we can test the behaviour with ActiveX removed ?GreetzFernand Sent from my Samsung Galaxy smartphone. Original message From: Bryan Quigley Date: 27/01/2017 18:09 (GMT+01:00) To: sos Cc: libreoffice@lists.freedesktop.org, libroffice@artavi.de Subject: Re

Can Java Scripts no longer been called from basic macro ?

Hallo, I need confirmation if a java script or macro can no longer (sinds (LO 4) been called from a basic macro who was running fine on LO 3 using 4.4 I get a error calling the script: oScript = oSP.getScript("vnd.sun.star.script:Library1\Macro1.js?language=JavaScript&location=user") the s

Re: Can Java Scripts no longer been called from basic macro ?

Oliver, sorry but still the same error An exception occurred Type: com.sun.star.script.provider.ScriptFrameworkErrorException Message: unsatisfied query for interface of type com.sun.star.script.provider.XScriptProvider!. - Windows 8 - het scripts are on the machine "C:\Program Files (x86)\Lib