Re: Need help on bookmark writter

2015-03-13 Thread Fernand Vanrie
Andrew Pitonyak schreef op 13/03/2015 om 12:55: Of course you can do it... Start by finding each bookmark to see how that is done. I don't remember off hand if you can then insert the image at the anchor point. You may need to use a dispatch to do it. something like | oMarks =

Re: Vraag ivm licenties

2014-12-01 Thread Fernand Vanrie
Michaël , totaal overbodig Openoffice en Libreoffice zijn GRATIS wellicht werkt het garagesysteem niet met opensource sofware, maar uitsluitend met MS ?? Beste, Ik werk momenteel bij een Autogarage en wij stappen over naar een ander systeem. Nu zijn wij van plan over te stappen op

Re: Creating Chart com.sun.star.chart.XYDiagram

2014-12-01 Thread Fernand Vanrie
Semen, I use a hidden calc doc to produce charts i hope this can help:: greetz Fernand Sub AreaChart(ChartDataArray(), LabelsArray(), CName as String, CSheet as String, Optional YPos as Integer,bOrders as boolean) Dim Length as Integer Dim oCharts Dim oRect as new

Re: Export logo in pdf

2014-08-22 Thread Fernand Vanrie
Vladislav , it depends in what format your logo is in a LO doc EPS = troubles SVG or any pixel format (jpg etc..) is ok greetz fernand Hello, Is there chance to improve ON in that way that logo of my firm can export in pdf file. This functionality is very important if we want to work

Re: Code snippets from oooforum in AOO website?

2014-06-05 Thread Fernand Vanrie
Hagar , others Many , many years ago i learned using the API and Basic from this forum Please copy not only the snipets , this forum gives tons of code examples and solutions not found in any other documentation , specialy the libraries made by Danny Brewer must been saved from distroying

Re: BASIC and UTF-8

2013-10-15 Thread Fernand Vanrie
Vladislav , In Belgium we have to deal with at least 2 languages Dutch and French who have also a lot non asci characters, we use extenifly Basic and some times hwe have to decode some text to UTF-8 who works and we decode the stream plese find below some code to encode a stream before

Re: Enhancement Request for PDF X/3 Export

2013-10-01 Thread Fernand Vanrie
Dave, Not realy, the newest worklows are RGB based, the convertion to CMYK is done after the PDF is made, make your RGB PDF's with Openoffice and let your print shop do the convertion to there own (machine depended) CMYK standards. Converting RGB to CMYK is not a straight forward, print

Re: A question about StarBasic

2013-09-02 Thread Fernand Vanrie
Hallo Peter , Hi Clarence, Am 02.09.2013 08:47, schrieb Clarence GUO: Hi~ I'm totally green at StarBasic and VBA. Now I have a question about CreateObject. I installed SAP and have below macros. Dim SapGuiAuto As Variant Set SapGuiAuto = CreateObject(SAPGUI) SAPGUI must be an ActiveXObject.

Re: Please confirm the following error in AOO 4.0

2013-08-18 Thread Fernand Vanrie
Jörg , For LO 4.0 Windows this is not happening, the toolbars are coming and going as expected AOO 4.0 prerelease Windows same behaviour the toolbars are coming and going as expected greetz Fernand From: Jörg Schmidt [mailto:joe...@j-m-schmidt.de] Sent: Friday, August 16, 2013 9:12

Re: Help with forms....so impossible to get with with openoffice!!!!

2013-08-15 Thread Fernand Vanrie
Dominic , the trick is to use the form explorer to add a extra subform to a form open first the forms toolbar hi I need help with openoffice base. i created a form with a subform using the wizard. i need more than one subform and dont know how to add additional subforms. i tried

Re: XHTML filter extensions

2013-05-06 Thread Fernand Vanrie
Andrea You worked on the export off the images, did also you modified the current behavior where the cropping and color changes are not exported ? When a image is cropped in a OO-doc then we must export not the original image but the image as we sea in the document. When needed I can past

Re: Writer suggestion

2013-03-31 Thread Fernand Vanrie
Donald , make 2 page styles - one with 4 columns and with next style no columns. - one with no columns and next style 4 columns swith from page style when wanted hope it helps Fernand I recently started a document with 4 columns. I then tried to have no columns on subsequent pages. As far

Re: questions about Base---do we need an embedded DB?

2013-03-26 Thread Fernand Vanrie
Ariel , Well no doubt this may start a rather heated discussion. One of my favorites quotes about Base is from Andreas Säger (villeroy on the forums): The difference between MS Access and Base amounts to several millions of Dollars and more than one decade of development time. Once you got

Re: questions about Base---do we need an embedded DB?

2013-03-26 Thread Fernand Vanrie
Mechtilde Hello, We need base with its easy way to connect to databases like mysql or postgresql especially under other OS's than Windows. we ourselves developed an extension based on this funktion for Law Offices in Germany There is no other free Office Suite which had a databse modul which

Re: [tdf-discuss] macro compatibility between LO and AOO?

2013-03-04 Thread Fernand Vanrie
On 4/03/2013 8:27, M. Fioretti wrote: On Mon, Mar 04, 2013 08:16:25 AM +0100, Fernand Vanrie wrote: 99% percent , changes comes and will come from incompatiliteis in de API. for now this is OK, small changes from version to version, but nothing who not can been repaired or handled

Re: High Vote Issues in Bugzilla

2013-02-06 Thread Fernand Vanrie
Ariel ? On Tue, Feb 05, 2013 at 07:29:56PM -0500, Rob Weir wrote: Current BZ version doesn't seem to allow display of vote totals in a view column. But I found a way to make an off-line report. So if any developer is looking for things that will make many users happy, here is a list of all

Re: Problem with combobox associated macro

2013-02-06 Thread Fernand Vanrie
Yessica? Hello, I have a macro in a form called Sales Payments. What the macro should do is this: when you select a customer from a combo box, take the current balance of the customer (which is in the the Customer table, saldo_actual field) and put it into a form field Payments Sales called

Re: Error in macro.

2013-02-03 Thread Fernand Vanrie
. If its run in a query, than it must also in the macro ? TRYE to run a other macro with only the statement with the id and the value hardcoded Regards, Yessica 2013/2/2 Fernand Vanrie s...@pmgroup.be Op 02/02/2013 07:04, Yessica Brinkmann schreef: Hello, I wanted to ask if I can please help

Re: Error in macro.

2013-02-01 Thread Fernand Vanrie
cliente SET cliente.saldo_actual = cliente.saldo_saldo_actual + oTotal.getCurrentValue() WHERE cliente.id_cliente= CInt(sCliente) oRes=oStat.ExecuteQuery(sSQL) End Sub Regards, Yessica 2013/1/31 Fernand Vanrie s...@pmgroup.be On 31/01/2013 13:33, Yessica Brinkmann wrote: Hello, Thank you

Re: Error in macro.

2013-02-01 Thread Fernand Vanrie
Ariel, Yessica, with OObase database, table and field names are case sensitive, their is no need to quote if: tables are lowercase and fieldnames uppercase. if quotes are used, then leave the dots out of the quotes sSQL= SELECT mybase.cliente.saldo_saldo_actual WHERE

Re: Error in macro.

2013-01-31 Thread Fernand Vanrie
Yessica, Hello, Yes, my controls now have the same name as the one I use to call the macro. Initially that was my mistake but I spent those mistakes. Now my problem is that I describe in my previous mail, on the subject of the combo box and customer_id and name. There is a key value associated

Re: Error in macro.

2013-01-31 Thread Fernand Vanrie
can not find the client code for the name either, if that's what you suggest because this name is not necessarily unique, only the customer id is unique. regards, Yessica 2013/1/31 Fernand Vanrie s...@pmgroup.be Yessica, Hello, Yes, my controls now have the same name as the one I use to call

Re: Error in macro.

2013-01-30 Thread Fernand Vanrie
Yessica nono , just check if the name of your controls are identical to what you call with getbyname (check uppercase, lower) greetz Fernand Hello, I think I can do this with string functions Left and Split but I do not know which is the separator for the ComboBox, for separating the

Re: desktop publishing

2012-11-22 Thread Fernand Vanrie
experience and work with writer. It sounds very interesting especially when you stay in one world, means no heavy exchange of MS formats. Thanks for sharing Juergen Am Donnerstag, 15. November 2012 um 09:34 schrieb Fernand Vanrie: Alexandro , On Tue, Nov 13, 2012 at 11:24 PM, Phillip Zadro ricaza1

Re: desktop publishing

2012-11-22 Thread Fernand Vanrie
Dave , Hi Phil, It is not completely impossible that an extension could be added to AOO to read and write Publisher files. It just takes one or two Java programmers with the time and interest. See [1] for where the effort could start. On Nov 22, 2012, at 8:36 AM, Fernand Vanrie wrote

Re: desktop publishing

2012-11-22 Thread Fernand Vanrie
Armin , Hi Fernand, On 15.11.2012 09:34, Fernand Vanrie wrote: Alexandro , ---snip--- Draw is a perfect Desktop publisher, is so perfect is compatible with other We uses exclusifly Writer (+ lot of basic macro's) to make over 8.000 full color magazine pages par year. This pages are all

Re: desktop publishing

2012-11-15 Thread Fernand Vanrie
Alexandro , On Tue, Nov 13, 2012 at 11:24 PM, Phillip Zadro ricaza1...@hotmail.com.auwrote: hi Is there any likelihood that OpenOffice will one day include a desktop publisher? There is only one thing that is stopping me from migrating completely from Microsoft Office to either OpenOffice