Re: [libreoffice-users] Base Form Q: Default a field from a macro

2013-02-07 Thread Fernand Vanrie
Adam , do the macro run by a event from the field sub runfromevent(oevnt) ' the field ofield =oevnt.source etc. hope it helps fernand Is it possible to assign a form control [field] a default value from a Macro? I need to have a field that defaults to a value generated by calling a

Re: [libreoffice-users] How do I change the case of a field in writer?

2013-02-07 Thread Fernand Vanrie
paul, add a style to the text in the field I'm using writer to import data from a database. Can I set the format on the field so some entries will be all caps and some will only capitalize the first letter of a word? I want to insert names from the database. Most entries I want to have

Re: [libreoffice-users] MySQL on a network

2013-02-17 Thread Fernand Vanrie
Heinrich , fine, in the past there where some issues about remote connections, but how do you manage the security of your connection greetz Fernand On Sat, 16 Feb 2013 23:44:09 +0100, Dan Lewis elderdanle...@gmail.com wrote: I can connect to the MySQL server (5.5) on the same

Re: [libreoffice-users] head format does not change

2013-02-18 Thread Fernand Vanrie
Jaap , probably, the depends on property of the format is involved in this behaviour hope it helps Fernand In a document is a Head 1 preformated and in Arial font Now I come across a Head 1 in Verbena. So I do change the Head 1 into an other format and than back to Head 1 Now I expect

Re: [libreoffice-users] MySQL Native Connector for 32 bit LibreOffice on Ubuntu 12.04

2013-02-22 Thread Fernand Vanrie
Heinrich , Trie to install the connector with the latest working version then update this version to 4.0 and with a bit of luck you end up with a working connector in 4.0 hope it helps BUT: we need to find a solution for this problem, for aOO there is also a connector, it works fine

Re: [libreoffice-users] Going to an OnExit' Routine On Dialog Button Event

2013-02-24 Thread Fernand Vanrie
Op 24/02/2013 15:32, Andrew Douglas Pitonyak schreef: On 02/23/2013 03:24 AM, Hal Vaughan wrote: I have a macro in LO BASIC that sets up a dialog, then, instead of executing it, I do: oDialog.setVisible(TRUE) This dialog box contains a progress bar and, while testing it, I realized it's

Re: [libreoffice-users] oooforum.org

2013-02-25 Thread Fernand Vanrie
Andrew , when this site is gone then its also a terible lost of knowledge and code examples for both communities, Greetz Fernand On 02/24/2013 10:17 PM, Tim Lloyd wrote: I am just flicking through the LO4.0 getting started guide and there is a reference to http://www.oooforum.org/. When

Re: [libreoffice-users] Is LO BASIC Limited to Only 1 Dialog Box at a Time?

2013-02-28 Thread Fernand Vanrie
Hal , It can be done! I don't know if it's dangerous or not, but the link on oooforum.org (when it's up) either had a link to another post or I found this by searching for modal dialog on that site. This example (http://www.oooforum.org/forum/viewtopic.phtml?t=8481) uses AWT, going through

Re: [libreoffice-users] Re: Vector Graphics in PDF

2013-02-28 Thread Fernand Vanrie
On 28/02/2013 23:27, Berengar Lehr wrote: So thank you for your answeres! What I do is automatically produce PDF reports using xml-templates, I'll just write down, what I do: 1. ODT --extract-- multiple XML files 2. content.xml --via python-script-- content.xml.template 3. content.xml.template

Re: [libreoffice-users] BasIe - connecting through JDBC

2013-03-03 Thread Fernand Vanrie
Heinrich, diid you trie the native aOO connector made by Ariel C.H. it seems it works fine on LO 3.6 nut alos no longer on 4.0 Ariel told me his extension can been recompilid using the SDK (without the whole code base) but i simply do not know how to this. My compagny is willing to pay for

Re: [libreoffice-users] BasIe - connecting through JDBC

2013-03-03 Thread Fernand Vanrie
Dan , Any interest to build a Windows Version ? My compagny is willing to provide the hardware an pay for your time ? Greetz Fernand On 03/02/2013 08:10 AM, Heinrich Stoellinger wrote: Hello, Seeing as the Native MySQL-connector seems to be a difficult birth - I tried both ODBC and JDBC

Re: [libreoffice-users] Re: Vector Graphics in PDF

2013-03-03 Thread Fernand Vanrie
Op 03/03/2013 23:09, Ferry Toth schreef: Berengar Lehr wrote: Hy, I'm asking if anyone could provide me with a list of vector graphics formats that can be used in ODT _and_ that will be exported as vector graphic. SVG e.g. is not a valid example: while it can be used in ODT, SVG will be

Re: [libreoffice-users] Re: BasIe - connecting through JDBC

2013-03-04 Thread Fernand Vanrie
Heinrich , Sinds we uses for all ore tables UTF-8 we (never) have encoding problems using OO via ODBC Hello Alex, I create ALL tables with . . CHARACTER SET latin1 COLLATE latin1_german1_ci . This should obviously allow for o-Umlaut etc In LO I specify ISO-8859-15/EURO for the codepage

Re: [libreoffice-users] Re: BasIe - connecting through JDBC

2013-03-04 Thread Fernand Vanrie
On 4/03/2013 10:49, Fernand Vanrie wrote: Heinrich , oeps typo : read : Sinds we uses for all our tables UTF-8 we have no encoding problems using OO via ODBC Sinds we uses for all ore tables UTF-8 we (never) have encoding problems using OO via ODBC Hello Alex, I create ALL tables

Re: [libreoffice-users] Re: BasIe - connecting through JDBC

2013-03-04 Thread Fernand Vanrie
On 4/03/2013 11:02, Alexander Thurgood wrote: Le 04/03/13 10:55, Fernand Vanrie a écrit : Hi Fernand, On 4/03/2013 10:49, Fernand Vanrie wrote: Heinrich , oeps typo : read : Sinds we uses for all our tables UTF-8 we have no encoding problems using OO via ODBC Yes, I have had better

Re: [libreoffice-users] Importing PDF problem

2013-04-06 Thread Fernand Vanrie
Op 05/04/2013 22:18, David Ronis schreef: I'm currently working on a large project that requires me to import many documents from my colleagues, some in word or PDF formats, into a single file. Libreoffice doesn't work if I try Insert-File... on a PDF file (I get an error popup saying Error

Re: [libreoffice-users] gettextfields

2013-05-08 Thread Fernand Vanrie
Vieri , pleasqe find some working code below hope it helps: so every field has a Placeholder property who correspondents with the data who commes here from a beamer Dim aTextFields as Object Dim i as integer Dim CurElement as Object 'xray.xray oDocument

Re: [libreoffice-users] gettextfields

2013-05-10 Thread Fernand Vanrie
On 9/05/2013 9:13, Vieri wrote: --- On Thu, 5/9/13, mcmurchy1917-libreoff...@yahoo.co.uk mcmurchy1917-libreoff...@yahoo.co.uk wrote: Hi Vieri The form you've created contains a set of controls of which one or more of them are of the Text box variety. You may also have other controls on

Re: [libreoffice-users] first article on LibreOffice/OpenOffice little known features online

2013-05-24 Thread Fernand Vanrie
Marco, There is a lot more: - With SVG native handled + some macro's + the PDF export, LO/OO is now a full DTP production tool - Using the Elaix extension make it also a full EPUP/HTML5 production tool Greetz Fernand On 24/05/2013 13:54, M. Fioretti wrote: Greetings, you may remind that

Re: [libreoffice-users] Creating EPUB e-books

2013-05-31 Thread Fernand Vanrie
James , there is also a exellent extension around, eLAIX , who creates from Writerdocs , Elaix learning modules but also ePUB documents There has been some discussion about creating EPUB e-books from OpenOffice and LibreOffice. One method I recently came across is to use Sigil to create the

Re: [libreoffice-users] Creating EPUB e-books

2013-05-31 Thread Fernand Vanrie
On 30/05/2013 23:09, Daniel A. Rodriguez wrote: There has been some discussion about creating EPUB e-books from OpenOffice and LibreOffice. One method I recently came across is to use Sigil to create the EPUB from HTML. OpenOffice and LibreOffice can save in HTML format, which can then be used

Re: [libreoffice-users] Re: Book-writing with Writer

2013-07-10 Thread Fernand Vanrie
On 10/07/2013 5:20, Urmas wrote: Pablo Dotro: I am beginning a large writing project, that will most probably take the form of a self published, free ebook. please dowload the eLAIX extension, there is a manuel for how to start a ebook with LO And while I have created very long, complex

[libreoffice-users] Need Confirmation: since 4.1 MySQL datetime fields are wrangled in LO base tables

2013-07-10 Thread Fernand Vanrie
I connect with the Windows Native MYSQL connector (compiled against 4.0) to a MySQL database since 4.1 all DateTime fields are wrangled when showing a table in LO base, when changing the values using LO then they are also wrangled in the original MySQL table date values seems to be OK

Re: [libreoffice-users] Book-writing with Writer

2013-07-12 Thread Fernand Vanrie
Virgil , the secret of styles for ebook publishing is the OutLineLevel you can uses any style but change your paragraph styles to the correct OutlineLevel TITEL = OutlineLevel 1 Subtitel = OutlineLevel 2 Subsubtitel = OutlineLevel 3 etc...to 9 Wolfgang, I

Re: [libreoffice-users] Base: In basic, how do you open a form to a particular record number?

2013-08-06 Thread Fernand Vanrie
Jason , on the website from Roberto Benitez http://www.baseprogramming.com/ you wil find what you are looking for ! This is some example code I'm using that opens a form. How do set set the current record number of the newly opened form from the basic script. Sub OpenDataEntry(oEvent As

Re: [libreoffice-users] Base: In basic, how do you open a form to a particular record number?

2013-08-07 Thread Fernand Vanrie
, Aug 6, 2013 at 10:05 AM, Fernand Vanrie s...@pmgroup.be wrote: Jason , on the website from Roberto Benitez http://www.baseprogramming.com/ you wil find what you are looking for ! This is some example code I'm using that opens a form. How do set set the current record number of the newly opened

Re: [libreoffice-users] Problem with eLAIX extension on LibO 4.0

2013-08-08 Thread Fernand Vanrie
Op 08/08/2013 14:26, Joaquín Lameiro schreef: i would start with opening de basic code and iliminate the error handlers, change On Local Error Goto ErrorHandler to rem On Local Error Goto ErrorHandler so on a error you can see on wath code line there is a error occuring hope it helps

Re: [libreoffice-users] Book-writing with Writer

2013-08-15 Thread Fernand Vanrie
trie the Elaix extension On 13/08/2013, Virgil Arrington cuyfa...@hotmail.com wrote: I just did a couple experiments with LO and Writer2epub. I tried converting the entire 390 page Getting Started book to EPUB. It choked. I then tried doing the same with just the 18 page introduction. Same

Re: [libreoffice-users] LO WRITER BASIC: insert an image, put a drawing-text on top and jump to next page

2013-08-15 Thread Fernand Vanrie
Dag Alain , vlaming ja ! i see you use only the dispatcher you write your macro, some actions can not been recorded, what not mean there is no dispatch action for it, there is a list for all dispatch actions http://hermione.s41.xrea.com/pukiwiki/index.php?OOoBasic%2FGeneric%2Fcommands_2.2.1

Re: [libreoffice-users] Re: SQLException when using ADO driver and prepared statements

2013-08-19 Thread Fernand Vanrie
hei, did some test in the past and found only troubles using ADO, for a MS SQL server ODBC is the best option Replying to myself to add that this is with LibreOffice 4.1.0.4 on Windows XP. -- View this message in context:

Re: [libreoffice-users] Macro code to highlight a field on a Form

2012-07-02 Thread Fernand Vanrie
Marion Noel , If you do some googling, you will find many examples how to handle a com.sun.star.awt.UnoControlNumericFieldModel or a com.sun.star.awt.UnoControlEditFieldModel Hope it helps Fernand Hi Tom, Thanks for the suggestion - Gnu Cash looks to be very comprehensive, but I would

Re: [libreoffice-users] LOW: uncontrollable line spacing in PDF output???

2012-07-04 Thread Fernand Vanrie
Rogier , We produce about 8000 full color magazine pages a year using OO-LO on Windows, without any PDF anomalies - are you using Windows ? - what Fonts ? you can also send some problematic pages to my personal emailadress Groeten Fernand Back in 2002 I produced a book, going straight to

Re: [libreoffice-users] LOW: uncontrollable line spacing in PDF output???

2012-07-05 Thread Fernand Vanrie
of imperfection with the process of switching fonts somewhere in mid project. Unclear if it is substantial enough to rise to the level of a reportable issue. It probably is, but I would not know how to duplicate it. On Wed, Jul 4, 2012 at 3:37 AM, Fernand Vanrie s...@pmgroup.be wrote: Rogier , We

Re: [libreoffice-users] LOW: uncontrollable line spacing in PDF output???

2012-07-06 Thread Fernand Vanrie
are editing a manuscript, and I never had such problems in the past with OO in 2002, with a book that certainly went through just as many revisions. I am clueless anymore how to fix it. If I fix one, another one pops up... On Thu, Jul 5, 2012 at 1:12 PM, Fernand Vanrie s...@pmgroup.be wrote

Re: [libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)

2012-07-20 Thread Fernand Vanrie
Johnny, I suppose you have to run the check 2 Times, first SearchType = 0 here we find if there is a formula use . then SearchType 1 on the found area the SearchString has a different meaning , depending on the .SearchType = 1 then the SearchString is the is the result of the formula or the

Re: [libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)

2012-07-20 Thread Fernand Vanrie
Op 20/07/2012 13:31, Johnny Rosenberg schreef: 2012/7/20 Fernand Vanries...@pmgroup.be: Johnny, I suppose you have to run the check 2 Times, first SearchType = 0 here we find if there is a formula use . What do you mean? Use . as the search string? Regular expressions set to what? True?

Re: [libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)

2012-07-21 Thread Fernand Vanrie
Johnny, found this stuf on a French forum: Sub PysTests dim PysSel as object, FormulaRetour, EmptyRetour as object dim PysFlag PysFlag = com.sun.star.sheet.FormulaResult.VALUE + com.sun.star.sheet.FormulaResult.STRING + com.sun.star.sheet.FormulaResult.ERROR PysSel =

Re: [libreoffice-users] How to determine FilterName of loaded document?

2012-08-29 Thread Fernand Vanrie
On 29/08/2012 17:00, Walther Koehler wrote: Hi, how to find out the FilterName of a loaded document? (other than try to save under and look what is marked) I would like to find it by a Basic Makro, but didnt find a hint even in Andrew Pitonyaks marvellous guide. a sequelae: Does anybody know,

Re: [libreoffice-users] Adding .pdf Images to Document

2012-11-20 Thread Fernand Vanrie
Rich , .pdf is not a accepted graphic format for LO or OO surly we urgent need that... in the mean time convert the PDF images to SVG (using Inskape) and then place the SVG in your writer Doc. For non-complex PDF files it works fine. I need to provide a client with a Word version of a

Re: [libreoffice-users] Adding .pdf Images to Document

2012-11-21 Thread Fernand Vanrie
Steve , I use a lot of EPSs in my documents. We did also, but PostScript is slowly dying because of no transparency. LO and OO handles well EPS, but you need a eps with previeuw to show a bitamp representation off the content. Making a native-PDF (using PDF-export) export the bitamp

Re: [libreoffice-users] LO Base Colour settings in Form design.

2012-11-23 Thread Fernand Vanrie
Ian , When using macro's to add the data to your form it can easly been done, without macro's ?? Greetz Fernand Hi All I have a Membership Database running on MySQL 5.1 with an LO Base Front end Ver 3.6.2.2. All running on PCLOS 2012. My Members fall into two or three different

Re: [libreoffice-users] LO Base Colour settings in Form design.

2012-11-23 Thread Fernand Vanrie
Ian , or maybe just place a listener on the filed who contains Cat data. on changing the field content place a event who run a macro: The eventlistner produce a oEvent object who contains the source = field object and the source.context = Form object IF Oevent.source.model.text = abc THEN

[libreoffice-users] LibreOffice no longer works with Windows 1252 encoding ?

2012-12-20 Thread Fernand Vanrie
Maybe not the right forum ? but is this new encoding behaviour intentional or a issue ? since 3.6.3 LO no longer shows correctly non-standard-ascii characters with text imported from a database using Windows 1252 encoding(during the import), UTF-8 encoding now works fine but gives problems when

Re: [libreoffice-users] Re: [Writer] Regular expressions

2013-01-09 Thread Fernand Vanrie
gordom, a macro can do the job , have a look at the standard LibreOffice macro's you find in every document) you can also tranfer the text to a spreadsheet and use formula like if(left(cellstring,3) = 'set:');'nothing', cellstring) then recopy to spreadsheet to a writerdoc and replace

Re: [libreoffice-users] polish characters PDF problem

2013-01-11 Thread Fernand Vanrie
Gerard , maybe you are hit with the problem ( found for Windows XP) that LO only UTF-8 encoding support some fonts do not have this UFT-8 code page, so start to trie to use a font who is 100% compatible with UTF-8 or trie later Windows versions (7-8) hop it helps Fernand Hi everybody i

Re: [libreoffice-users] Re: MySQL-Native Connector for 4.0

2013-01-15 Thread Fernand Vanrie
Alexander , Connector works fine for LOdev4.0 and windows XP Hi Tom, I would not advise attempting to build it on XP or anything Windows unless you really know what you are doing. Building on Linux is far easier on the whole, as everything is more or less either pre-installed, or easy to add

Re: [libreoffice-users] Re: MySQL-Native Connector for 4.0

2013-01-15 Thread Fernand Vanrie
On 15/01/2013 17:36, Alexander Thurgood wrote: Le 15/01/13 16:39, Fernand Vanrie a écrit : Hi Fernand, Connector works fine for LOdev4.0 and windows XP Thanks for the info. Do you build it yourself, or did you get it from the AOO project ? i still use a extension MySQL Connector 1.0.1 made

Re: [libreoffice-users] MySQL-Native Connector for 4.0

2013-01-17 Thread Fernand Vanrie
Michael , others, the MySQL native connector is installing and working well on LO 4.0 dev with Windows XP but as Michael says, not on LO 4.0 rc1 with Windows 7 (LO 3.6 is working) and also NOT on LO rc1 with Windows 8, failed to install due to some pathsettings. the latest Connector

Re: [libreoffice-users] MySQL-Native Connector for 4.0

2013-01-17 Thread Fernand Vanrie
Who is filling the issue ? Michael , others, the MySQL native connector is installing and working well on LO 4.0 dev with Windows XP but as Michael says, not on LO 4.0 rc1 with Windows 7 (LO 3.6 is working) and also NOT on LO rc1 with Windows 8, failed to install due to some

[libreoffice-users] Need comfirmation about no function of Modeless Dialogs in 4.0

2013-01-29 Thread Fernand Vanrie
We uses the Basic codelines below to make Modeless Dialogs, sinds 4.0 we end up with a non-visible window is this a Windows only problem or a more general regression due to changes in the API ?, it was working until 3.6.4 Windows Greetz Fernand Sub Main oDoc = ThisComponent oParentFrame

Re: [libreoffice-users] Need comfirmation about no function of Modeless Dialogs in 4.0

2013-01-29 Thread Fernand Vanrie
;-) Chhers, Leif Lodahl 2013/1/29 Fernand Vanrie s...@pmgroup.be We uses the Basic codelines below to make Modeless Dialogs, sinds 4.0 we end up with a non-visible window is this a Windows only problem or a more general regression due to changes in the API ?, it was working until 3.6.4 Windows Greetz

Re: [libreoffice-users] Incorrect handling of time values in O 4.1.1

2013-09-09 Thread Fernand Vanrie
Heinrich , same sort of problems with Windows, datetime values are scrambled sinds 4.1 it is still not defined if this problem is comming from the MySQL Connector or its due to how do you connect to your MySQL server ? Hello, I have just filed a bug report regarding erroneous handling

Re: [libreoffice-users] Incorrect handling of time values in O 4.1.1

2013-09-10 Thread Fernand Vanrie
connector to do further tests Regards H.S. On Mon, 09 Sep 2013 19:30:24 +0200, Fernand Vanrie s...@pmgroup.be wrote: Heinrich , same sort of problems with Windows, datetime values are scrambled sinds 4.1 it is still not defined if this problem is comming from the MySQL Connector or its due

Re: [libreoffice-users] Macro from command line: ThisComponent.CurrentController not found

2013-09-17 Thread Fernand Vanrie
On 16/09/2013 18:29, greyspammer wrote: Hello! I have a macro which I want to be executed whenever a Writer document is being converted to a PDF. So I wrote my macro and assigned it to the appropriate event. And it works. At least, from within a running GUI-Session. If I try to do the

Re: [libreoffice-users] Testing when developing LO Base Applications

2013-09-23 Thread Fernand Vanrie
On 23/09/2013 3:07, James B. Byrne wrote: I am tasked with writing a quick fix replacement for a very old dbase application running on WinXP. I am considering using LO Base with ODBC(SDBC?) to connect to a Postgresql-9.1 RDBMS hosted on a Linux server. Assuming that I can get the connectivity

Re: [libreoffice-users] MySQL Native C Connector Extension for Linux 32, 64 and OSX 64 bit versions of LibreOffice - built against future LO 4.2

2013-10-14 Thread Fernand Vanrie
On 14/10/2013 17:30, Heinrich Stoellinger wrote: Hi Alex, Thanks for your work! However, the connector you built does unfortunately NOT work on my Linux-Mint-15-LO-4.1.2.3,MySQL 5.5 system. The one that comes integrated with LO 4.1.2.3 works in principle, but garbles up is this due to the

Re: [libreoffice-users] Time Values - LO 4.1.3.2

2013-10-29 Thread Fernand Vanrie
Heinrich , Lionel is working on it he changed the internal MariaDB code back to the MySQL code i am not sure if this changes go's into the version you uses ?, on Windows we have the same situation, when using ODBC no date problems and Jésús is working on a new Windows compile. Greetz

Re: [libreoffice-users] Time Values - LO 4.1.3.2

2013-10-29 Thread Fernand Vanrie
to the JDBC connector ? Regards H.S. On Tue, 29 Oct 2013 09:20:18 +0100, Fernand Vanrie s...@pmgroup.be wrote: Heinrich , Lionel is working on it he changed the internal MariaDB code back to the MySQL code i am not sure if this changes go's into the version you uses ?, on Windows we have

Re: [libreoffice-users] Base/MySQL use

2013-10-30 Thread Fernand Vanrie
Taylor , We are Using LO as frontend for a mySQL server, up to 50 users acces te data using LO. I build my own FrontEnd using Dialogs an basic bundled in a extension to acces the data using Basic macro's and the native mySQL connector , works also from home using as VPN connection to the

Re: [libreoffice-users] BASE refuse TIMESTAMPDIFF syntax

2013-11-19 Thread Fernand Vanrie
polch, dit you try this in native' mode (LO just send the statement) Hi. I would like to build an SQL request that use TIMESTAMPDIFF. As i encounter some problems of rejected syntax i try a minimal example in sql editor : SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01') But either with

Re: [libreoffice-users] Second opening of Database

2013-12-03 Thread Fernand Vanrie
On 3/12/2013 17:25, Bob Lineker wrote: I am Running Libreoffice under windows 7 64bit. Opening a database is fine. do you mean a LO database file ? If I then shut it down, you shut down the connection or the database file ? I cannot open it again! I have to restart the pc th enable me to

Re: [libreoffice-users] Re: Second opening of Database

2013-12-05 Thread Fernand Vanrie
On 5/12/2013 11:52, Bob Lineker wrote: By SHutting down I mean saving then data entered and then closing the LO database by clicking on the big X top right! The programme then closes (as confirmed by Task Manager. If I then try to open the same database nothing happens - and Task Manager shows

Re: [libreoffice-users] problem with table header colors in ms word

2014-01-06 Thread Fernand Vanrie
Dries , Same behavior here , but the troubles are coming from the way the doc is build. Kill the picture with the company logo's and the tables are colored. greetz Fernand We just accountered a problem where colored tables in a .doc file aren't shown correctly in LO, though they are

Re: [libreoffice-users] Connection to SQL database

2014-01-15 Thread Fernand Vanrie
Carl , Use a mySQL database and connect over the Native Connector then google for the book DataBase Programming writen by Roberto Benitez for Openoffice but also for LibreOffice a lot of code can been found on the Book-website Greetz Fernand On 15/01/2014 16:55, Ryan Ashley wrote: SQL

[libreoffice-users] Need confirmation about Date type confusions

2014-02-27 Thread Fernand Vanrie
Since 4.1 the Date property from a com.sun.star.awt.UnoControlDateFieldModel returns no longer a Isodate but a Unodate. Since its stay like that in 4.2 is started to correct all or BASIC code who uses a com.sun.star.awt.UnoControlDateFieldModel. But i runed by accident in a bug where as

[libreoffice-users] Need confirmation about Menus in StartModule

2014-03-04 Thread Fernand Vanrie
Since 4.2 uses a different StartModule my Private Menus made by Extentions no longer appear on the new StartModule Until 4.0 the menus are placed in com.sun.star.frame.StartModule but i found no indications that this name was changed Stabel version 4.2 windows all versions Thanks

[libreoffice-users] need CONFIRMATION about images linked to a http location

2014-03-17 Thread Fernand Vanrie
With 4.2.2.1 windows Pictures in Writer and Html documents linked to a http location no longer opens and can no longer been inserted what makes the use of images in a HTML doc imposible A picture linked to http://pmg.pmgroup.be/enews/idb/grafiek9.jpg; can been opened and viewed in a writer

Re: [libreoffice-users] need CONFIRMATION about images linked to a http location

2014-03-17 Thread Fernand Vanrie
• www.tvh.com Watch our company movies on www.tvh.tv On 17 March 2014 17:30, Fernand Vanrie s...@pmgroup.be wrote: With 4.2.2.1 windows Pictures in Writer and Html documents linked to a http location no longer opens and can no longer been inserted what makes the use of images in a HTML doc

[libreoffice-users] How to put Basic IDE code completion to work

2014-03-18 Thread Fernand Vanrie
Found new Basic IDE options in 4.2 , but where to find some documentation how this new stuff works ? Thanks for any hint Fernand -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

[libreoffice-users] Re: How to put Basic IDE code completion to work

2014-03-19 Thread Fernand Vanrie
hallo Miklos thanks but only and ( are auto clossing dot operator is not functioning at all (maybe a keyboard problem ?) tab do nothing sub and Function not closing do i something wrong ? using Windows 7 (4.2.2.1) On Tue, Mar 18, 2014 at 10:26:08PM +0100, Fernand Vanrie s...@pmgroup.be

Re: [libreoffice-users] Do Macros run serially or in parallel?

2014-04-04 Thread Fernand Vanrie
Noel , Andrew, What system are you running ? on windows the wait is doing OK try this code s1 = 1. + Now() Wait(2000) s2 = 2. + Now() msgbox (s1 chr(13) s2) s1 an s2 differs from 2 seconds (wait 2000) Greetz Fernand Hi Andrew, Yes, that is what seems to be happening. Even if

[libreoffice-users] Playing Video in a Dialog

2014-04-17 Thread Fernand Vanrie
On The French user site i found usefull code to play video on Windows using the API and Basic. The code opens a MediaWindow and play any video The player has a undocumented method CreatePlayerWindow who needs arguments (a empty array do crash LO) Do someone knows how to use this method and

Re: [libreoffice-users] forums, The AOO one

2014-04-25 Thread Fernand Vanrie
On 25/04/2014 13:06, Andrew , Its a chame, there must be a solution save all this invaluable information, its still te best place to start coding wint LO and OO Greetz Fernand On 04/24/2014 03:05 PM, Tom Davies wrote: Hi :) Just popped into the Apache OpenOffice forum

Re: [libreoffice-users] left/right pages

2014-04-29 Thread Fernand Vanrie
Brian , Truett Probably there is a problem with the default page style where the next style is set to a right page ? greetz Fernand At 19:47 28/04/2014 -0700, Truett Bobo wrote: In the last few days, anytime I create a new LO Writer document it is formatted with left and right pages. And

Re: [libreoffice-users] Re: Need help with Base

2014-05-07 Thread Fernand Vanrie
On 6/05/2014 22:35, Girvin Herr wrote: Tom Milica, No! No! No! I am not offering to do the work. I apologize if I somehow implied that. I have zero experience writing LO macros of any sort. I was just suggesting to avoid macros wherever possible. Recreating data entry forms and reports

Re: [libreoffice-users] Re: Automating creation of PDF from Calc

2014-05-12 Thread Fernand Vanrie
Alex , using the Dispatcher is not a good idea , use te API and basic to automate some functions as printing to PDF under specific conditions. Please find below the code i use to print from a Writer doc Sub export2PDF() dim oDoc as object CheckReportUser() sParent = checkparent

Re: [libreoffice-users] Help with LO Base

2014-05-14 Thread Fernand Vanrie
On 14/05/2014 15:54, Victor wrote: Hello. I'm a new user of LO Base, and I have some problems that I haven't be able to solve with tutorials. I'm making a db with several tables with many records in each one, and I want to retrieve records from several tables at the same time. Let me explain

Re: [libreoffice-users] Making Dialog changes peristent

2011-12-07 Thread Fernand Vanrie
Dag Cor , Hi Fernand, Fernand Vanrie wrote (06-12-11 13:17) When have made some changes to a Dialog (stored in a Library) I trye to make this changes persitent for future use. Not sure if I understand you. But I've some basic projects, where users settings/choices in a dialog are preserved

Re: [libreoffice-users] Making Dialog changes peristent

2011-12-08 Thread Fernand Vanrie
Andrew , Kor On 12/07/2011 03:14 AM, Fernand Vanrie wrote: Dag Cor , Hi Fernand, Fernand Vanrie wrote (06-12-11 13:17) When have made some changes to a Dialog (stored in a Library) I trye to make this changes persitent for future use. Not sure if I understand you. But I've some basic

Re: [libreoffice-users] Base can't open databases

2011-12-14 Thread Fernand Vanrie
Michael , We zouden dat in het Nederlands kunnen oplossen, no :-) You must understand that your odb file is just a go between, to make a connection to your original tables main. When you first made your odb file you have to make a choice wath driver to use make the connection. For some

Re: [libreoffice-users] MariaDb (v similar to MySql) beta-testing

2011-12-22 Thread Fernand Vanrie
Tom , Do you mean testing MariaDB or the Connector with LO (so yes where to find)? Tom, if your ar interested in LO Connector's to DataBases, please have a look a my question on de QA mailinglist http://lists.freedesktop.org/archives/libreoffice-qa/2011-December/000734.html. The Native MySQL

Re: [libreoffice-users] MariaDb (v similar to MySql) beta-testing

2011-12-22 Thread Fernand Vanrie
Tom , I will do that, just wait if Alex our others comes up with a solution, who is a regular Windows Rebuild an put this in a updated extension. Hi :) If the connector is working on other branches of LibreOffice but just not on the 3.5.x branch then perhaps posting a bug-report against Base

Re: [libreoffice-users] Base - Relationship issues

2011-12-28 Thread Fernand Vanrie
Op 28/12/2011 14:55, HRdesigner schreef: One or more off your tables has no primery key or the fields you use to make the relationship is not indexed ? hope it helps fernand I am creating a database to track employee information I have a 1:n relationship and I always get a generate foreign

Re: [libreoffice-users] Base/SQL help

2012-01-03 Thread Fernand Vanrie
Jeff , You need a combination of some macro-coding and SQL statements best start is Googling ANDREW BASE DOCUMENT There you will find al you need todo the job Roberto Benitez wrote a exelent book and there is lot of info on his site http://www.baseprogramming.com/ Hope it helps Fernand I

Re: [libreoffice-users] Re: Names of output filters? Name of HTML output filter?

2012-01-09 Thread Fernand Vanrie
Tom, With the API and some Basic code from the good old Danny B. can do the job gives us a 65 pages writer Doc. Hope its helps Greetz Ferand Sub Main oFF = createUnoService( com.sun.star.document.FilterFactory ) oFilterNames = oFF.getElementNames() ' Now print the filter names.

Re: [libreoffice-users] Re: Names of output filters? Name of HTML output filter?

2012-01-10 Thread Fernand Vanrie
aj, Sorry i was thinking you where trie to find a list of all filternames :-) Greetz Fernand How is this related to my question? -aj Am 9. Januar 2012 14:47 schrieb Fernand Vanries...@pmgroup.be: Tom, With the API and some Basic code from the good old Danny B. can do the job gives us a 65

Re: [libreoffice-users] Re: Names of output filters? Name of HTML output filter?

2012-01-10 Thread Fernand Vanrie
Tom , Copy the code in a Basic module and run ! Greetz Fernand Hi :) I thought the original was asking for a list of all the filters available? I think Fernand's coding gives a list of the filters in whichever version of libreOffice you happen to be running. As each new release comes out

Re: [libreoffice-users] Re: Names of output filters? Name of HTML output filter?

2012-01-10 Thread Fernand Vanrie
aj, sorry but tour original question: Running soffice --convert-to allows me to specify a custom output filter name.*Where can I full list* of output filter names? In particular I am looking for the name of the HTML output filter used for the HTML export used through the UI. This filter is

Re: [libreoffice-users] Re: Names of output filters? Name of HTML output filter?

2012-01-11 Thread Fernand Vanrie
good_code.png Fernand Vanrie wrote the code faster than anyone was able to point to the old link. The old link's most recent list was for OOo version 1.1 rc1 which is a little out-of-date now. Fernand's list was for .4.x which is a lot more up-to-date. Regards from Tom :) -- View this message

Re: [libreoffice-users] Triggering reports from html files

2012-01-13 Thread Fernand Vanrie
On 13/01/2012 06:42, Beth Lesko wrote: Thanks for the reply, Dan, It's not that I want the report to be displayed in an html file, rather, I'd like to be able to make an href call to open a dynamic report to display in an .odt file. A report is a preformated .odt file who is on opening filed

Re: [libreoffice-users] Re: Triggering reports from html files

2012-01-16 Thread Fernand Vanrie
blesko , wrong number of paramaters can be : your event do not transfers the parameters to the function or Sub you trie to run ShowRunReportDialog DBName, ReportName, ExportFileName, Action, AsPdf I think you need to read the code and pick the stuff you need to make your application running

Re: [libreoffice-users] MySQL native connector - several databases retrieved?

2012-01-16 Thread Fernand Vanrie
fmayo , Use the Tools Table Filter in the the odb document to choose the wanted -not wanted databases. Greetz Fernand Hello team, I currently installed a MariaDB base server as local host (version: : 5.3.3-MariaDB-rc-mariadb108~oneiric-log, installed from deb repositories) and would like

Re: [libreoffice-users] Re: Triggering reports from html files

2012-01-18 Thread Fernand Vanrie
On 18/01/2012 09:38, blesko wrote: I edited mdlExecReport and added a function OpenAllergyReport, which is a duplicate of OpenReport(). maybe you must rename your new function to OpenReport This works when I access the macro from the toolbar - in both the DB object and an exported .odt form

Re: [libreoffice-users] Changing default margins and font for a group of users

2012-01-24 Thread Fernand Vanrie
Carl , You can change the default template by running a macro on every machine hope it helps Fernand Hi, I need to change the default margins and font in Libreoffice Writer and Calc for a group of about 100 users. How can I do this without having to go and do it manually on every PC?

Re: [libreoffice-users] Changing default margins and font for a group of users

2012-01-24 Thread Fernand Vanrie
On 24/01/2012 15:38, Jay Lozier wrote: On 01/24/2012 03:39 AM, Carl wrote: Hi, I need to change the default margins and font in Libreoffice Writer and Calc for a group of about 100 users. How can I do this without having to go and do it manually on every PC? Regards Carl Werner Where is

Re: [libreoffice-users] Base - No SDBC driver found!!

2012-01-26 Thread Fernand Vanrie
Ian, no panic, what is the external database you are connected to ? or are you using the embeded database the error No SDBC driver found looks like you odb document lost the connection with a external database Greetz Fernand As always I seem to be battling again with my Database!! I've

Re: [libreoffice-users] Base - No SDBC driver found!!

2012-01-26 Thread Fernand Vanrie
Ian, in these case you can panic :-) can you still open your odb doc and check your tables ? if not open the doc with tool to unzip the content and check if the data file is still present On 26/01/2012 13:29, Fernand Vanrie wrote: no panic, what is the external database you

Re: [libreoffice-users] Base - No SDBC driver found!!

2012-01-26 Thread Fernand Vanrie
On 26/01/2012 14:38, Ian Whitfield wrote: I'm using the embeded database - HSQL. I would LIKE to get away from this but the couple of times I tried in the past were a complete failure!! Greetings back to you Thanks All!! *To Fernand* - Both copies of my .odb file are the same size

Re: [libreoffice-users] Base - No SDBC driver found!!

2012-01-26 Thread Fernand Vanrie
On 26/01/2012 16:32, Ian Whitfield wrote: On 26/01/2012 16:15, Fernand Vanrie wrote: odb. is *not* multi user, when the document is open on a other machine of by a other user everyting is grayed out OK - fine. But how do I reset/reverse this?? make sure nobody is connected or has opened

Re: [libreoffice-users] No longer able to open a ODB file

2012-01-26 Thread Fernand Vanrie
Scott , this is not a odb file , its comming from a older oo version (1.2) could be a swx, sxc, sxd, but as far as i know there was no database for 1.2 When I try to open this file: http://db.tt/CN65sXtn I am presented with the Filter Selection dialog, from which I choose ODF database. I

  1   2   >