Re: [libreoffice-users] Re: Correct Syntax to address a table or form field in Base's Basic

2012-07-18 Thread Tom Davies
Hi :) There are some guides and partial bits of guides at https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide (scroll down a bit to see some of the 3rd party things).  Mostly it seems that Andrew Pitonyak's guide is the best.  Also the FAQ mentioned in the link

[libreoffice-users] Libreoffice GNOME 3 Compatibility

2012-07-18 Thread Anthony Easthope
Hi Guys Just had a problem with LO after installing the GNOME 3 shell on ubuntu 12.04 lts. it appears that LO window now bleeds from the bottom right edge when using opening a Calc window. it never occurs any other time: Some trouble shooting data * LO 3.5.2 * LO was updated by the repositry *

[libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down list in all cells in column?

2012-07-18 Thread Gilles
Johnny Rosenberg wrote The easiest thing is probably to select one cell, select FOOD, hit Ctrl+c, select all the other cells in which you want the word FOOD (using Ctrl or Shift), hit Ctrl+v. Thanks much for the tip. It's fast enough. Tom wrote How about using GnuCash? Thanks for the

Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down list in all cells in column?

2012-07-18 Thread Dan
Gilles wrote: Johnny Rosenberg wrote The easiest thing is probably to select one cell, select FOOD, hit Ctrl+c, select all the other cells in which you want the word FOOD (using Ctrl or Shift), hit Ctrl+v. Thanks much for the tip. It's fast enough. Tom wrote How about using GnuCash?

Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down list in all cells in column?

2012-07-18 Thread Tom Davies
Hi :) One problem with using a spreadsheet or database is that it is difficult to set-up an audit trail and even if you do then it's unlikely to be trusted by anyone else that might need to see your accounts.  That is the advantage with using proper software developed for the purpose or for

Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down list in all cells in column?

2012-07-18 Thread Dan
And why isn't the bank statements in PDF files the audit trail? The numbers in those files can be compared with the numbers in the tables. The query structure will show whether the query will give the correct results or not. If the input numbers are correct, and the operations performed

Re: [libreoffice-users] Libreoffice GNOME 3 Compatibility

2012-07-18 Thread webmaster-Kracked_P_P
There was a thread about problems with the desktop environment and LO with the darker desktop themes, I think. --- My question is why are you using GNOME 3 shell for 12.04? From my readings of articles about the current GNOME 3 shell, it is still not fully functional, or at least the last

Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down list in all cells in column?

2012-07-18 Thread Tom Davies
HI :) Oh wow!!  I am more familiar with Access than Base and hadn't even considered that Base might be able to read data from Pdfs!  Base really is an extremely powerful tool, or at least has the potential, and aims to be even if it's not as fully functional as it aims to be.  Regards from Tom

Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down listin all cells in column?

2012-07-18 Thread Indischka - Sahib
please do not send any mail to us sir INDISCHKA Boekhorststraat 14, - Original Message - From: Dan elderdanle...@gmail.com To: users@global.libreoffice.org Sent: Wednesday, July 18, 2012 2:57 PM Subject: Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down listin all cells in

Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down listin all cells in column?

2012-07-18 Thread Tom Davies
Hi :) Please unsubscribe yourself using these instructions http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Regards from Tom :) --- On Wed, 18/7/12, Indischka - Sahib sa...@planet.nl wrote: From: Indischka - Sahib sa...@planet.nl Subject: Re: [libreoffice-users] Re:

[libreoffice-users] SQL statement in Base query

2012-07-18 Thread Dan
The FROM clause is where I am having errors returned. The outline that I am using for this clause is: FROM Table name [{CROSS | INNER | LEFT OUTER | RIGHT OUTER} JOIN Table name ON Expression] [, ...] I have two tables with a child parent relationship: Persons.P_ID = Orders.P_ID These

[libreoffice-users] Re: SQL statement in Base query

2012-07-18 Thread Andreas Säger
On this simple level I would consider HSQLDB as free of bugs whereas the primitive Base parser fails in many different ways. Did you try the direct SQL mode (SQL view, menu:EditRun SQL directly)? If you get reasonable result in direct mode, it is one of many bugs in the Base's SQL parser. -- View

Re: [libreoffice-users] Re: Correct Syntax to address a table or form field in Base's Basic

2012-07-18 Thread Brad Rogers
On Wed, 18 Jul 2012 11:12:17 -0700 (PDT) Andreas Säger ville...@t-online.de wrote: Hello Andreas, I did not reply to your bloody mailing list. I used a server named nabble.documentfoundation.org which shows the whole topic on a web-page. Most people are subscribed to the mailing list. If you

[libreoffice-users] query re. fonts ...

2012-07-18 Thread anne-ology
... Is it possible or not to keep one font as default? in using Impress, each time I add text, I have to re-add the font, et.al. Is there some way to make the font the default for each particular file? ... I use differing fonts with each file, but only one

Re: [libreoffice-users] spreadsheets / timelines ... + queries

2012-07-18 Thread anne-ology
Thank you for your timely response - but unfortunately your response is over my head ;-( If I were to upgrade to .5 - [yes, I will be keeping .4 in the download folder] - what do I click on to so do? - all I see are various blocks mentioning various options

[libreoffice-users] Base fread-only

2012-07-18 Thread Larry Blanchard
I have 2 databases created under OpenOffice 3.2 using Ubuntu Linux 10.04. Both databases have the same permissions and are in the same directory so the parent permissions are also the same. I purged OO and installed LO. Still using Ubuntu 10.04. If I open one of my databases in LibreOffice

Re: [libreoffice-users] Libreoffice GNOME 3 Compatibility

2012-07-18 Thread Anthony Easthope
The problem was fixed. All that was needed was a re installation of the shell. as to why I was using GNOME. it was a matter of curiosity as I am new to unix (only had it for 2 weeks on the laptop) I wanted to experience all that it had to offer me. still have a long way to go yet but GNOME 3 on

Re: [libreoffice-users] Base fread-only

2012-07-18 Thread Jay Lozier
On 07/18/2012 03:22 PM, Larry Blanchard wrote: I have 2 databases created under OpenOffice 3.2 using Ubuntu Linux 10.04. Both databases have the same permissions and are in the same directory so the parent permissions are also the same. I purged OO and installed LO. Still using Ubuntu 10.04.

[libreoffice-users] Re: Base fread-only

2012-07-18 Thread Andreas Säger
[Tutorial] Read-Only in Base: http://user.services.openoffice.org/en/forum/viewtopic.php?f=83t=26448 -- View this message in context: http://nabble.documentfoundation.org/Base-fread-only-tp3996291p3996297.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe

Re: [libreoffice-users] Base fread-only

2012-07-18 Thread Andrew Brager
On 7/18/2012 1:05 PM, Jay Lozier wrote: On 07/18/2012 03:22 PM, Larry Blanchard wrote: So I'm back in business. But for future reference, how the @#$%! do I make the original read/write or at least get some sort of error message - and yes I've checked the Linux log files for messages - no joy

Re: [libreoffice-users] Re: SQL statement in Base query

2012-07-18 Thread Dan
Andreas Säger wrote: On this simple level I would consider HSQLDB as free of bugs whereas the primitive Base parser fails in many different ways. Did you try the direct SQL mode (SQL view, menu:EditRun SQL directly)? If you get reasonable result in direct mode, it is one of many bugs in the

[libreoffice-users] North American DVD 3.5.5 now online on LO's servers/mirrors

2012-07-18 Thread webmaster-Kracked_P_P
The LibreOffice North American Community DVD Project's 3.5.5-1 DVD is now online at LO's download pages. It is 3.8 GB in size. Windows / Linux / Mac installs. 3.5.5 installs with 6 non-English languages along with en_US and en_GB for the language and help packs. Plus almost 2 GB of

Re: [libreoffice-users] Libreoffice GNOME 3 Compatibility

2012-07-18 Thread webmaster-Kracked_P_P
I got spoiled with the GNOME on Ubuntu 10.04 and when Unity became the default for Ubuntu last year, I did not like it. I was told to use MATE instead of GNOME 3 shell, since it was not fully working as of late Spring. I could be better now, but I do not know. I will have to install it on

Re: [libreoffice-users] Libreoffice GNOME 3 Compatibility

2012-07-18 Thread Simon Cropper
On 19/07/12 10:21, webmaster-Kracked_P_P wrote: I got spoiled with the GNOME on Ubuntu 10.04 and when Unity became the default for Ubuntu last year, I did not like it. I was told to use MATE instead of GNOME 3 shell, since it was not fully working as of late Spring. I could be better now, but

[libreoffice-users] [List Threading] was: Re: Correct Syntax to address a table or form field in Base's Basic

2012-07-18 Thread NoOp
On 07/18/2012 11:12 AM, Andreas Säger wrote: I did not reply to your bloody mailing list. I used a server named nabble.documentfoundation.org which shows the whole topic on a web-page. Ah, a web-pager... wrong tool for the job eh? Using nabble, gmane.org, etc from a web page is (IMO) like

[libreoffice-users] Re: [List Threading] was: Re: Correct Syntax to address a table or form field in Base's Basic

2012-07-18 Thread NoOp
NoOp wrote On 07/18/2012 11:12 AM, Andreas Säger wrote: I did not reply to your bloody mailing list. I used a server named nabble.documentfoundation.org which shows the whole topic on a web-page. If you have an issue with the nabble gateway, then I suggest you take that up with

[libreoffice-users] Re: [List Threading] was: Re: Correct Syntax to address a table or form field in Base's Basic

2012-07-18 Thread NoOp
Back to gmane.org/nntp: On 07/18/2012 10:07 PM, NoOp wrote: NoOp wrote On 07/18/2012 11:12 AM, Andreas Säger wrote: I did not reply to your bloody mailing list. I used a server named nabble.documentfoundation.org which shows the whole topic on a web-page. If you have an issue