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

[ptoye]

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
VBA there was a FormualR1C1 (or something like it) property, and when
setting up a formula which references many items on the same row or column
it's a lot easier to use (IMHO).



-
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 helpful scripts are
Linux-based and I'm a Windows user (sorry!) so trying to modify documents is
a seriously hard job. Also, I'm just a user and don't have any in-depth
knowledge, which means that anything I wrote would be either incomplete
(annoying) or wrong (bad). It's only when I find things which are actually
wrong in the documentation or code that I try to get involved, and in the
latter case I am certainly in no position to help.


jorge Rodríguez wrote
>          You can do the same process but more directly with : 
> Menu-Tools-Customize
> 
>          I was using for this explanation: LO 6.0.1.1 with English setting
> 
>          By the way, The Document Foundation organization, that is in 
> charge to development LibreOffice, is needing voluntaries to update the 
> documentation and help, to the new version: 6.0. If you want to 
> contribute with this, you can e-mail to this list to Olivier Hallot to 
> know more about this.





-
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

Firstly - sorry to all. I was getting extremely frustrated in trying to do
what looks like a simple thing, but obviously isn't.

I'm finding it a bit difficult to follow your instructions - I suspect that
you are using a different language (Spanish?) from myself.

In Step 2 there isn't a "All Commands" button - but there's an "Add command"
button - is this what you meant?

What you have suggested here - and many thanks for this - seems to be what I
found out by myself: add new buttons and remove the old ones. This is a very
long-winded way of going about 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 all:
> 
>      At first, try to be more polite because almost all us are 
> volunteers and collaborate as we can and all of us try to do better.
> 
>      As I understand, you can reassign a macro following this steps (Or 
> solve your problem like this) :
> 
> 1) Menu-Tools-Macros-Organize Macros-LibreOffice Basic (I use this 
> because is the only programming language that I've used to make a macro 
> and assign to a toolbar. I don't know if using other language is the 
> same to do it.)
> 
> 2) Select Assign icon to open a Dialog Window. There select Toolbars and 
> click on "All Commands" option. Scroll down to find Macros and select it.
> 
> 3) In the Chart Function, appear the places where your macros should be
> 
> 4) Found what you need
> 
> 5) Now, at right, you can see the Options bar (Default Standar), where 
> you can select whatever toolbar existing in LibreOffice Calc. But now, 
> select the + icon that it place at right of it.
> 
> 6) Appear a Dialog Window where you can input a name ("MyTools" for 
> example), to make a new toolbar where you can assign all your Macros or 
> only some of them. Select too the place where it will be saved (Option 
> below).
> 
> 7) Now, select the macros that you previously found ( Chart Function 
> -point  4 ), and with the Arrow to right move to new toolbar "MyTools" 
> all the Macros that you want.
> 
> 8) Click "Ok" and then Close the Window. In the area of the toolsbars 
> (Top of your spreadsheet), below the two first default bar, you can find 
> your new MyTools bar icons that each one run each macro assigned.
> 
> 9) The last step is to eliminate the macros of the other toolbar where 
> you had assigned some of the macros and where you couldn't find place 
> for all of them. I hope you know how to do this to doesn't duplicate 
> icons in your spreadsheets (Two bar of them with some same icons that do 
> the same). If you had problem, can request again to the user e-mail list 
> of LibreOffice.
> 
> I hope this help,
> 
> Jorge Rodríguez





-
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 can't they use the word "macro"?) page tells me how to assign a macro
to a new button, but not how to change an assignment. Did the designers
really forget that this might be needed?



-
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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
creator method which ensures that only one instance exists. But the
documentation for the singleton does not have any such method. I've tried
various syntactic forms to create one, none of which has worked.

Can some kind soul please put me out of my misery?

I know that I can use PathSettings, but this is deprecated, and I prefer to
be up-to-date.

I'm using LibO 5.4.5.1 if that helps.



-
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 problem so far).
> 
> BTW, what is the version of LibO?

I think it happened when I upgraded LibO to 5.3.7.2 64-bit. I'd been on
32-bit before that. Is that likely to be an issue?

I assume you're talking about the hardware acceleration in Windows.
Unfortunately that options is greyed out on my machine, so I assume it's not
possible.




-
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Window corruption in macro editor

[ptoye]

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
catalog as well as is the screenshot below. It happens very frequently and
seems to happen when I either move the mouse into the window or click on
something. I can recover by minimising and restoring the window, but as it
happens once every few minutes it's a right PITA.

Has anyone else here seen anything like this? 

If it makes any difference, the macro is for a Base file. The OS is Windows
7.

 



-
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 made a difference?



-
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 I open, and also possibly before
closing might at least preserve the data.

I suspect that the best solution would be to install HSQLDB on my machine
and separate the database from the LO front-end. This sounds like a bit of a
pain, though.




-
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 version of
Calc.  That's the problem. See the screenshot.

 



-
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 certainly isn't an equality, and the style certainly isn't
"default", so it's not showing me what's actually there.

Is there any way of finding out what format's been applied? The help file
directs me to a non-existent menu item (sent to Bugzilla).



-
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 make a copy on loading - not much point if that's what does the
corruption.



-
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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. I've
used it more often, though, and I've decided to save a copy whenever I save
the original. And possibly I'll save the original before opening it as well.

I agree that the database is corrupt, but what's corrupting it? I haven't
had any such corruptions on any other LO documents (famous last words?) or
other files. I've had a closer look, and the corrupt files seem to be the
last 46 KB (approx) of the original (which are 184 KB).

Both LO and Java are 64-bit versions.  Is it a good idea to revert to 32-bit
versions? I'm not sure how LO decides which Java to use if given the choice;
I assume it picks up the same bit-version. Bugzilla doesn't show any obvious
connection between 64-bit and database corruption.



-
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Database corruption since LO 5.7.3 installed

[ptoye]

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 and I'm running Windows 7.

Has anyone else here seen this? It doesn't seem to be in Bugzillla.



-
Peter
--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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
error, which I find a bit bizarre. But it runs OK and gives the correct
result.

The SQL for the query is 

SELECT "Wines"."ID", "Wines"."Wine_Name" "Name", "Wines"."Year",
"Suppliers"."Name" "Supplier", "Wines"."Price", "Regions"."Region",
"Wines"."Bottles_Bought", "Wines"."Bottles_Left" "Left", "Wines"."Buy_Again"
"Buy", "Wines"."Avoid", "Wines"."Bin_End", "Wines"."Alcohol",
"Wines"."Acquired", "Wines"."Drink_By", "Wines"."Comments", "Styles"."Style"
FROM "Wines", "Suppliers", "Regions", "Styles" WHERE "Wines"."Supplier_Id" =
"Suppliers"."Id" AND "Wines"."Region_Id" = "Regions"."Id" AND
"Wines"."Style_Id" = "Styles"."Id" AND UCASE( "Wines"."Wine_Name" ) LIKE
UCASE( '%' || ( SELECT "filterstring" FROM "tblfilter" ) ) || '%'

I suspect that the problem is in the last clause.

The underlying database is HSQLDB.







-
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/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 message in context: 
http://nabble.documentfoundation.org/Where-have-the-update-notifications-gone-tp4221321.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

Robert,

Sorry not to have been back sooner  - I got distracted by some more important 
work than managing my wine.

I've worked out now how your  filter_without_macros works now, and am in the 
process of adding the procedures into my database. 

I've also found your Base handbook on the LO website. It's really useful, and a 
pity it wasn't there when I started working with Base (some years ago now).

So double thanks.

Best regards,

Peter
mailto:l...@ptoye.com
www.ptoye.com

-
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 
> 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 the listbox. But I can't see how the 
> listbox selections get put into the "filter" table. Can you please 
> help me there? 

Could be this is a special behavior of Base-forms. There are two forms 
beneath each other. One form for "filter" and one for "display". I 
change values in "filter". I move to a button in "display". The 
content of "filter" will be saved when I push the button in "display" 
before the action of the button will happen. So there is needed only 
one button, which should refresh the form "display". The query for 
this form will be filtered by the entries in the table "filter". 


> I also can't understand why there are two columns in the 
> "listbox_n_simple", but that's of less importance. 

Most listboxes will show some text-content, but are linked to a table 
by an Integer-primarykey. So queries for listboxes look like 
SELECT "name", "ID" form "table_names" 
"name" will be shown. "ID" will be saved in the column of the form. 

You must have a look in the properties > data of the listbox. The 
"bounded field" will be '1' by default - and '1' is (a little be 
confusing, because it begins with '0') the second field. 

If the same content should be shown as it will be saved you could set 
this to '0' - so there must be only asked for one field. 

You could also set this to '-1'. This will save the numer of the row. 
I have never used this, but it works ... 

Regards 

Robert 
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE- 
Version: GnuPG v2 

iQIcBAEBAgAGBQJYi4ucAAoJELDKYwaoS9AITnoQAKhjm6204tHi/aeQy2N9cIZp 
jzmXXg6NnQDwy6nGgSMjdoBjtFBMbwwfl76qNJMAQKtN5qigKPah3mBlnR04Yize 
NWRCpFuQdYXyv6FqChXh3EdGktfS4eMwpMAgLDaey3Zcbno7tXtetQ7YlJc7iGjd 
0eVEw/4Bk0TtDJ3hBLQ3aBe61RKwZnt2h+1V8rJQfvPbWPiSMNr/YznotaKIXSbJ 
zLrm6u97BeIcXd5E2K+lXxdmvDHacH5zKbv6j8B3h+D3JrHo5OzG62hYpYptmuh8 
dpKgC1D9Wpe3x96Of/5vz82E+csMJqk7VNrT0WgULdrPUy6oqxGoRZviKnS9QwmQ 
Et8mDm2PPZGdnvcns4lIaGLwkCPU9ZRyk08Oq1aeWvLp6I5E8M1KKblEURDbMr9W 
CTKJVkrEEiVj+MJux+b02GPrLCWIMv0TSoV7L8yiOQLSCb2EPh0DOsm/w3SMYo+t 
qV/+nXgdwHztVMZ5F8y33CaWl6LuMMiQJCHZAIY3Wu4qEQlD668J/zVDOA+I/m7I 
UG0K96RKNtXGYvf8tWidBhCLaBxaxadmmgfb0yD2r6pWipL6kBJdRWDSlOBczHJT 
/BEJQixwe0RgleThXF9AO9hWepq811WOXUF7Sr/XXrIt3ojzYhVgopqHttf5ofJ3 
93NMpdUU7TC9gmjU8JVp 
=u2Z4 
-END PGP SIGNATURE- 

-- 
To unsubscribe e-mail to: [hidden email] 
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted 




If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206382.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4207833.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 
> 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 the listbox. But I can't see how the 
> listbox selections get put into the "filter" table. Can you please 
> help me there? 

Could be this is a special behavior of Base-forms. There are two forms 
beneath each other. One form for "filter" and one for "display". I 
change values in "filter". I move to a button in "display". The 
content of "filter" will be saved when I push the button in "display" 
before the action of the button will happen. So there is needed only 
one button, which should refresh the form "display". The query for 
this form will be filtered by the entries in the table "filter". 
But how is the listbox connected to the table? The only connection I can see is 
by the name. I think it would be strange to say that a control with a name it 
automatically linked with at table of the same name. Also, the "ID" field in 
the "filter" table is set to YES, while its default is NO, which implies that 
something is changing it.




> I also can't understand why there are two columns in the 
> "listbox_n_simple", but that's of less importance. 

Most listboxes will show some text-content, but are linked to a table 
by an Integer-primarykey. So queries for listboxes look like 
SELECT "name", "ID" form "table_names" 
"name" will be shown. "ID" will be saved in the column of the form.
The query is SELECT "Sys.", "Sys." FROM "searchtable" GROUP BY "Sys." ORDER BY 
"Sys." ASC
So both columns will have the same contents.

 

You must have a look in the properties > data of the listbox. The 
"bounded field" will be '1' by default - and '1' is (a little be 
confusing, because it begins with '0') the second field. 
Some people start with 0, others with 1. It gets confusing when they're both 
working on the same project.


If the same content should be shown as it will be saved you could set 
this to '0' - so there must be only asked for one field. 

You could also set this to '-1'. This will save the numer of the row. 
I have never used this, but it works ... 
I've not heard of that. Thanks. Could be useful.


Regards 

Robert 
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE- 
Version: GnuPG v2 

iQIcBAEBAgAGBQJYi4ucAAoJELDKYwaoS9AITnoQAKhjm6204tHi/aeQy2N9cIZp 
jzmXXg6NnQDwy6nGgSMjdoBjtFBMbwwfl76qNJMAQKtN5qigKPah3mBlnR04Yize 
NWRCpFuQdYXyv6FqChXh3EdGktfS4eMwpMAgLDaey3Zcbno7tXtetQ7YlJc7iGjd 
0eVEw/4Bk0TtDJ3hBLQ3aBe61RKwZnt2h+1V8rJQfvPbWPiSMNr/YznotaKIXSbJ 
zLrm6u97BeIcXd5E2K+lXxdmvDHacH5zKbv6j8B3h+D3JrHo5OzG62hYpYptmuh8 
dpKgC1D9Wpe3x96Of/5vz82E+csMJqk7VNrT0WgULdrPUy6oqxGoRZviKnS9QwmQ 
Et8mDm2PPZGdnvcns4lIaGLwkCPU9ZRyk08Oq1aeWvLp6I5E8M1KKblEURDbMr9W 
CTKJVkrEEiVj+MJux+b02GPrLCWIMv0TSoV7L8yiOQLSCb2EPh0DOsm/w3SMYo+t 
qV/+nXgdwHztVMZ5F8y33CaWl6LuMMiQJCHZAIY3Wu4qEQlD668J/zVDOA+I/m7I 
UG0K96RKNtXGYvf8tWidBhCLaBxaxadmmgfb0yD2r6pWipL6kBJdRWDSlOBczHJT 
/BEJQixwe0RgleThXF9AO9hWepq811WOXUF7Sr/XXrIt3ojzYhVgopqHttf5ofJ3 
93NMpdUU7TC9gmjU8JVp 
=u2Z4 
-END PGP SIGNATURE- 

-- 
To unsubscribe e-mail to: [hidden email] 
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted 




If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206382.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206441.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

Hi Drew,

I'm very happy to hear that Base is being worked on. It's always struck me as 
the Cinderella app in the suite.

Would you like me to issue a RFE or will you do it yourself?

IMHO, even more important than this would be Update and Delete queries. It's 
been decades since I used MS Office, but I remember them as being available in 
about 2000. And very useful as one doesn't have to learn SQL.

Best regards,

Peter
mailto:l...@ptoye.com
www.ptoye.com

-
Friday, January 27, 2017, 5:43:50 PM, you wrote:


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 parameter 
variables entered on the initial load. 

Just 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 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 the listbox. But I can't see how the listbox selections get put 
> into the "filter" table. Can you please help me there? I also can't 
> understand why there are two columns in the "listbox_n_simple", but that's 
> of less importance. 
> 
> Best regards, 
> 
> Peter 
> mailto:[hidden email] 
> www.ptoye.com 
> 
> - 
> Tuesday, January 24, 2017, 4:47:52 PM, you wrote: 
> 
> 
> -BEGIN PGP SIGNED MESSAGE- 
> Hash: SHA1 
> 
> Hi Peter, 
> 
> have a look here: 
> http://robert.familiegrosskopf.de/lo_hb_en/Example_Search_and_Filter.odb
> 
> You don't need anything elese but a form and a subform. The example 
> includes different forms, some of them working without any macro. 
> 
> Regards 
> 
> Robert 
> - -- 
> Homepage: http://robert.familiegrosskopf.de
> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
> -BEGIN PGP SIGNATURE- 
> Version: GnuPG v2 
> 
> iQIcBAEBAgAGBQJYh4UDAAoJELDKYwaoS9AIy1oP/R1xM/+twczhn62h/pW5zO0k 
> bUmslOk2lYV6kkAQmFi3XoW6AMt9hr4sFsmPuJ0CB3eSsNl/T3OdA+h4BZRMah5N 
> huQJkY2WrjiKFda94TXlqKUG4NgFvJ5Gl1PL7DK/3hi4NMLS/kDbpJcvzto9LM3q 
> alJi9rZfq6IZ3Cdq198l+biawMxJ7DbDxfzynx6G8x59G89rmA3iBs67jP2ZRYpL 
> SNuOZYLE/FCmseqktrkbS5BBgANckb37uh89sTh3XSe3OXGTQkzel+51ndky7Qs6 
> rUbRReaG6+JFgl883mzIDroSsQjcJyQk+sapv53P8OkUiMhyUPvT1KdrUDdVTIOQ 
> gJzPyo8EqXtvajmf2xe5O9zTirR0XZfca1KdtdbVjFv4iTZRgW93HWzwnwGl48W3 
> q8qdRz++FmskI0J3zxE6LbL0ff3bf1LDsaa1vub+IKIzOhDGZ1Lf+Q7U15vx5eBd 
> hexDVCgvu1suiDtJ9rh95IZcyEHFk6BBAOokE97hpbwjlfBsLMlluJ6etsNDYxwa 
> 3gozscxhLkzQpFAopp+76MxlI39/ktrCFgUGQfTBajj/74Dfvf1j0dQwoYh41fz5 
> JFeDTm/YN4ZRsw7BEvE+FQuOoG08F5v02DesZ+2+8euA3hVMynb/PQI47o024WDd 
> ILXQuH+aT+/Mas+L4BdB 
> =zULF 
> -END PGP SIGNATURE- 
> 
> -- 
> To unsubscribe e-mail to: [hidden email] 
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/ 
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be 
> deleted 
> 
> 
> 
> 
> If you reply to this email, your message will be added to the discussion 
> below: 
> http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-
> parameter-query-tp4206066p4206117.html 
> To unsubscribe from Can I reload a form based on a parameter query?, click 
> here. 
> NAML 
> 
> 
> 
> - 
> Peter 
> -- 
> View this message in context: http://nabble.documentfoundation.org/Can-I-
> reload-a-form-based-on-a-parameter-query-tp4206066p4206363.html 
> Sent from the Users mailing list archive at Nabble.com. 
> -- 
> To unsubscribe e-mail to: [hidden email] 
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/ 
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be 
> deleted 
> 
> 

-- 
To unsubscribe e-mail to: [hidden email] 
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All message

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

[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" query, which references "filter". The table 
"filter" has one entry - the selection(s) I made in the listbox. But I can't 
see how the listbox selections get put into the "filter" table. Can you please 
help me there? I also can't understand why there are two columns in the 
"listbox_n_simple", but that's of less importance.

Best regards,

Peter
mailto:l...@ptoye.com
www.ptoye.com

-
Tuesday, January 24, 2017, 4:47:52 PM, you wrote:


-BEGIN PGP SIGNED MESSAGE- 
Hash: SHA1 

Hi Peter, 

have a look here: 
http://robert.familiegrosskopf.de/lo_hb_en/Example_Search_and_Filter.odb

You don't need anything elese but a form and a subform. The example 
includes different forms, some of them working without any macro. 

Regards 

Robert 
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE- 
Version: GnuPG v2 

iQIcBAEBAgAGBQJYh4UDAAoJELDKYwaoS9AIy1oP/R1xM/+twczhn62h/pW5zO0k 
bUmslOk2lYV6kkAQmFi3XoW6AMt9hr4sFsmPuJ0CB3eSsNl/T3OdA+h4BZRMah5N 
huQJkY2WrjiKFda94TXlqKUG4NgFvJ5Gl1PL7DK/3hi4NMLS/kDbpJcvzto9LM3q 
alJi9rZfq6IZ3Cdq198l+biawMxJ7DbDxfzynx6G8x59G89rmA3iBs67jP2ZRYpL 
SNuOZYLE/FCmseqktrkbS5BBgANckb37uh89sTh3XSe3OXGTQkzel+51ndky7Qs6 
rUbRReaG6+JFgl883mzIDroSsQjcJyQk+sapv53P8OkUiMhyUPvT1KdrUDdVTIOQ 
gJzPyo8EqXtvajmf2xe5O9zTirR0XZfca1KdtdbVjFv4iTZRgW93HWzwnwGl48W3 
q8qdRz++FmskI0J3zxE6LbL0ff3bf1LDsaa1vub+IKIzOhDGZ1Lf+Q7U15vx5eBd 
hexDVCgvu1suiDtJ9rh95IZcyEHFk6BBAOokE97hpbwjlfBsLMlluJ6etsNDYxwa 
3gozscxhLkzQpFAopp+76MxlI39/ktrCFgUGQfTBajj/74Dfvf1j0dQwoYh41fz5 
JFeDTm/YN4ZRsw7BEvE+FQuOoG08F5v02DesZ+2+8euA3hVMynb/PQI47o024WDd 
ILXQuH+aT+/Mas+L4BdB 
=zULF 
-END PGP SIGNATURE- 

-- 
To unsubscribe e-mail to: [hidden email] 
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted 




If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206117.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206363.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 applies to which object, 
but that's a documentation issue.

Best regards,

Peter
mailto:l...@ptoye.com
www.ptoye.com

-
Thursday, January 26, 2017, 2:49:47 PM, you wrote:


Hi :) 
Chapter 13 of the "Getting Started with LibreOffice" Guide may help with 
understanding macros.  There is an outstandingly good entire book about 
LibreOffice/OpenOffice macros by Andrew Pitonyak but that probably goes 
into far more detail than you need right now. 
Regards from 
Tom :) 

If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206277.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206352.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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:


-BEGIN PGP SIGNED MESSAGE- 
Hash: SHA1 

Hi Peter, 

have a look here: 
http://robert.familiegrosskopf.de/lo_hb_en/Example_Search_and_Filter.odb

You don't need anything elese but a form and a subform. The example 
includes different forms, some of them working without any macro. 

Regards 

Robert 
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE- 
Version: GnuPG v2 

iQIcBAEBAgAGBQJYh4UDAAoJELDKYwaoS9AIy1oP/R1xM/+twczhn62h/pW5zO0k 
bUmslOk2lYV6kkAQmFi3XoW6AMt9hr4sFsmPuJ0CB3eSsNl/T3OdA+h4BZRMah5N 
huQJkY2WrjiKFda94TXlqKUG4NgFvJ5Gl1PL7DK/3hi4NMLS/kDbpJcvzto9LM3q 
alJi9rZfq6IZ3Cdq198l+biawMxJ7DbDxfzynx6G8x59G89rmA3iBs67jP2ZRYpL 
SNuOZYLE/FCmseqktrkbS5BBgANckb37uh89sTh3XSe3OXGTQkzel+51ndky7Qs6 
rUbRReaG6+JFgl883mzIDroSsQjcJyQk+sapv53P8OkUiMhyUPvT1KdrUDdVTIOQ 
gJzPyo8EqXtvajmf2xe5O9zTirR0XZfca1KdtdbVjFv4iTZRgW93HWzwnwGl48W3 
q8qdRz++FmskI0J3zxE6LbL0ff3bf1LDsaa1vub+IKIzOhDGZ1Lf+Q7U15vx5eBd 
hexDVCgvu1suiDtJ9rh95IZcyEHFk6BBAOokE97hpbwjlfBsLMlluJ6etsNDYxwa 
3gozscxhLkzQpFAopp+76MxlI39/ktrCFgUGQfTBajj/74Dfvf1j0dQwoYh41fz5 
JFeDTm/YN4ZRsw7BEvE+FQuOoG08F5v02DesZ+2+8euA3hVMynb/PQI47o024WDd 
ILXQuH+aT+/Mas+L4BdB 
=zULF 
-END PGP SIGNATURE- 

-- 
To unsubscribe e-mail to: [hidden email] 
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted 




If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206117.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206255.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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. the user then has the 
option of changing some of them before clicking the button. So it seems that I 
need two levels of subform - one for the table and one for the fields (rough 
diagram below). Do you know if LO can handle this or will I have to experiment?

Criterion
|
|Table
   |
   |Fields

Best regards,

Peter
mailto:l...@ptoye.com
www.ptoye.com

-
Monday, January 23, 2017, 7:37:14 PM, you wrote:


-BEGIN PGP SIGNED MESSAGE- 
Hash: SHA1 

Hi Peter, 

> 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 version (without the deleted 
> row). But a straight Form.Reload asks again for the criterion, 
> which I don't want. 
> 
> Is there any way of doing this? The only way I can think of is to 
> use a dialogue or input box to allow the user to input the 
> criterion and base the query on a SELECT clause incorporating the 
> criterion. 

You could better put the parameter-values in a form and the query in a 
subform. The values in the form could be saved in a table with only 
one row. Call it "filter" ore something else, primarykey is a boolean 
yes-no-field. So you could type the parameter, change to the subform 
and the subform will be reloaded. It will also be reloaded without 
asking again for the paramter, because this is written down in the 
mainform. 

Regards 

Robert 
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE- 
Version: GnuPG v2 

iQIcBAEBAgAGBQJYhlsvAAoJELDKYwaoS9AIA2oQAIVHOOeYxoDNA4ZTg3xSNd3Z 
TLi8XosfAzjeef9KpUJlj4YI5r4ybB2HdJgKz9iEeOvQYe871DoDx87w7PNdRRuu 
WuimnIhDshPMdvGaBNJeZ4NlrlUMb2cAuGfyLlPBG8z0hqyLgDBU2qRIkHta+I8Y 
KmQgjmrPLzI1/M+rIDaUhYn0hxYqg0AM4vPRk+a1z1brdeWEwWxqPcHZ+cWqRUGg 
p+SaiBsU9BLDrUZkKhCpxQp2NXm6hy3RmS/UY1qiP5X8YM+//3BjjwT6l25HhEs4 
RDkOJGiI2P+bffqNzHmdMgz3JyNMCYPINfhV7NkRL95ZdmzDOK5iOXDUGJyXjCPx 
rSSoh3ncl9VWqvam15x1i6ZFZ8iYYbU4xngZsmpT/xH19NrWfvawXDQYcxtrT25E 
CfAo4tiJXgA+3QhjOkjuxzRGGEHRXUCIau7Cyi6T/HgHziARW7hyttR51Kfb83+l 
JXuTcjd+5V861km0Kz62XsLthvhIAIFTIE+QI1xeWdzWZUW4oiL1kdZ8OewllYdx 
kMGFoK3OGPTg7FvIf1zfi6M6PKYL3PWVAzHS/D17R+mGKrC+bue1wrWnZs1fvi0J 
uN9Ie+WqsySO5Hnvc7aTE19hj5k8ETdYiGE5Kd/LQ3EXko/rNAfJ7oc/bRWSWE4x 
mV76ym7os90knS+I67NL 
=oFmg 
-END PGP SIGNATURE- 

-- 
To unsubscribe e-mail to: [hidden email] 
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted 




If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206067.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206101.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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
version (without the deleted row). But a straight Form.Reload asks again for
the criterion, which I don't want.

Is there any way of doing this? The only way I can think of is to use a
dialogue or input box to allow the user to input the criterion and base the
query on a SELECT clause incorporating the criterion.



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 startup macro.
It's true - the MRI library has disappeared.

Then I tried reinstalling MRI. Clicking the Tools|Extension Manager menu
item did nothing the first time. Clicking it again gave me the window, but
when I clicked the "Add" button I got this:

 

Worse to come: when I opened my database and tried to access the tables in
it I got:

 

So now I can't load MRI and I can't get at my data.

Any ideas as to how I can get them both back - PLEASE!!



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Help-needed-LO-has-lost-my-database-tp4205566.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 database would be pretty silly in 
my account spreadsheet :-)

Best regards,

Peter
mailto:l...@ptoye.com
www.ptoye.com

-
Saturday, January 7, 2017, 3:53:02 PM, you wrote:


Importing/exporting Basic modules and dialogs is easy when you do NOT store 
everything in libraries named "Standard". Use the organizer to create a library 
with a distinct project name within a template, document or in global container 
"My Macros" 
Move dialogs and code modules into the library. 
Now you can create a simple macro extension from that library. There is an 
[Export] button on the "Libraries" tab of the organizer which generates a most 
simple oxt. 
You can also import libraries directly from documents or from library 
directories. There is an [Import] button on the same tab. You may also import 
libraries from extracted extensions. 


If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Problems-exporting-and-importing-a-dialogue-tp4204239p4204605.html
To unsubscribe from Problems exporting and importing a dialogue, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-exporting-and-importing-a-dialogue-tp4204239p4204610.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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
mailto:l...@ptoye.com
www.ptoye.com

-
Saturday, January 7, 2017, 4:07:01 PM, you wrote:


[Tutorial] Date-Time Conversion in StarBasic
including a spreadsheet document and a Basic function which converts all  types 
of dates, times, timestamps into any other type. Date-times can be represented 
by UNO structs, integers, doubles, Basic type Date,  ISO-strings and localized 
strings. 


If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Issues-with-date-fields-in-dialogues-tp4204266p4204607.html
To unsubscribe from Issues with date fields in dialogues, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Issues-with-date-fields-in-dialogues-tp4204266p4204609.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 was
well, so we can close this thread.



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Why-is-a-custom-menu-item-greyed-out-tp4204211p4204323.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 live version. So 
> I went into the test doc "organise dialogs|Edit" window and exported the 
> dialogue, which was called "OneOff" 

How do you make it 'called "OneOff"'? 
Originally I called it "One-Off" when I first created it with the 
Tools|Macros|Organise Dialogues menu. Later I changed it to "OneOff" by 
clicking on its name in the macro organiser window.


, to a file. Went into the live version, 
> found that I had to edit a dummy dialogue before I could import the saved 
> one, 

The document needs to have a library (likely 'Standard') and at least 
one module. Then you have an 'Import Dialog' in the toolbar in the 
module in the IDE. Because you need the module anyway for the macros to 
execute the dialog, first generate the module and then insert the dialog. 
I admit that I hadn't noticed that the "Import Dialogue" was available in the 
macro editor as well as the Dialogue Editor.


  imported the file. And found that the new dialogue was called 
> "One-Off", which had been its name some days ago.  I looked at the exported 
> .xdl file and there's a section saying   So I have 2 questions/comments: 
> 
> 1) Why is the imported file getting a different name? Alternatively, why has 
> the exported file got an out-of-date ID? 

In my tests it gets the name of the tab in the Basic-IDE as value of the 
attribute 'dlg:id' and on import this value is used in the Basic-IDE as 
tab name. If such tab already exists, you get the option to rename or 
replace.
So it seems that the dlg:id attribute isn't changed when the name is changed. 
This looks like a bug to me (not an important one).


> 
> 2) Is there a way of importing a dialogue without having to edit a dummy 
> dialogue? 

See above, you need a module. 


BTW, I find is useful to have an own toolbar for macros. I use the commands 
'Edit Macros' = .uno:BasicIDEAppear (from category Application) and name 
it 'IDE'. 
'LibreOffice Basic' = .uno:MacroOrganizer (from category BASIC) and name 
it 'Run' 
'LibreOffice Basic Macro Organizer' = .uno:MacroOrganizer (fro, category 
BASIC) and name it 'Organize' 
That make access quicker than via Tools > Macros. 
Thanks - I'll try this.


Kind regards 
Regina 




-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-exporting-and-importing-a-dialogue-tp4204239p4204320.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 LO help
files under "Macros and programming|Guides" where there is some (but not a
lot of) useful information.

I use a dialogue in Calc to allow the user to enter values which, when an
"OK" button is pressed, are entered into the correct cells in a spreadsheet
using macro code in LO Basic. But it's not confined to Calc - you can write
a dialogue in any LO application.

HTH



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-exporting-and-importing-a-dialogue-tp4204239p4204318.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 the underlying data seems to be in two places at 
once - never good design :)  - and what you read depends on how it was written.

I'm trying to work out if this is part of the design of dialogues, or an 
unwanted side-effect (i.e. a bug). And I'm looking for guidance as to whether I 
should put it into bugzilla and see what happens.

Best regards,

Peter
mailto:l...@ptoye.com
www.ptoye.com

-
Tuesday, January 3, 2017, 5:33:51 PM, you wrote:


-BEGIN PGP SIGNED MESSAGE- 
Hash: SHA1 

Hello Peter, 

> 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 three ways of setting this field : 
> 
> 1) by setting its Text property within a macro 2) by setting its 
> Date property within a macro 3) by typing a date into the field. 
> 
> However, if one uses (1), the Date property is not changed, if one 
> uses (2) the Text property is not changed, and if one uses (3) both 
> properties are changed. Surely both properties should follow the 
> displayed view of the field, however it is modified. Is this 
> designed, or a bug? 

You could work with a view on the dialog and with the model. The view 
only shows, what you could see on the screen. Could be there is some 
content behind which will be saved if you press the SAVE-Button. The 
model has content, which could be saved. 

I don't know much about dialogs, in form-controls the text could be 
changed and nothing would be saved by the database, because the value 
of the control hasn't been saved. 

If I will change a date in a form I write down 
oDateField.BoundField.updateDate( unoDate ) 
and this changes both: The content I could see and the content behind 
for the database. It works as typing it in the field. 

Regards 

Robert 
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE- 
Version: GnuPG v2 

iQIcBAEBAgAGBQJYa+A7AAoJELDKYwaoS9AIkdwP/RAKxmTRIIFuJUAQ2PuhB9yx 
cGPHsmborqS6LHc4tjjx5w30FesVUGTYZFnpq8yL0h/1kZx0SNTHsPQ4x4+TxxR9 
xuJZMBb7Wpz3sHla0XUpsInvE9iAgO2yXnZ3ysE+z0/IPDibevwXJZX4Uo24iodb 
h1RP9AQUYhnjpvqIJG41jMjnqmCRzhIIHeDol1avKuAyniR+Wpd4C77kb9ZU6nrE 
3vmR9xVceCXt3/RWtBeRrIxtNnCxtOla0aoAPM5WdD5bssTOECXBWXSX1a8T+Uy/ 
bO/9PjhR4kGEfApCRylwjYcHrvORy7ZegYwaJmfa78/UFcGcE+vbeKLqjMPSB/SH 
XETZpBAIRdSj1cO9MjqkruEFVeXL4JVc0XLT/3JIJx8VxyAY/vogDjgeWrr8oSll 
rEU1WtMZFrRKI4fQpZGgBQZPrpqsCRsI9/4MBNakBYhMgN7yvTCTdS5YBjyt+Ph5 
z0oyYn2TcS80IW3hEju2AvnwpxeqtIUWPgi5no/HEB7n0o+nVBpLwTbgHOVzSuG7 
u4DGam2u/SYhG85mT1xZYHIj3Df0yFwWBmBdsAqYZWI+5/JPT0UyVy/10y0duSXR 
All1uwn8VljnsozfvPtE0zsLtMLDoThyxzhxsofVTSB6/6NSkty8m1/lwtRzOs/P 
jp+7yeD6gjJ1RnUX3Iid 
=8xTn 
-END PGP SIGNATURE- 

-- 
To unsubscribe e-mail to: [hidden email] 
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted 




If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Issues-with-date-fields-in-dialogues-tp4204266p4204275.html
To unsubscribe from Issues with date fields in dialogues, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Issues-with-date-fields-in-dialogues-tp4204266p4204278.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Issues with date fields in dialogues

[ptoye]

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 three ways
of setting this field : 

1) by setting its Text property within a macro
2) by setting its Date property within a macro
3) by typing a date into the field.

However, if one uses (1), the Date property is not changed, if one uses (2)
the Text property is not changed, and if one uses (3) both properties are
changed. Surely both properties should follow the displayed view of the
field, however it is modified. Is this designed, or a bug?

It's only a problem if you try to set the property one way and read it the
other, so a workaround is possible.





-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Issues-with-date-fields-in-dialogues-tp4204266.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Problems exporting and importing a dialogue

[ptoye]

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 saved
one, imported the file. And found that the new dialogue was called
"One-Off", which had been its name some days ago.  I looked at the exported
.xdl file and there's a section saying   So I have 2 questions/comments:

1) Why is the imported file getting a different name? Alternatively, why has
the exported file got an out-of-date ID?

2) Is there a way of importing a dialogue without having to edit a dummy
dialogue?



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-exporting-and-importing-a-dialogue-tp4204239.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 regards,

Peter
mailto:l...@ptoye.com
www.ptoye.com

-
Tuesday, January 3, 2017, 10:46:55 AM, you wrote:


-BEGIN PGP SIGNED MESSAGE- 
Hash: SHA1 

Hello Peter, 

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

Could be this menu doesn't work in the chosen part of LO. 
Example: There are many menues in a form of Base - but most of them 
are greyed ot, because they won't work with a form. 

Which menue are you trying to add to which kind of document? 

Regards 

Robert 
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE- 
Version: GnuPG v2 

iQIcBAEBAgAGBQJYa4DzAAoJELDKYwaoS9AIBDMP/1uPL/0hB1VrKhKxQ13MTr8W 
ipMtDlkR3kup21o9yrtWw4EP+/SDc63J94oOt/0Mdbk00W1ex09Ok19NDRNJVRtg 
6GEXhvbD3KGdSpszt8Ym0kKZAl3HIkpk1Op/EdrYE1MM/yw1daMnVG+nPfXt4kH1 
0F8iG9GoF4TVYAMWiK8uYQ9t7fqRQrwxNU6rJkxc+2CvbJrFOj4kJERZVBldk2x5 
fvrhaQqjWdMlZPEqcR/4wD2jb/UQhDEW024em8KqDa4+6Zj1XDjKSKQukfgmM6ei 
Btwwv7PVX3fzm+PJ/szGPTyi3TfwWqRhzrCjStXd2E1ccJedW+0NhfJE5p2yQMkV 
ESdzyLWv3P/95jHPJa7CuUp3Js+RVq5KBSQ2AtbIScbpbHVR/MrK9j40OAMHTtH7 
+2Dc7zGHZZ613Dhp51+mOhE2Ope4cWC4jmFbTTn7pHwYnc9Z/FbLWefvJUDYY7zI 
TZ8YDYMjRl85aaXF1q/KNjMmeMRXqlfqUhazX/dwRoWOhHiBPJTZRckAFzRDyTHt 
0ppoN73ATPks3riEhTANiVg1dceHtjZB0zU6l/BFR8jR8YIVWa7cD79WQI5/C2QV 
k0n/xVVUXEJDJUFlEvJksF9aNcnPXHGo8yHeZjNJjvqDRuARUIYgjtAJaZrVskwj 
eufF0NkbcTyqkJmYw6Dc 
=EaGK 
-END PGP SIGNATURE- 

-- 
To unsubscribe e-mail to: [hidden email] 
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted 




If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Why-is-a-custom-menu-item-greyed-out-tp4204211p4204217.html
To unsubscribe from Why is a custom menu item greyed out?, click here.
NAML

Test1.odt (19K) 





-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Why-is-a-custom-menu-item-greyed-out-tp4204211p4204226.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 sub-menu items the main menu stays black, but the submenu
items are greyed out.

I'm using LO 5.2.3.3 on Windows 7, if this makes a difference.





-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Why-is-a-custom-menu-item-greyed-out-tp4204211.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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: 
http://nabble.documentfoundation.org/How-to-insert-the-date-into-a-date-field-in-a-dialog-tp4203755p4203985.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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: 
http://nabble.documentfoundation.org/How-to-insert-the-date-into-a-date-field-in-a-dialog-tp4203755.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Title bar for dialogs

[ptoye]

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: 
http://nabble.documentfoundation.org/Title-bar-for-dialogs-tp4200548p4203749.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Breakpoints not working

[ptoye]

Hi Regina,

Thanks very much. Seems strange to me, but it works! Is this a bug or was it 
designed this way, in which case it should be in the documentation!

Best regards,

Peter
mailto:l...@ptoye.com
www.ptoye.com

-
Tuesday, December 27, 2016, 2:42:24 PM, you wrote:


Hi 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 stop. 

Kind regards 
Regina 


-- 
To unsubscribe e-mail to: [hidden email] 
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted 



If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Breakpoints-not-working-tp4203649p4203667.html
To unsubscribe from Breakpoints not working, click here.
NAML



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Breakpoints-not-working-tp4203649p4203672.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Breakpoints not working

[ptoye]

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: 
http://nabble.documentfoundation.org/Breakpoints-not-working-tp4203649.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Title bar for dialogs

[ptoye]

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 hit-and-miss affair. The first time I tried it enclosing
the whole box in a selection worked and I got the menu for the dialog box.
After that it look as if I'm selecting all the controls in the box, bit not
the box itself. Very odd. See the screenshot!

 




-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Title-bar-for-dialogs-tp4200548p4200620.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Title bar for dialogs

[ptoye]

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: 
http://nabble.documentfoundation.org/Title-bar-for-dialogs-tp4200548.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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.
 
 Reset your virtual PDF printer(s) for proper A4 settings.
 
 If on Windows I use PDFCreator: http://www.pdfforge.org/
 
 You can adjust the pitch easily in the Label|Format setup tab. The
 defaults for L7163 are:
 Horizontal pitch: 10.16cm
 Veritical pitch: 3.81cm
 
 I think you are referring to Width  Height:

I don't know PDFCreator - I'll have a look at it. Thanks for the idea.

Sorry - I should have said 10.2 not 9.9 - was looking at the wrong bit of
the format. But I do mean Pitch not Width.

The virtual drivers (both of them) seem to be set to A4 as default, Why
CutePDF ignores this I don't know.



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Trying-to-get-labels-to-fit-tp4024409p4024802.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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)
complicates the issue. But it seems odd to me that I get different results
between LO and OO, and between virtual printers.

I'm getting the feeling that the only way is to put OO and/or LO up on my
ancient machine and print directly. But then will I run into the missing
label problem? Wait and see?



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Trying-to-get-labels-to-fit-tp4024409p4024646.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

Thanks No-op and Don for the advice.

I wasn't 100% plain in stating the problem. All too easy when you know what
you're talking about!

Firstly, being English I need A4-size rather than 8 by 11 inch page size,
and as far as I can see World Label only do US sizes (so why do they call
themselves Word Label, then, or are the international sizes well buried on
their web site?).

Secondly, I should have mentioned that I am trying to produce labels from a
database rather than a set of identical labels. Not that this should matter
for formatting. Don's instructions give me the impression that it's more
work than should be necessary, and that LO's (and probably OO's) label
mechanism is irretrievably broken. Sad. Don - did you report the missing
records as a bug to LO's bugzilla? Probably worth while - if they don't know
it's broke they can't fix it! I'll keep a record of it for next year, but
may continue with Lotus on my ancient machine (if it's still working) or
even (boo, hiss) resort to MS Word whose label mechanism seems to work
properly.


My experience with World Label is also excellent. They are big 
supporters of open source software, including Linux, LO, and OO.

They furnished me with a rather unusual label size I needed. A friend 
was printing labels on that size in MS word. Two thirds down the page 
the bottom of one label was printing on the top of the label below it. I 
used the table style template available from World Label and they 
printed perfectly 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 and LO. I've had
 absolutely no alignment problems. I'll also paste here some assistance
 if you are using a database to fill out the forms:

 ... snip excellent advise

 The good folks at WorldLabel now also include autofill PDF forms for
 some (probably their most popular?) of their labels:

 lt;http://www.worldlabel.com/Pages/autofillpdf-labels.htm#addressgt;
-- 





-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Trying-to-get-labels-to-fit-tp4024409p4024507.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Trying to get labels to fit

[ptoye]

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 than the filled-in values, I use a
PDF printer and am getting different (and wrong) PDFs from both OO and LO.
Interestingly, the results are different between LO and OO, and also between
the printers I use, so there seems to be a problem with the printer
interface.

With OO using CutePDF I get a US letter size document (8 by 11 inches),
using Bullzip I get a document 20.8 by 28.2 cm (a bit smaller than A4). The
pitches are also wrong.

With LO I get the same from both printers: a correctly sized document. But
the pitch is wrong: 9.2 by 3.6 cm instead of 9.9 by 3.8.

How on earth can I get OO and/or LO to produce my labels? It's too late for
my Xmas cards now - I've gone back to an ancient Lotus SmartSuite which
works perfectly. But won't run on Windows 7 unfortunately. 



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Trying-to-get-labels-to-fit-tp4024409.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 asked
 about was an incorrect display of a query in a form.
 
 and you received at least two viable solutions although nobody was able 
 to reproduce the problem.
 

One of the solutions was my own: to continue using OO (which at the moment I
am, but is not exactly a solution to the technical problem). The other was
your workaround.

No-one here said they couldn't reproduce it as far as I can see, though of
course it may be true. I'd be willing to upload the database here if anyone
would like to try it out on their system. It might be a configuration issue,
though I can't quite see how.

After the short discussion about the technical problem I had, this thread
turned into a discussion of the relationship between LO and OO, and of the
shortcomings (or otherwise) of Base, about which I am not qualified to
comment.


-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3923242.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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, but that was a long time ago and is no
longer available (AFAIK).

Access allows update queries, which are sadly missing from LO/OO.

-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3916631.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 container.
 
 
Of course I can. If I can find out how to do it. 

But this isn't the point, is it? The real point is that database front-ends
and macro languages are meant to make life easy, not difficult. You seem to
dislike sugar - worried about your diameter? The computer was made for
man, not man for the computer. Why not program in assembler - gives you much
more control and isn't really that hard (I speak from years of assembler
experience and with my tongue firmly in my cheek)?

-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3916735.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 installing something like MySQL and writing my own
front-end in Java.

Is there any point in suggesting that LibO and OO should continue to
diverge? I'd have thought convergence would be more productive, both in
terms of the development which seems too thinly spread, and for users who
might even see a serious contender emerging.

-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3918036.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 is a major issue - which it is. I'm old enough to
remember when there were half a dozen different word processing programs,
and exchanging data with a colleague in a different company was a major
issue. So instead of the industry settling on a single document format, MS
jumped into the breach with a very indifferent WP progam called Word. Far
inferior to Word Perfect, but it sold on the back of the OS (DOS in those
days). One has to admire Gates for his commercial and marketing acumen,
however much one dislikes his philosophy and the products.

-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3911797.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 board comments - even this one) before they even start.

Agreed that MS have problems in forwards compatibility. But that's an
impossible dream. Can OO version 1 open OO version 3 documents?

Unfortunately I'm too short of time to contribute to OO/LO development - I
suspect there's another 2-year learning curve.

-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3911931.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 to write a form letter - I'm not even a
fully-fledged business, just a freelance pianist. But I do like to play with
applications, and occasionally write my own where I can't find a suitable
share- or free-ware one. And Base just doesn't work well enough - too many
bugs and I suspect not enough will to drive proper develop,emt - hence
Andrea's comments on Potemkin.

Tom's comment on 4 languages being available is fine, but as the API's so
impenetrable I feel it would have been better idea concentrate on getting
one language right rather than four languages wrong! Others are at liberty
to disagree.

-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3912142.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 works?) for
OO/LO and the lack of a decent IDE are real turn-offs for anyone trying to
do anything but the simplest task. For example, events aren't called when
the documentation implies that they should be (see
http://user.services.openoffice.org/en/forum/viewtopic.php?f=45t=49924start=30).
Bug? Feature? I don't know. But comments on that forum are as discouraging
are those here.

-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3912228.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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
 https://wiki.documentfoundation.org/Documentation/Publications#Programmers
 Regards from
 Tom :)
 
 
 

Yes, I've downloaded it and really will read it when I have a spare
month

It seems very good, but omits Base entirely AFAICS.

-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3912274.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 Bugzilla and will see what happens.

-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3909982.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3896408.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3896548.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 incorrectly in the grid but are
simple text fields in the underlying table. These are both VARCHAR type, but
so is style which is displayed correctly.

The fields are displayed correctly in the subform fields: if you look at the
Wine Name and supplier boxes there's an entry there. There would be one
in the commentbox, but that particular wine on show didn't have a comment.
So there's no consistency in terms of relationships and linked tables or
field types as to what's displayed correctly and what isn't.

I know the theory reasonably well (though OO/LO might have a different view
of relationships to, say, MS Access).

-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3892472.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 comparison!).

Query: The SQL looks the same (by eyeballing, again). And running the query
directly displays correctly. It's only in the form that it doesn't.

Form design: they look the same (eyeballing again). If there are any
differences in some of the drill-down properties I don't know. Is there any
way to get a textual version of the form definition to do a comparison on?

All the best,

-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3892485.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[ptoye]

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 what I mean.
http://nabble.documentfoundation.org/file/n3890826/LOBaseBug.zip
LOBaseBug.zip 



--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3890826.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted