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

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 '*Image Pre

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

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 =

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

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 =

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: 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

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 =

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

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 <s...@pmg.be> 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

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

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 <bryan.quig...@canonical.com> Date: 27/01/2017 18:09 (GMT+01:00) To: sos <s...@pmg.be> Cc:

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:

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 library

Re: Macro encryption different in between 4.2 and 5.1

functions 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 password pro

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

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

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: 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

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: 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

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=user") the script is

Re: alternatives to Firebird: sqlite

On 8/03/2016 17:33, Norbert Thiebaud wrote: On Tue, Mar 8, 2016 at 5:47 AM, SOS <s...@pmg.be> 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"

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

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

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

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 <s...@pmg.be> 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 resolutio

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 <s...@pmg.be> wrote: On 3/02/2016 11:32, Chris Sherlock wrote: On 3 Feb 2016, at 7:24 PM, SOS <s...@pmg.be> wrote: On 3/02/2016 3:55, Kohei Yoshida wrote: On Wed, 2016-02-03 at 10:52 +1100, Chris Sh

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 <s...@pmg.be> wrote: On 3/02/2016 3:55, Kohei Yoshida wrote:

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 <

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

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 <s...@pmg.be> wrote: On 11/01/2016 20:32, Bryan Q

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

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

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

herlock <chris.sherloc...@gmail.com> 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 <s...@pmg.be> wrote: On 6/01/2016 17:35

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

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

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

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: 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

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,

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(

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: 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

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

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 (your

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