[libreoffice-users] Fwd:

2013-02-12 Thread Drew Jensen
http://lasvegassuites.org/downrightawesome.com/nanw54.php?s=ot -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette

Re: [libreoffice-users] Folders for QUERIES in the DATABASE window?

2012-06-25 Thread drew jensen
On Sun, 2012-06-24 at 19:14 -0700, frofa wrote: Is it possible to create virtual FOLDERS in the QUERIES pane of the BASE database window - as one can in the FORMS and REPORTS panes? Hi Frofa, No - that is not implemented for query definitions, only forms and reports. //drew -- View this

Re: [libreoffice-users] Quickstarter is missing from LO3.5.5. onDebian

2012-07-13 Thread drew jensen
On Fri, 2012-07-13 at 09:27 -0400, webmaster-Kracked_P_P wrote: On 07/13/2012 06:48 AM, Mirosław Zalewski wrote: On 13/07/2012 at 12:28, Anthony Easthope antiso...@myopera.com wrote: I thought most debian releases had unity or at least GNOME 3 as their GUI and they all feature a Dock.

Re: [libreoffice-users] Quickstarter is missing from LO3.5.5. onDebian

2012-07-13 Thread drew jensen
On Fri, 2012-07-13 at 15:16 +0100, AG wrote: On 13/07/12 15:04, drew jensen wrote: On Fri, 2012-07-13 at 09:27 -0400, webmaster-Kracked_P_P wrote: On 07/13/2012 06:48 AM, Mirosław Zalewski wrote: On 13/07/2012 at 12:28, Anthony Easthopeantiso...@myopera.com wrote: snip I find

Re: [libreoffice-users] Base and SQL statement

2012-07-20 Thread drew jensen
On Fri, 2012-07-20 at 09:51 -0400, Dan wrote: The outline for the FROM clause for a LEFT OUTER JOIN is FROM “table1 name” LEFT OUTER JOIN “table2 name” ON “table1 name”.”foreign key” = “table2 name”.”primary key” This is what I entered into a query yesterday. Yet, today when I

Re: [libreoffice-users] now can Purchase a NA-DVD

2012-07-21 Thread drew jensen
On Sat, 2012-07-21 at 18:18 -0400, webmaster-Kracked_P_P wrote: DO you have a broadband Internet connection? The .iso file is listed here. http://www.libreoffice.org/download/?type=boxversion=3.5.5 If you do not have broadband connection, there should be a way for you to get a copy from some

Re: [libreoffice-users] starting Base - works for me

2012-07-27 Thread drew jensen
On Fri, 2012-07-27 at 10:41 -0400, webmaster-Kracked_P_P wrote: OK I just installed the non-repository version of 3.5.5 as an upgrade to 3.5.4 on my Ubuntu 12.04/MATE laptop. I still have Base listed, and working, in my Applications/Office menu listing. Hi, Right - if you already had

Re: [libreoffice-users] Re: I have a question

2012-07-28 Thread drew jensen
On Sat, 2012-07-28 at 08:35 -0700, Lynne Stevens wrote: omega The Omega sector America's Last Line of Defense *That sounds like they will be merged ! . . They are to remain separate and the B file is to be used for a mailing thing after it has the duplicates removed . . the

Re: [libreoffice-users] Other SQL question as it affects Base

2012-07-28 Thread drew jensen
On Sat, 2012-07-28 at 15:36 -0400, Dan wrote: An example of an inner join: table1 INNER JOIN table2 ON table1.foreign key=table2.primary key Mathematically the following seems to be possible: table1 INNER JOIN table2 ON table1.foreign key=2*table2.primary key Is the latter

Re: [libreoffice-users] Libreoffice 3.6

2012-08-08 Thread drew jensen
On Wed, 2012-08-08 at 21:22 +0200, Johnny Rosenberg wrote: 2012/8/8 Jeff Hahn kr...@hotmail.com: I have two questions on LibreOffice 3.6.0. First, when I go to the Macro in Calc (Tools – Macros) the record macro function is no longer there. I have LibreOffice 3.5.5.3 and there is

Re: [libreoffice-users] Re: Keyboard Shortcuts for Buttons in Base

2013-01-17 Thread Drew Jensen
Howdy Noel, Sure, for a button in the label add a tilde ~ before the letter you want to use as the keyboard accelerator. In the case of a data control on a form you do similar, add a label control, in the text for the label add the ~ before the character you want to use and then for the actual

Re: [libreoffice-users] Re: Tell me it's not true

2012-02-29 Thread drew jensen
On Wed, 2012-02-29 at 12:26 +0100, Alexander Thurgood wrote: Le 29/02/12 07:43, Andreas Säger a écrit : Hi all, Base is best when you ignore most of its tools and helpers relying entirely on your own skills and on the capabilities of the underlying database driver. I wish it

Re: [libreoffice-users] Re: Tell me it's not true

2012-02-29 Thread drew jensen
On Wed, 2012-02-29 at 12:45 +0100, Alexander Thurgood wrote: Le 29/02/12 12:40, drew jensen a écrit : *laughing*...I'll be damned, I was tempted to say exactly that, pulled it back at that last second - but yes that is about it. Honestly - I stopped advising anyone to use Base

Re: [libreoffice-users] Re: Tell me it's not true

2012-02-29 Thread drew jensen
On Wed, 2012-02-29 at 13:36 +, e-letter wrote: On 29/02/2012, Andreas Säger ville...@t-online.de wrote: Almost nothing has changed since then, except for fixing things that should have been working right from the start 9 years ago. The Base developers wasted too much time with useless

Re: [libreoffice-users] Tell me it's not true

2012-02-29 Thread drew jensen
On Wed, 2012-02-29 at 15:12 +, Mark Stanton wrote: Yes - It's one at a time. Hmm, a shame but plausible. And HSQL seems to require index names to be unique at the database level not the table level, is that right? Yes. Isn't that a little... Non-standard? Not

Re: [libreoffice-users] Parameterised query

2012-02-29 Thread drew jensen
On Wed, 2012-02-29 at 15:06 +, Mark Stanton wrote: Hi, Taking advice here and the French FAQ on the Wiki (now translated :-) ), I see how to use parameters in a query. I have a query in my database that's linked to a MySQL database and it just complains The data content could not be

Re: [libreoffice-users] Parameterised query

2012-03-01 Thread drew jensen
On Thu, 2012-03-01 at 14:11 +, Mark Stanton wrote: Hi Fernand, so ? works for native SQL : works for OO-SQL I'm not sure if you are asking me a question or making a statement. What you are saying is not what I was saying, I'm not certain it is right, I don't think it is. I

Re: [libreoffice-users] Table Format

2012-03-04 Thread drew jensen
On Sat, 2012-03-03 at 21:53 -0500, Sylvain Bromberber wrote: I once opened the table in one of my data bases and it popped up in a format I have not been able to duplicate. The upper half of the screen was the table in the form of a spread sheet but the lower half had the items of each row in

Re: [libreoffice-users] Base faq

2012-03-04 Thread drew jensen
On Sun, 2012-03-04 at 18:45 +, Mark Stanton wrote: I can take no credit for the completeness, it's just my (poor) best at translating the French FAQ. There were a couple of things that I changed/added/removed but mostly I just translated. Perhaps there could be something crediting the

Re: [libreoffice-users] Table Format

2012-03-04 Thread drew jensen
detail control. I assumed that was what you where talking about. Best wishes, //drew -Original Message- From: drew jensen Sent: Sunday, March 04, 2012 1:12 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Table Format On Sat, 2012-03-03 at 21:53 -0500, Sylvain

Re: [libreoffice-users] Re: Table Format

2012-03-05 Thread drew jensen
On Mon, 2012-03-05 at 09:19 +0100, Andreas Säger wrote: Am 05.03.2012 02:43, Dennis E. Hamilton wrote: Are you on a laptop? Your function keys may have as default actions the control of laptop display functions and other provisions. (These are usually signified by a variety of symbols.)

[libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress

2012-03-14 Thread drew jensen
or accdb (MS Access data engines) directly. Would that mean re-writing Access's Reports and Forms that are based on the tables? Regards from Correct - there is no way to re-use any of those. Tom :) --- On Wed, 14/3/12, drew jensen drewjensen.in...@gmail.com wrote: From: drew jensen

Re: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress

2012-03-14 Thread drew jensen
On Wed, 2012-03-14 at 12:49 +, Tom Davies wrote: Hi :) So Base can't update Accesses internal tables? That is NOT what I said. What I said was, that when connecting to an MS Access file the users need to be mindful of the fact that queries in the Access file will appear to them to be

Re: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress

2012-03-14 Thread drew jensen
understand it so don't touch Many thanks and regards from Ok but keep in mind that the same people that made that pile of mess are likely the ones to make the next pile of mess - in other words it may not be the technology that needs changing. Tom :) --- On Wed, 14/3/12, drew jensen drewjensen.in

Re: [libreoffice-users] Re: Address Books

2012-03-16 Thread drew jensen
Sure why not So you want to build this tutorial over this weekend. Is it to be multi-user? //drew On Fri, 2012-03-16 at 14:29 +0100, Nino Novak wrote: On Friday 16 March 2012, 12:57:24 Andreas Säger wrote: Am 16.03.2012 11:09, Nino Novak wrote: On Thursday 15 March 2012, 21:49:10 Andreas

Re: [libreoffice-users] CVE-2012-0337

2012-03-23 Thread drew jensen
On Fri, 2012-03-23 at 07:55 -0400, Dan Lewis wrote: Using both LO and OOo, I'm aware of the need to patch this vulnerability for both. What I don't know is what is the status of this with respect to LO. I presently have 3.5.1-102 and 3.4.5.502. I did not see anything mentioned about this on

Re: [libreoffice-users] CVE-2012-0337

2012-03-23 Thread drew jensen
On Fri, 2012-03-23 at 08:53 -0400, Dan Lewis wrote: On Fri, 2012-03-23 at 08:10 -0400, drew jensen wrote: On Fri, 2012-03-23 at 07:55 -0400, Dan Lewis wrote: Using both LO and OOo, I'm aware of the need to patch this vulnerability for both. What I don't know is what is the status

Re: [libreoffice-users] Can't register for the Nabble interface, CAPTCHA not working?

2012-03-28 Thread drew jensen
On Wed, 2012-03-28 at 20:32 +0200, Stephan Petersen wrote: Hi guys, I'm trying to register for the Nabble interface (http://www.libreoffice.org/get-help/nabble-mailing-list-interface/), but I always get The validation code did not match the picture., although I think I'm not blind and I

Re: [libreoffice-users] Make a form that allows user to drag and drop in an image

2012-04-06 Thread drew jensen
On Fri, 2012-04-06 at 14:35 -0400, Dan Lewis wrote: On Fri, 2012-04-06 at 08:52 -0700, avamk wrote: Hello Thanks to the great instructions http://sheepdogguides.com/fdb/fdb1imagbp.htm here , I learned how to link a VARCHAR field to images in my filesystem, and display them in a form.

Re: [libreoffice-users] Problems importing an OO database into LO

2012-04-06 Thread drew jensen
On Fri, 2012-04-06 at 14:43 -0400, Dan Lewis wrote: On Fri, 2012-04-06 at 09:54 -0700, ptoye wrote: I have an OO database, and am trying out LO, and am having at least one problem. There is a form which is based on a query whose results are displayed in a grid, and various fields are copied

Re: [libreoffice-users] Re: Make a form that allows user to drag and drop in an image

2012-04-06 Thread drew jensen
On Fri, 2012-04-06 at 16:00 -0700, avamk wrote: I am actually quite new to Base, and didn't realise I could use the File Picker control. When I try to change its reaction to the Mouse Pressed event, it asked me for a macro. Do I need to write a macro to get the relative path of my desired

Re: [libreoffice-users] Re: Make a form that allows user to drag and drop in an image

2012-04-07 Thread drew jensen
On Fri, 2012-04-06 at 16:00 -0700, avamk wrote: I am actually quite new to Base, and didn't realise I could use the File Picker control. When I try to change its reaction to the Mouse Pressed event, it asked me for a macro. Do I need to write a macro to get the relative path of my desired

Re: [libreoffice-users] Re: Make a form that allows user to drag and drop in an image

2012-04-08 Thread drew jensen
On Sat, 2012-04-07 at 21:11 -0700, avamk wrote: Thanks for the link! Looks like the Base Guide is still in its very early stages of development, are there comparable guides/books out that that I can start studying now?? Also, I've downloaded the example database and have been able to add new

Re: [libreoffice-users] Re: Make a form that allows user to drag and drop in an image

2012-04-08 Thread drew jensen
On Sun, 2012-04-08 at 11:34 +0100, Tom Davies wrote: Hi :) A google search gave me these for OpenOffice.org's Base which is almost exactly the same http://wiki.services.openoffice.org/wiki/Database http://www.oooforum.org/forum/viewtopic.phtml?t=82025

Re: [libreoffice-users] Re: Make a form that allows user to drag and drop in an image

2012-04-08 Thread drew jensen
Howdy avamk, Alright updated the file and added it as new file, (different URL on the wiki) this is a zip file now. https://wiki.documentfoundation.org/File:Linkme.zip It will extract to a sub-dir named, linkme whith: linkme.odb lo-client-libo-wallpaper.jpg images/basicorganizer.png In the

Re: [libreoffice-users] Remove Macro from spreadsheet

2012-04-08 Thread drew jensen
On Sun, 2012-04-08 at 13:06 +0100, Gordon Burgess-Parker wrote: LO 3.5.2.2. I tried setting a Macro in a particular spreadsheet that didn't work. I have deleted everything I can find in Tools-Macros-Organise Macros-Libre Office Basic but there are still two entries of Standard under My

Re: [libreoffice-users] Re: Make a form that allows user to drag and drop in an image

2012-04-10 Thread drew jensen
:-) it all worked..surprise. anyway - let me know if any of this makes sense, and if you it mostly does, what is the best way to help reinforce it - I will try to write a decent explanation, but always need help with that, I'm no word smith. //drew On Tue, 2012-04-10 at 17:26 -0400, drew jensen

Re: [libreoffice-users] How to change document author in existing document

2012-04-11 Thread drew jensen
On Wed, 2012-04-11 at 11:33 -0700, Russ Mannex wrote: Using LibreOffice Writer 3.4.4 on Mint 12 KDE. If I create a document, then export to PDF, the author is set to the user info as defined in the OptionsUser Data section. In FileProperties, I can deselect Apply user data and the author

Re: [libreoffice-users] [BASE] New to Base - Program stops

2012-04-11 Thread drew jensen
On Wed, 2012-04-11 at 16:48 -0300, Preston Smith wrote: Hi, I am trying to learn Base in LO 3.5.2.2 under Vista with all latest updates I start Base - then I follow the steps shown at http://sheepdogguides.com/fdb/fdb1tableone.htm The Base wizard starts; I click 'Create a new database'

Re: [libreoffice-users] Re: Make a form that allows user to drag and drop in an image

2012-04-12 Thread drew jensen
On Tue, 2012-04-10 at 23:12 -0700, avamk wrote: Hi Drew, It looks amazing now, and the functionality is great. I am especially glad that it will work in Linux, Mac, and Windows! Were you going to write an explanation for the code, or just the form? Either way, if you can start a draft, I

Re: [libreoffice-users] Re: Connecting to HSQLDB with Base

2012-04-13 Thread drew jensen
On Fri, 2012-04-13 at 16:35 +0200, Andreas Säger wrote: Am 13.04.2012 15:50, Dan Lewis wrote: On Fri, 2012-04-13 at 09:38 -0400, Dan Lewis wrote: I have hsqldb installed and running. But I don't find the information that I need to connect Base to it. I have read I can use either ODBC or

Re: [libreoffice-users] Re: How to format data entry in base table to UPPERCASE only

2012-04-13 Thread drew jensen
On Fri, 2012-04-13 at 17:49 +0200, Andreas Säger wrote: Am 13.04.2012 17:42, leon244 wrote: I am trying to find a way to format the text fields in my small data base to be uppercase only. Is there a way to do it at the table field level with the 'format', or can it only be done at the form

Re: [libreoffice-users] Re: How to download?

2012-04-13 Thread drew jensen
On Fri, 2012-04-13 at 18:05 -0400, Darren Govoni wrote: That's it. But the rate from that site is like 62k per second for me. I'm near Washington, DC. This is the speed coming from the server. Are there mirrors I can choose from, closer to me or not throttled? I couldn't find any download

Re: [libreoffice-users] Re: How to download?

2012-04-13 Thread drew jensen
On Fri, 2012-04-13 at 19:10 -0400, drew jensen wrote: On Fri, 2012-04-13 at 18:05 -0400, Darren Govoni wrote: That's it. But the rate from that site is like 62k per second for me. I'm near Washington, DC. This is the speed coming from the server. Are there mirrors I can choose from

Re: [libreoffice-users] Re: How to download?

2012-04-13 Thread drew jensen
;) On the download page, the green download button, click on the link, lower right hand, Info. This will give you a page with, amongst other items, direct links to the mirrors, those in your region listed first. //drew Thank you. don On 04/13/2012 07:40 PM, drew jensen wrote: On Fri

Re: [libreoffice-users] Removing Themes box

2012-04-13 Thread drew jensen
On Fri, 2012-04-13 at 13:22 -0700, 20rdj04 wrote: I don't know how I opened the themes box, but now I can't get rid of it. The damn thing takes about 3 inches off the top of my desktop/page. As I am writing a letter, the page is already short enough. hmm - I believe you are referring to the

Re: [libreoffice-users] Re: [Announce] HyperSQL 2.2.8 Released

2012-04-14 Thread drew jensen
On Sat, 2012-04-14 at 12:34 +0200, Andreas Säger wrote: Am 14.04.2012 04:22, avamk wrote: Thank you for all of your replies, the information is very helpful, and I will continue to explore. Just one more question: Would migrating to other databases (like MySQL or PostgreSQL) be similar

Re: [libreoffice-users] Base 3.5.2.2 hangs

2012-04-14 Thread drew jensen
On Sat, 2012-04-14 at 07:46 -0700, clehmann wrote: Hello everybody, I have installed LibreOffice 3.5.2.2 with base on Win 7 Home Premium (both French). I have Java 6 update 31 also installed. I am able to start LibreOffice without any problem. I am also able to open any text, spreadsheet,

Re: [libreoffice-users] Re: launching app from within base

2012-04-23 Thread drew jensen
On Mon, 2012-04-23 at 09:24 -0700, brainflakes wrote: Nino wrote Sorry, I don't know anything about Base - but in Writer you just insert a Hyperlink, chose Document and enter a Document URL. If the document has a extension/MIMEtype/whatever which is known to the system, the

Re: [libreoffice-users] Re: launching app from within base

2012-04-24 Thread drew jensen
://help.libreoffice.org/Basic/Shell_Function_Runtime Which is pretty good starting point. //drew --- On Tue, 24/4/12, drew jensen drewjensen.in...@gmail.com wrote: From: drew jensen drewjensen.in...@gmail.com Subject: Re: [libreoffice-users] Re: launching app from within base To: users

Re: [libreoffice-users] Re: Wanted: Macro for removing Page Breaks in MailMerge docs

2012-05-01 Thread drew jensen
On Wed, 2012-05-02 at 00:01 +0200, Nino Novak wrote: Am Dienstag, 1. Mai 2012, 23:44:21 schrieb Andreas Säger: Am 01.05.2012 23:19, Nino Novak wrote: I do not see how to achieve the desired result by mere dragging. E.g. with the included database Biblio, I can create the following

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread drew jensen
On Fri, 2012-05-25 at 15:47 -0700, Girvin R. Herr wrote: Tom Davies wrote: Hi :) I have just done a bit of digging around. Looking back through Andreas' answers http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodesuser=254826i=80 I found this but i'm not

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-25 Thread drew jensen
On Fri, 2012-05-25 at 19:02 -0700, Girvin R. Herr wrote: drew jensen wrote: 8... Hi Tom Really - you seem to know a lot, are you writing a manual? @Girvin - there is no place that I've seen the report builder be that slow and not have an installation problem - not saying

Re: [libreoffice-users] Re: Extremely Slow Base Report Builder

2012-05-26 Thread drew jensen
On Sat, 2012-05-26 at 12:53 +0200, Andreas Säger wrote: Am 26.05.2012 00:47, Girvin R. Herr wrote: As an update to my problem with Report Builder, my 1500+ record database takes 94 pages of a Report Builder / Writer document. I put on my patience hat and timed how long it takes to format

Re: [libreoffice-users] Re: Can I reload a form based on a parameter query?

2017-01-28 Thread Drew Jensen
Howdy Peter, I'm only a user of the software. Anyone can request a change and it is pretty easy to do. Likely getting one of the developers to want to code it will be a bit more of a trick, but there is a process and if no one ever enters a request it certainly won't happen. Just in case: - the

Re: [libreoffice-users] Re: Can I reload a form based on a parameter query?

2017-01-27 Thread Drew Jensen
howdy, Ah, considering that the project is actively working on the Base module at the moment this might be a great time to open a Request For Enhancement. In this case a request to add a ReloadWith (for example) function on the data set (form) which would reload the data using the current

Re: [libreoffice-users] LibreOffice - Macro - Java - Eclipse

2017-09-20 Thread Drew Jensen
For Python there is an extension available which helps, don't think it would do much with Eclipse, but for generalized use it seems pretty good. https://extensions.libreoffice.org/extensions/apso-alternative-script-organizer-for-python On Tue, Sep 19, 2017 at 12:11 PM, Volker Lenhardt <

Re: [libreoffice-users] Base: check boxes in forms lost after update

2018-08-09 Thread Drew Jensen
Hi, First the mailing list does not support binary attachments, so the screen shot is not available. (if you want to share those you need to push them up to an on-line location and share the url) As for the form controls, they have changed homes - some of the controls that in earlier versions

Re: [libreoffice-users] Re: LibreOffice Basic macro stops working after upgrade from LO 6.0 to LO 6.1

2018-08-21 Thread Drew Jensen
XGrphic information I've found in the SDK documentation at sdk/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1graphic_1_1XGraphic.html Wanting use this also, later this week, for reading images into database fields with a python script - so happened to look that up over the weekend. Haven't tried

Re: [libreoffice-users] Base : How to control insert into a form in order to generat my own keys by macro ?

2018-07-22 Thread Drew Jensen
On Sun, Jul 22, 2018 at 2:58 AM Patrick Gelin wrote: > Hi, > > I would like to control key generation by macro when inserting a new row > into a form with Base. But the risk is to execute twice insert action : > the first with my handling insert event (I want to manage the mapping > and use my

Re: [libreoffice-users] Strange Macro folder behavior

2018-07-22 Thread Drew Jensen
One more reference for you, particularly if you are trying to use Record Macro, with much better detail on what could be culprit here. https://forum.openoffice.org/en/forum/viewtopic.php?f=9=80579#p371390 How it helps, Drew On Sun, Jul 22, 2018 at 5:49 PM Peggy <33mar...@gmail.com> wrote: > I

Re: [libreoffice-users] Predefinied constants (Macro, Basic)

2018-07-22 Thread Drew Jensen
Howdy, To the best of my knowledge those are it. You would need to recreate those once and then include them in later projects. It's a common thing for folks to do, make their own include library with such. In fact you might want to look at the Access2Base library in the libreoffice

Re: [libreoffice-users] Strange Macro folder behavior

2018-07-22 Thread Drew Jensen
Howdy, So, I see that on ask libreoffice this has come up twice and both times closed out (without an answer) or left unanswered. There is an old forum post on this that might help in your case. You can find it here: https://forum.openoffice.org/en/forum/viewtopic.php?f=5=42324 but that is back

Re: [libreoffice-users] About pseudo objects with Basic code ...

2018-07-08 Thread Drew Jensen
Howdy, Mauricio, Patrick I am curious as to why you think python is always the better choice? (ie. error handling, or whatever; or is it just always so in Patrick's use case and the example code you supplied there) Also, I you don't mind me asking. I'm new python scripting in LibreOffice. Do

Re: [libreoffice-users] About pseudo objects with Basic code ...

2018-07-08 Thread Drew Jensen
y be some devs on this mailinglist who can answer you but it > doesn't hurt to have other places to ask too. Actually i thought you were > one of our devs but there we go. I know you have done a lot for LO. > Good luck and regards from > a Tom :) > > > > > On 8 July

Re: [libreoffice-users] About pseudo objects with Basic code ...

2018-07-09 Thread Drew Jensen
Howdy Patrick, et al; On Mon, Jul 9, 2018 at 9:11 AM Patrick Gelin wrote: > I think there is a problem with python: nomadism ! If I want to use my > USB key with Base connecting to HSQLDB I need to install > LibreOffice/OpenOffice into the PC, then JAVA, Then HSQLDB ... then > Python ! It's a

Re: [libreoffice-users] About pseudo objects with Basic code ...

2018-07-09 Thread Drew Jensen
Let's try sending that reply to the list also. (sorry) On Mon, Jul 9, 2018 at 6:01 PM Drew Jensen wrote: > Howdy Patrick, et al; > > On Mon, Jul 9, 2018 at 9:11 AM Patrick Gelin > wrote: > >> I think there is a problem with python: nomadism ! If I want to use my >> U

Re: [libreoffice-users] [Base] PostgreSQL column w/ default value & Forms: broken in 6.1.2

2018-10-08 Thread Drew Jensen
Howdy, Yes that was reported and the issue has been resolved in the coding. Next releases will include the fix. See https://bugs.documentfoundation.org/show_bug.cgi?id=120245 for details. Best wishes, Drew On Mon, Oct 8, 2018 at 1:32 PM Albrecht Dreß wrote: > Hi all, > > I use LibreOffice as

[libreoffice-users] Re: [libreoffice-documentation] Find Character Styles

2018-10-27 Thread Drew Jensen
Howdy Dave I just now tried the latest release of the extension (ver 1.4.2) with 6.2Alpha1 and you are correct it fails searching for a character style. Also, just now, tried that extension with 6.1.3 -> 5.4.7 (all using Ubuntu 18.04) and it works fine for character style searches. Are you sure

Re: [libreoffice-users] Re: libreoffice base/postgres - null columns with trigger/default values

2018-10-01 Thread Drew Jensen
BTW Currently the native MySQL ( MariaDB) sdbc has a setting ' FormsCheckrequiredFields' which can turn that function on or off. Checking just now the PostgreSQL sdbc code does not currently have that option. Yeah, that needs to go into the issue tracker for sure. Drew On Mon, Oct 1, 2018 at

Re: [libreoffice-users] libreoffice base/postgres - null columns with trigger/default values

2018-10-01 Thread Drew Jensen
Also, In the issue be sure to show which version of PostgreSQL you are using? Thanks On Mon, Oct 1, 2018 at 8:08 AM Drew Jensen wrote: > Hi, > > You would want to open an issue in the LibreOffice bug tracker and the > module would be Base. > postgreSQL should be in the su

Re: [libreoffice-users] Re: libreoffice base/postgres - null columns with trigger/default values

2018-10-01 Thread Drew Jensen
really would rather not than one of us in the QA group can do it. Let us know. Thanks Drew On Mon, Oct 1, 2018 at 12:57 PM Kamil Jońca wrote: > Drew Jensen writes: > > > Hi, > > > > You would want to open an issue in the LibreOffice bug tracker and the > > module

Re: [libreoffice-users] What happened to Base report copy-paste?

2018-09-22 Thread Drew Jensen
I don't mysql up and running and a slightly newer LibreOffice Version: 5.4.7.2 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk2; Also a slightly older version 5.3.0 Alpha This is under Ubuntu 18.04, and I also checked with a couple of newer versions of LibreOffice, again though only

[libreoffice-users] Re: [libreoffice-website] capabilty to execute macro on a "server" version of libreoffice

2019-01-06 Thread Drew Jensen
On Sun, Jan 6, 2019 at 10:54 AM Bruno Patin - wanadoo < bruno.pa...@wanadoo.fr> wrote: > Hi, > Howdy, > > I would like to know if there exists roadmap that would allow to create > a server version of libreoffice that would execute macros job on office > docs. It would mean a version not using

Re: [libreoffice-users] Base/Firebird Queries broken

2019-01-16 Thread Drew Jensen
found for example files for this feature. Seems to me it might be worthwhile to offer them for download (maybe as a zip file) and reference that download location in the video and/or associated posting text. On Wed, Jan 16, 2019 at 1:06 PM Drew Jensen wrote: > So, can you open that Qu

Re: [libreoffice-users] Re: Base/Firebird Queries broken

2019-01-16 Thread Drew Jensen
ithout the embedded macro complaint. On Wed, Jan 16, 2019 at 11:42 AM Drew Jensen wrote: > Howdy, > > Yes, I have a suggestion - there is a property in the Base file which is > incorrectly set during the Migration Assistant run and must be fixed. The > error message looks like this

Re: [libreoffice-users] Base/Firebird Queries broken

2019-01-16 Thread Drew Jensen
Sorry - that last email wen to the wrong mailing list - please disregard it here. On Wed, Jan 16, 2019 at 1:14 PM Drew Jensen wrote: > Before I forget - the files used for to gather these runtime numbers are > found here: > https://gerrit.libreoffice.org/#/admin/projects/

Re: [libreoffice-users] Re: Base/Firebird Queries broken

2019-01-16 Thread Drew Jensen
Howdy, Yes, I have a suggestion - there is a property in the Base file which is incorrectly set during the Migration Assistant run and must be fixed. The error message looks like this is what is biting you. The fastest way to fix it is at follows: Close the base file and exit LibreOffice. Rename

Re: [libreoffice-users] Base/Firebird Queries broken

2019-01-16 Thread Drew Jensen
So, can you open that Query definition, the one that raised the error when you double clicked on it, in design view and Run it and it works? Is that what you are saying? Thanks On Wed, Jan 16, 2019 at 12:17 PM Paul D. Mirowsky wrote: > Ok, things are narrowing down on this issue. > > I have

Re: [libreoffice-users] Re: Base/Firebird Queries broken

2019-01-16 Thread Drew Jensen
ile a migrate again with this fix > or am I fixing > > SELECT rdb$get_context('SYSTEM','ENGINE_VERSION')... -- ENGINE_VERSION > Thanks > > Paul > > On 1/16/2019 11:42 AM, Drew Jensen wrote: > > Howdy, > > > > Yes, I have a suggestion - there is a prop

Re: [libreoffice-users] Base/Firebird Queries broken

2019-01-16 Thread Drew Jensen
seen that particular problem before. Did you say that the SQL statement will run with Run SQL Direct turned on? > > On 1/16/2019 1:06 PM, Drew Jensen wrote: > > So, can you open that Query definition, the one that raised the error > when > > you double clicked on

Re: [libreoffice-users] Scripting LO

2018-12-23 Thread Drew Jensen
Howdy, Support for that is built in and is available from a command line or script as you prefer. Here is a good overview of that: https://ask.libreoffice.org/en/question/2641/convert-to-command-line-parameter/ Best wishes, Drew On Sun, Dec 23, 2018 at 11:29 AM bunk3m wrote: > Hello. > > I

Re: [libreoffice-users] Calc week number problem

2018-12-22 Thread Drew Jensen
Howdy, On Sat, Dec 22, 2018 at 5:17 PM . wrote: > Don't know how the formatting here gets wrecked. Is there a way to > attach a file? Yes - by posting the question using the TDF web site at https://ask.libreoffice.org/en/questions/ which has full support for attaching files. The mailing

Re: [libreoffice-users] lobase and postgresql views

2018-12-04 Thread Drew Jensen
Howdy Lou, OK, so first thing. Base does not support updating data in Views (postgres or any other database backend). Second thing, the order of your columns in a table definition in a relational database is meaningless for the most part. I know that the Base Table viewer doesn't allow you to

Re: [libreoffice-users] Re: How to actually find something with Find in Calc?

2018-12-30 Thread Drew Jensen
@V Stuart I thought that also - but that isn't working, as I just proved to myself, with LO 6.2.0.1 RC1 (under Ubuntu 18.04.1) at least. On Sun, Dec 30, 2018 at 10:56 AM V Stuart Foote wrote: > @Johnny, > > Unless I am really misunderstanding, the "Formatted Display" check box will > shift

Re: [libreoffice-users] Re: How to actually find something with Find in Calc?

2018-12-30 Thread Drew Jensen
ally does. On Sun, Dec 30, 2018 at 10:58 AM Drew Jensen wrote: > @V Stuart > I thought that also - but that isn't working, as I just proved to myself, > with LO 6.2.0.1 RC1 (under Ubuntu 18.04.1) at least. > > On Sun, Dec 30, 2018 at 10:56 AM V Stuart Foote > wrote: > >

Re: [libreoffice-users] Re: How to actually find something with Find in Calc?

2018-12-30 Thread Drew Jensen
Thanks for finding those issues - I guess lots of folks thinking the same thing. I tried searching the expert configuration looking for any option that might change the behavior also. Also searched the on-line help and the last version of the Calc guide and found zero entries for "Formatted

Re: [libreoffice-users] Concatenate Function inCalc

2019-04-02 Thread Drew Jensen
Howdy, I believe that the difference is in where the function hails from: CONCATENATE is defined in the ODF standard. CONCAT comes by way of Excel support. I think you have a point about how the system should respond when erroneously using ranges for the ODF function (not supported) and could be

Re: [libreoffice-users] Transparency in Write

2019-04-13 Thread Drew Jensen
Hi, Right, so just tried this with 6.1.4.2 and it seem that from the dialog box the transparency setting is being ignored. On an upside, if instead I use the Transparency setting in the Sidebar Image page that is working fine. BTW also checked 6.2 (Ubuntu) and same thing. Not sure if there is

Re: [libreoffice-users] Getting a line break through a query

2019-05-15 Thread Drew Jensen
Howdy, The carriage return is in the string but in the case of the Query designer the result grid only displays single line data so it appears it is not there. If the query is used to populate controls on a form (grid or single field) there is a property for the control 'MultiLine Input' and

Re: [libreoffice-users] LO 6.2.x save dialog on Linux

2019-06-14 Thread Drew Jensen
LibreOffice no longer offers custom open and save dialog boxes and instead rely on the OS support dialogs. On Fri, Jun 14, 2019 at 8:00 AM aguador wrote: > > El vie, 14-06-2019 a las 08:35 +0100, Mike Scott escribió: > > On 12/06/2019 19:12, aguador wrote: > > > Does anyone on the list, whether

Re: [libreoffice-users] LO 6.2.x save dialog on Linux

2019-06-14 Thread Drew Jensen
picks all of those up. So after a couple minutes what I had when ran under Gnome is also there under KDE. HTH Drew On Fri, Jun 14, 2019 at 9:15 AM Drew Jensen wrote: > LibreOffice no longer offers custom open and save dialog boxes and instead > rely on the OS support dialogs. > > On

Re: [libreoffice-users] Base Firebird reserved words

2019-05-22 Thread Drew Jensen
Howdy, Just tried this using the latest build (yesterday) of 6.3 and created a table with two three fields named; id, Select and Integer. Used query designer to generate this SQL select statement SELECT "id", "Select", "Integer" FROM "tblKeyWords" and it is working as expected. Perhaps you mean

Re: [libreoffice-users] CSV import trouble (numbers & locale)

2019-04-23 Thread Drew Jensen
Howdy, Well, I'm using LibreOffice 6.2.3 (with Ubuntu) and have created a csv file with two data rows 12.12 12.123 Then set my global locale to Italian(Italy) and try to open the csv file. (which is using a tab to separate values btw) If in the dialog box I change the defaulted Italian(Italy)

Re: [libreoffice-users] LO Calc 6.3.5 Cell comment box

2020-03-01 Thread Drew Jensen
Yes, but only for existing comments. You can not expand the size of the box when you are entering the initial comment text. In a cell with some comment text select View Comment and you can then resize the box and the custom size is retained for each cell comment changed when saved. On Sun, Mar 1,

Re: [libreoffice-users] Re: LO Calc 6.3.5 Cell comment box

2020-03-01 Thread Drew Jensen
he > comments, etc. > > > > On 3/1/20 3:21 PM, Drew Jensen wrote: > > Yes, but only for existing comments. > > You can not expand the size of the box when you are entering the initial > > comment text. > > In a cell with some comment text select View Commen

Re: [libreoffice-users] LO 6.4 -vs- 6.3 Margin Changes

2020-03-03 Thread Drew Jensen
Well, I've got both 6.3 and 6.4 open and in the Format top level menu the only change was to a string. With 6.3 it is Format->Page... With 6.4 it is Format->Page Style But both versions do the same thing, which is they open the Page Style dialog. In both versions I can also change the margin

Re: [libreoffice-users] Redaction

2020-01-21 Thread Drew Jensen
> Directly as PDF" or either one of the two "Redacted Export" options. No > issue under Linux. > > Best Regards > Dave > > On 21/01/2020 18:21, Drew Jensen wrote: > > Howdy Dave, > > > > That is the review mode (the grey out blocks) so that the review

Re: [libreoffice-users] Redaction

2020-01-21 Thread Drew Jensen
Howdy Dave, That is the review mode (the grey out blocks) so that the reviewers can see what is being redacted. You get that when you select the 'direct to pdf' button on the tool bar. To the left are two drop down buttons, White and Black, click either of those and you get the PDF with the

Re: [libreoffice-users] Libreoffice office cloud version

2020-03-06 Thread Drew Jensen
Howdy, Good news! There is already a solution for what you are looking for. LibreOffice OnLine has been under development and available for a couple of years. You can find a user level guide to the software on the documentation page:

  1   2   >