[libreoffice-users] Trying to get labels to fit

Trying to produce labels, but they don't fit the paper! I'm using the built-in L7163 address label format. It's a bit complicated as I don't have a printer attached - I have to make a PDF document and print it on another machine. As Export to PDF just gives a sheet with the fields names on rather

[libreoffice-users] Re: Trying to get labels to fit

in LibreOffice. Don On 12/14/2012 08:13 PM, NoOp wrote: On 12/14/2012 04:28 PM, Don Myers wrote: Hi ptoye, About 4 or 5 years ago when doing labels for our Christmas cards, I ran across the table style forms mentioned by NoOp below. I will never go back to the standard frame type forms standard in OO

[libreoffice-users] Re: Trying to get labels to fit

Thanks again NoOp. But I think we're at cross-purposes here. I don't need the paper labels - they're easily and cheaply available here in England. What I need is a way of getting LO and/or OO to print the labels correctly on the page. I admit that having to use a PDF printer (CutePDF or Bullzip)

[libreoffice-users] Re: Trying to get labels to fit

NoOp wrote What I need is a way of getting LO and/or OO to print the labels correctly on the page. I admit that having to use a PDF printer (CutePDF or Bullzip) complicates the issue. But it seems odd to me that I get different results between LO and OO, and between virtual printers.

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

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 into subform fields to allow me to update them. In OO everything is fine. The attached screenshots show

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

Good idea, but the relationships haven't changed from OO. The fields in the grid which have relationships are supplier and Region (both links into other tables by an identifier field). The former is displayed incorrectly in the grid, the latter correctly. Name and comments are both displayed

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

Thanks for the interest, Dan. The answers are: LO: LibreOffice 3.5.2.2 Build ID: 281b639-6baa1d3-ef66a77-d866f25-f36d45f OO: 3.3.0 build 9567 OS: Windows 7 64-bit Home Premium Table contents: They look the same. At least, there aren't any obvious oddities. (I've not exported them and done a

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

More developments - I copied the database to a Linux system and it opens correctly. So it seems to be a Windows-only issue. But the formatting on the Linux system was terrible! - Peter -- View this message in context:

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

Ubuntu. I think it's a fonts issue. But the formatting isn't exactly the problem. I'm far more worried about the problems in Windows, which is my normal desktop environment. - Peter -- View this message in context:

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

Not heard anything recently about my main problem (the fonts issue is a sideline). Anyone got any ideas? - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3905090.html Sent from the Users mailing list archive at

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

I've not been keeping up with the OO/LO saga. It strikes me as a bit mad to have two different products, each being developed with minimal resources, trying to compete with the MS juggernaut. United we stand, divided we fall. But that's a bit off-topic. Anyway, I've reported this as a bug to

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

So how does development happen? There seem to be two bug lists, and as I've demonstrated, they give different results on the same data (yuk). MS win by persuading industry (who are by far the dominant buyers - we single users are very much a minority and ignored by MS) that intercommunicability

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

Glad to hear it. But IMHO Base is just nowhere compared to Access (which itself isn't much to shout about). And OO Basic compared to VBA similarly. As an ex-programmer I'm always keen to automate any process, but the OO Basic learning curve turns many people off (as far as I can see from bulletin

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

Well, I seem to have started off quite a discussion. It's interesting that Andreas seems to agree with me that OO isn't really for programming. And the use of ODF is extremely important for intercommunicability, a point which isn't taken by many MS addicts. But I'm not trying to use a database

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

David-4 wrote What database doe you think works better than OpenOffice or LibreOffice? I don't. I found MS Access as easy to use and with a better-developed macro language. But I was not doing anything too complicated with it. The over-complex API (or is it just the way the documentation

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

Tom wrote Hi :) From what Andreas and others say i think that is most of the problem with Base.  Too many great ideas that only got half done.  I guess it might be the same with macros.  Apparently Andrew Pitonyak's guide is one of the best ways to get into macro programming

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

NoOp wrote On 04/15/2012 08:58 AM, David wrote: ... What database doe you think works better than OpenOffice or LibreOffice? Pick. I don't have any views on this matter. I vaguely remember that Lotus Approach allowed far more flexibility in allowing updates to multiple tables,

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

Andreas Säger wrote Why can't you run SQL update queries? This is trivial to do in SQL. The SQL is trivial to execute by macro. If you desparately want a graphical query designer for update/insert/delete queries, then you should write one and store your queries somewhere in the .odb

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

Pertti Rönnberg wrote Well said Peter! I totally and completely agree with you and Ian Whitfield. Well, someone likes me! My point is that I'm really a hacker when it comes to databases, not a professional coder, and life really needs to be made easier. I'm almost thinking of

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

Andreas Säger wrote Am 19.04.2012 13:00, ptoye wrote: I think I'm being misunderstood here. I've never mentioned trying to link Base and Word - that's not something I want to do. You do it all the time. All of your input forms are attached to Writer documents. All I originally

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

Hi Robert, Thanks very much for the database example. A lot to look at there - I'll have to take some time to work out exactly how your forms and macros work. Best regards, Peter mailto:l...@ptoye.com www.ptoye.com - Tuesday, January 24, 2017, 4:47:52 PM, you wrote:

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

a thought and it couldn't hurt. I think your use case is common enough that merits a discussion at least. On Fri, Jan 27, 2017 at 10:21 AM, ptoye <[hidden email]> wrote: > Hi Robert, > > I've had a look at some of your forms now, especially > filter_without_macros and I'm a

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

Friday, January 27, 2017, 6:05:01 PM, you wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Am 27.01.2017 um 16:21 schrieb ptoye: > Hi Robert, > > I've had a look at some of your forms now, especially > filter_without_macros and I'm a bit puzzled. I see that the table >

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

HI Tom, Thanks for this, but my basic question was whether there's an easier way than using macros :) I'm not frightened by macro programming (I wrote my first ever program in about 1961, and was in the profession for far too many years). Except for the difficulty in working out which method

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

Hi Robert, I've had a look at some of your forms now, especially filter_without_macros and I'm a bit puzzled. I see that the table in the Display part of the form is populated by the "filterquery" query, which references "filter". The table "filter" has one entry - the selection(s) I made in

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

- Hash: SHA1 Am 27.01.2017 um 16:21 schrieb ptoye: > Hi Robert, > > I've had a look at some of your forms now, especially > filter_without_macros and I'm a bit puzzled. I see that the table > in the Display part of the form is populated by the "filterquery" > que

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

I have a form which at present is based on a parameter query - the user types in a criterion and only the relevant database rows are shown.When I press a button a macro does various actions, including deleting the currently selected row. After all this I want to reload the form to get the latest

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

Robert, That sounds great - I'm sure I should have thought of this all by myself. But there's an added complication which I didn't mention before. When the user types in a criterion, this needs to populate a table on the form. He/she then selects a row which fills in some fields in the form.

[libreoffice-users] Re: Help needed - LO has lost my database

I've sort of sorted it by resetting my user profile. But of course it's lost all my settings :-(> But at least I've got my database back. - Peter -- View this message in context: http://nabble.documentfoundation.org/Help-needed-LO-has-lost-my-database-tp4205566p4205665.html Sent from the

[libreoffice-users] Help needed - LO has lost my database

I was debugging a macro in a database, using MRI and the Watch window) when LO suddenly crashed. I can't remember exactly what I was doing when it happened. On restarting LO it first said that it couldn't find the MRI library, which is loaded on application load. So I deleted the application

[libreoffice-users] Title bar for dialogs

I can't work out how to put text into the title bar for a dialog I'm creating. The dialog editor just doesn't seem to have any mechanism. Can some kind soul please put me out of my misery? - Peter -- View this message in context:

[libreoffice-users] Re: Title bar for dialogs

Thanks Robert. I knew it would be something like that, but hadn't thought of selecting outside the dialog frame. Right-clicking in the dialog does nothing much, nor does clicking on the title bar. But I'm finding that trying to select the dialog box, as opposed to the controls, is a very

[libreoffice-users] Problems exporting and importing a dialogue

I wanted to transfer a dialogue from a text document to the live version. So I went into the test doc "organise dialogs|Edit" window and exported the dialogue, which was called "OneOff", to a file. Went into the live version, found that I had to edit a dummy dialogue before I could import the

[libreoffice-users] Why is a custom menu item greyed out?

I've been trying to add a custom menu to a document. I go through the motions of adding the menu and saving it within the document, but when I click on it, or any other menu on the menubar, it is greyed out. Assigning the menu item to a macro action has no effect on this. Also, if I put in

[libreoffice-users] Re: Why is a custom menu item greyed out?

Hi Robert, I've tried it for both Write and Calc documents. The menu is a custom menu to add some extra features to the document. As it's a test the assigned macro displays a messagebox. The attached document is a Write document which gives the error - open it and click on any menu item. Best

[libreoffice-users] Issues with date fields in dialogues

I've been experimenting with date fields in dialogues and have found what I think is an anomaly. As I understand it, a date field is intended to hold a single date in its model. This can be viewed when the dialogue is displayed. Apart from initialising it within the editor, there are at least

[libreoffice-users] Re: Problems exporting and importing a dialogue

I don't think you can simply copy and paste an entire dialogue. I tried it and it didn't work. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-exporting-and-importing-a-dialogue-tp4204239p4204267.html Sent from the Users mailing list archive at

[libreoffice-users] Re: Issues with date fields in dialogues

Hi Robert, What you say is of course all true. But it's not to do with database records (my original experiments were in fact on a spreadsheet), but the data as held in the dialog(ue). Your method (thanks again) of copying a UNO Date into the field works fine, as does changing the text. But

[libreoffice-users] Re: Problems exporting and importing a dialogue

Andreas, Thanks again. Regina's comment answered my questions. I'm not sure why you say it's best to avoid the "Standard" library, though. I tend to store my dialogues and macros within the document, as they're usually specific to the document. After all, a dialogue for updating my wines

[libreoffice-users] Re: Issues with date fields in dialogues

Andreas, Thanks Andreas, that's very helpful. But it doesn't seem to cover the presentation and updating of date fields in dialogues (as opposed to cells in a spreadsheet), which was my concern. I've found some anomalies in this which I've reported as a minor bug. Best regards, Peter

[libreoffice-users] Re: How to insert the date into a date field in a dialog

Thanks Robert. That works fine. Someone else on the LO Ask platform also suggested which also seems to work OK. (I don't think you need the View - it seems to work either way). - Peter -- View this message in context:

[libreoffice-users] Re: Why is a custom menu item greyed out?

Virgil, Odd. It seems that your experience is the opposite of mine, but I don't have a Linux system that I can try it out on. - Peter -- View this message in context: http://nabble.documentfoundation.org/Why-is-a-custom-menu-item-greyed-out-tp4204211p4204321.html Sent from the Users

[libreoffice-users] Re: Problems exporting and importing a dialogue

Gordon, I am referring specifically to a Dialog(ue), not to text within a file. - Peter -- View this message in context: http://nabble.documentfoundation.org/Problems-exporting-and-importing-a-dialogue-tp4204239p4204319.html Sent from the Users mailing list archive at Nabble.com. -- To

[libreoffice-users] Re: Problems exporting and importing a dialogue

Regina, See my comments below. Best regards, and a successful new year, Peter mailto:l...@ptoye.com www.ptoye.com - Wednesday, January 4, 2017, 12:31:35 AM, you wrote: Hi Peter, ptoye schrieb: > I wanted to transfer a dialogue from a text document to the l

[libreoffice-users] Re: Problems exporting and importing a dialogue

Gabriele, A Dialogue (or Dialog if you like the US spelling) is a feature of Libre Office which does not appear to be documented anywhere in the User Guides. It allows you to display a window with controls (much like a form) so that the user can interact with the document at runtime. Look in the

[libreoffice-users] Re: Why is a custom menu item greyed out?

OK, I've found the answer from someone on the LO Ask forum (why are there two?). It seems that LO doesn't allow you to click on a menu item unless there's an action associated with it. Seems sensible, but I was designing the user interface before writing the macros. Once I'd added the actions all

[libreoffice-users] How to insert the date into a date field in a dialog

I want to display today's date in a date field in a dialog. So before displaying the dialog I have code like (3 different ways of trying to do it): Can some kind soul please tell me what I'm doing wrong? And how to do it right? - Peter -- View this message in context:

[libreoffice-users] Re: Title bar for dialogs

Thanks Cor. Robert answered the question. I should have specified that it was the IDE I was asking about rather than how to do it by program (but that's useful as well). - Peter -- View this message in context:

[libreoffice-users] Breakpoints not working

I'm trying to debug a LO Basic program, and have set a breakpoint, but the code sails merrily through it without breaking. Is there something else I should be doing to get the program to break? - Peter -- View this message in context:

[libreoffice-users] Re: Breakpoints not working

Peter, ptoye schrieb: > I'm trying to debug a LO Basic program, and have set a breakpoint, but the > code sails merrily through it without breaking. Is there something else I > should be doing to get the program to break? That happens only in the first run. Further runs will sto

[libreoffice-users] syntax error in SQL - error 1000

I have a query which works fine. But when I edited it in the graphical query editor LO refused to save it saying that there was an SQL error. The detailed message was "syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE". Even if I try to save the unedited version I get the

[libreoffice-users] Re: syntax error in SQL - error 1000

Thanks Robert You are a mine of information. Peter - Peter -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

[libreoffice-users] Where have the update notifications gone?

I'm using LO 5.2.5.1, and have just discovered that the stable version is now 5.3.5. I've had no notification of this (as far as I can see), and the update check says that "LibreOffice 5.2 is up to date." which isn't much help! Does anyone here know what's going on? - Peter -- View this

[libreoffice-users] Database corruption since LO 5.7.3 installed

Since upgrading to LO 5.7.3 a database of mine keeps getting corrupted. When I try to open it it opens in Writer with the text Ó×r6ÒÒ#v If I try opening it in a Zip file reader I'm told it's not a valid Zip file. It's not consistent though; sometimes it opens OK. It's an embedded HSQLD database

[libreoffice-users] Re: Database corruption since LO 5.7.3 installed

Thanks Robert. Restoring from a backup is exactly what I've been doing. But it's odd. It's a database I use about once or twice a week (depending on how much wine I've been drinking), and it's failed to open 4 times since then: the saved dates were 26 November, 24 December, 27 December and 5 Jan.

[libreoffice-users] Conditional formatting in Calc: how to find it?

I have a spreadsheet with some cells with conditional formatting applied. Unfortunately I don't know what formula or style was used. I tried the Format | Condition | Edit option but all I got was this: The condition

[libreoffice-users] Re: Database corruption since LO 5.7.3 installed

I think that the first thing to do is to work out if the corruption's happening on loading or saving. It's easy to see what's happening as the corrupted file is of a very different size, so I can see it in Explorer. That at least will give me a handle on the problem. Then I can work out whether to

[libreoffice-users] Re: Database corruption since LO 5.7.3 installed

Thanks Robert, that's fantastic. I'll try it out later this week. - Peter -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Re: Conditional formatting in Calc: how to find it?

The LO version is 5.3.7.2 (x64) which I think is the latest stable version. The bug is at https://bugs.documentfoundation.org/show_bug.cgi?id=114909 The LO staff think it isn't a bug because it's OK in later unstable versions. There isn't a Format > Conditional Formatting menu item in my

[libreoffice-users] Re: Database corruption since LO 5.7.3 installed

Robert Großkopf wrote > You could use the macro for copying the file to the backup-folder of LO > when opening the file. It's published in the Base-Handbook. I could post > it here also. That would be very useful Robert. I've found that the corruption is happening when I close LO. So saving when

[libreoffice-users] Re: Database corruption since LO 5.7.3 installed

Thanks, but at the moment I'm making manual backups. Unfortunately (?) it hasn't happened again. Very frustrating. - Peter -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Re: Window corruption in macro editor

Jean-Francois Nifenecker wrote > Could be some video artefact. Did this happen suddenly? You could > uncheck the video acceleration check and see what is gives. > > I'm using the macro editor heavily under Windows 7 and Debian Linux 8.1 > without any problem (using LO 4.3.x, 5.4.x and 6.0.0. No

[libreoffice-users] Window corruption in macro editor

The window in the macro editor keeps being corrupted. Most of the time a portion of the top left-hand corner of the editing window seems to be trying to mirror the text in the rest of the window (if you see what I mean). But sometimes the corruption starts at the top left-hand corner of the object

[libreoffice-users] Re: Database corruption since LO 5.7.3 installed

Robert Großkopf wrote > here the macro for saving data while opening or running Base: Thanks Robert, that's fantastic. I'll try it out later this week. - Peter -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to:

[libreoffice-users] Re: Conditional formatting in Calc: how to find it?

I took your advice and started with a new profile (backedup up the original first). And the format menu has changed and looks better. Now all I have to do is rescue the bits of the profile that I need like templates. How can this happen? I recently changed from 32- to 64-bit LO. Would this have

[libreoffice-users] Using R1C1-type formulae in Calc macros

Is it possible to get and set formulae in a Calc cell using R1C1 rather than A1 strings? I found that even if the option to use R1C1 is set in the Tools | Options menu, the value of Cell.Formula is still in A1 format. If not, I'll suggest it as an option. As I recall from many years ago using

[libreoffice-users] Re: How can I reassign a macro to a custom toolbar button?

Thanks Jorge. Sorry about the delay - I thought I'd replied to this but it hasn't appeared. I'm still on LibO 5.4 which probably explains the difference in the messages. I don't have much spare time for editing help files, and I've had a bad time when trying to help with the documentation. The

[libreoffice-users] Re: How can I reassign a macro to a custom toolbar button?

it and I'm surprised that the designers didn't think of a more user-friendly way of reassigning. Your suggestion implies that they didn't. I had assumed that I'd missed something simple. I still think it would be a good thing if the help system mentioned this mechanism. jorge Rodríguez wrote > Hi Ptoye and

[libreoffice-users] Re: Window corruption in macro editor

It's still happening in LibO 5,4,5,1 64-bit. And it's a real PITA as one a minute I have to minimise and then restore the window. Has no-one else seen this? - Peter -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to:

[libreoffice-users] How do I use a singleton in LibO basic?

I want to use one of the API singletons (com.sun.star.util.thePathSettings since you ask) but I can find nothing in the documentation telling me how to create the (only) instance so I can get some of the properties. As I understand singletons, they have a hidden constructor, and some form of

[libreoffice-users] Re: How do I use a singleton in LibO basic?

Thank you so much for this. I had no idea that you had first to get a context - I hadn't found this in the documentation (but will now have another look). It's working fine now. - Peter -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to:

[libreoffice-users] How can I reassign a macro to a custom toolbar button?

I have been moving a few macros about, and want to reassign their toolbar buttons. So I go to the Macro | Organiser, select the macro, click "assign", select the toolbar button and click "OK". And nothing happens. There's nothing in the help file about it - the "assigning scripts in LibO" (why