[libreoffice-users] Re: Update SQL does nothing using "Run SQL directly" button

2012-10-07 Thread Andreas Säger
Am 04.10.2012 01:27, David S. Crampton wrote: > Register1a is a table with field "Trans-Date" of type TIMESTAMP. Field > "Trans-Date-Year" is either TIMESTAMP or INTERGER. I have tried with both. > > Update "Register1a" Set "Register1a.Trans-Date-Year" = > YEAR("Register1a.Trans-Date"); > > Looks

Re: [libreoffice-users] Fw: Help request on CALC charts' features

2012-10-07 Thread Steve Edmonds
Hi. On 2012-10-08 15:08, rost52 wrote: In general I am of the impression that Calc and Excel have some limitations when converting from one into the other. I recently also observered some problems with charts but had no time to write them down, thus I don't remember details sufficiently to list

Re: [libreoffice-users] Fw: Help request on CALC charts' features

2012-10-07 Thread rost52
In general I am of the impression that Calc and Excel have some limitations when converting from one into the other. I recently also observered some problems with charts but had no time to write them down, thus I don't remember details sufficiently to list them here. Just don't be surprised about

Re: [libreoffice-users] MS problems

2012-10-07 Thread Tom Davies
Hi :) There are no quick answers and there are no "one size fits all" answers either.  The only way LO will ever be an easy sell is if everyone else is already using it.  In IT diversity and "freedom of choice" is generally seen as a bad thing.  It's much easier just to go along with whatever

[libreoffice-users] Re: Update SQL does nothing using "Run SQL directly" button

2012-10-07 Thread David S. Crampton
Jay & Noel, One other effect of the SQL button in Query Design appears to be that it disables the GUI style design view. If one wants to use both the GUI table (to get started with the basics) and then fine tune with written SQL, you have to sacrifice the formatting of the SQL phrases. If you retu

Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

2012-10-07 Thread Girvin R. Herr
Greetings, This thread has been ongoing for a relatively long time now and IMHO it has forked many times and veared off of its original message: that MS was to start renting their software and the lock on users that that implies. Well, as we have been debating all these forked threads, there

Re: [libreoffice-users] MS problems

2012-10-07 Thread Tom Davies
Hi :) Thanks :)  That restores my faith in humanity a little :) Thanks and regards from Tom :)  --- On Sun, 7/10/12, Wolfgang Keller wrote: From: Wolfgang Keller Subject: Re: [libreoffice-users] MS problems To: users@global.libreoffice.org Date: Sunday, 7 October, 2012, 20:58 > Since the ave

Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

2012-10-07 Thread jomali
But Ooo/LO does use structure markup. All .odt/.ods documents are XML files. On Sun, Oct 7, 2012 at 2:32 PM, Wolfgang Keller wrote: > > > Everything that you get from LaTeX: structure markup instead of > > > spaghetti formatting, parameterized formatting, etc... > > > > > > Instead of clicking t

Re: [libreoffice-users] MS problems

2012-10-07 Thread Wolfgang Keller
> Since the average IQ is around 60 (or something utterly abysmal like > that) i don't think intelligent decision-making really entered the > equation.  The average IQ is - per definition - equal to 100. It's even calibrated to be a normal distribution. Sincerely, Wolfgang -- For unsubscribe

Re: [libreoffice-users] Title bar changes during starting up LibreOffice

2012-10-07 Thread Dan Lewis
On 10/07/2012 09:22 AM, Johnny Rosenberg wrote: When I start up LibreOffice, the title bar first displays, for example, "LibreOffice 3.5 Calc". When finished doing whatever it does, the title bar changes to "LibreOffice 3.3 Calc". Ubuntu 12.04 LibreOffice 3.5.6.2 (installed using the debs availa

Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

2012-10-07 Thread Mirosław Zalewski
On 07/10/2012 at 20:32, Wolfgang Keller wrote: > The point with MS Word, as (unfortunately) with LO Writer is, that, > unlike e.g. Wordperfect or FrameMaker their document model is thoroughly > unstructured ("spaghetti"), and the way "styles" are implemented they do > not allow to "emulate" "stru

Re: [libreoffice-users] Re: documentation for LO base

2012-10-07 Thread Wolfgang Keller
> Just like MSAccess, Base is extremely useful as a frontend for > database engines. The last time I tried to run a non-trivial query (involving a join) from Access against PostgreSQL, the result was a never-ending cursor animation. It seems that Access fetches *all* records from the database and

Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

2012-10-07 Thread Wolfgang Keller
> > Everything that you get from LaTeX: structure markup instead of > > spaghetti formatting, parameterized formatting, etc... > > > > Instead of clicking through dozens of dialogboxes for each and every > > line of text, slide title, list item, figure, etc. to get > > everything the way you want i

Re: [libreoffice-users] Re: Count number of rows satisfying two conditions

2012-10-07 Thread Alaak
Hi Thanks. That worked great. Regards Am So 07 Okt 2012 12:38:11 CEST schrieb Andreas Säger: Am 07.10.2012 12:28, Alaak wrote: Hi, I have the following problem. I need to count all rows from a table satisfying two conditions in separate columns. I know of the function COUNTIF (ZÄHLENWENN i

Re: [libreoffice-users] Re: Label mail merge producing one page per record, not six records per page

2012-10-07 Thread Phil Reynolds
On Sun, 7 Oct 2012 08:09:28 -0700 (PDT) robertjm wrote: > Thanks for the pointer. It worked...partially. > > While each of the six badges has a unique individual, the three > fields are all messed up. > > First names are jumping three names per badge , and the Last names > are six rows in the

Re: [libreoffice-users] MS problems

2012-10-07 Thread Pertti Rönnberg
Dear Wolfgang, I am in no way trying - not even in a a such position - to limit anyone's right to express one's opinions, but >>I wish you will give the same right to others -- we shall respect all others >>this list is meant to help LibO and its users - not to humiliate or calling nam

Re: [libreoffice-users] Re: Update SQL does nothing using "Run SQL directly" button

2012-10-07 Thread Jay Lozier
On 10/07/2012 07:28 AM, Marion & Noel Lodge wrote: > Hi Jay, > > On 6 October 2012 14:55, Jay Lozier wrote: >> This actually standard practice for writing queries. Another common >> practice is to capitalize SQL key words, which you appear to also do. > I was aware that formatting a query was good

Re: [libreoffice-users] using \t in regular expression replace

2012-10-07 Thread Johnny Rosenberg
2012/10/7 Brian Barker : > At 16:11 07/10/2012 +0200, Johnny Rosenberg wrote: >> >> That helps, but it's still a bug right? > > > Probably. I suspect the designers would say that searching for $ on its own > has no meaning, so that fact that it matches anything might be the bug! But > the fact th

[libreoffice-users] Re: Label mail merge producing one page per record, not six records per page

2012-10-07 Thread robertjm
Thanks for the pointer. It worked...partially. While each of the six badges has a unique individual, the three fields are all messed up. First names are jumping three names per badge , and the Last names are six rows in the database below the first name of the individual. The photo names (the

Re: [libreoffice-users] using \t in regular expression replace

2012-10-07 Thread Brian Barker
At 11:08 07/10/2012 +0200, Johnny Rosenberg wrote: 2012/10/7 Brian Barker: At 20:24 06/10/2012 -0400, Dan Lewis wrote: On 10/06/2012 05:09 PM, Cor Nouws wrote: I was trying to use \t to replace e.g a paragraph ending with a tab. So find $ replace with \t That does not work. At first I did

[libreoffice-users] Title bar changes during starting up LibreOffice

2012-10-07 Thread Johnny Rosenberg
When I start up LibreOffice, the title bar first displays, for example, ”LibreOffice 3.5 Calc”. When finished doing whatever it does, the title bar changes to ”LibreOffice 3.3 Calc”. Ubuntu 12.04 LibreOffice 3.5.6.2 (installed using the debs available at http://www.libreoffice.org/ – the Ubuntu re

[libreoffice-users] LibreOffice Conference - registration deadline ends tomorrow

2012-10-07 Thread Florian Effenberger
Hello everyone, just about one more week, and this years' LibreOffice Conference takes place in Berlin. I would like to remind you that the *deadline* for the registration ends tomorrow, Monday, October 8th, 2012, at 21:59 UTC If you want to attend the conference, and didn't register

Re: [libreoffice-users] Re: Update SQL does nothing using "Run SQL directly" button

2012-10-07 Thread Marion & Noel Lodge
Hi Jay, On 6 October 2012 14:55, Jay Lozier wrote: > This actually standard practice for writing queries. Another common > practice is to capitalize SQL key words, which you appear to also do. I was aware that formatting a query was good practice - not so sure that it is standard practice. If i

[libreoffice-users] Re: Count number of rows satisfying two conditions

2012-10-07 Thread Andreas Säger
Am 07.10.2012 12:28, Alaak wrote: > Hi, > > I have the following problem. I need to count all rows from a table > satisfying two conditions in separate columns. I know of the function > COUNTIF (ZÄHLENWENN in german), but that one is only able to consider > one condition. Let's look at a brief exa

[libreoffice-users] Count number of rows satisfying two conditions

2012-10-07 Thread Alaak
Hi, I have the following problem. I need to count all rows from a table satisfying two conditions in separate columns. I know of the function COUNTIF (ZÄHLENWENN in german), but that one is only able to consider one condition. Let's look at a brief example. s1 s2 atrue btrue af

Re: [libreoffice-users] Help request on CALC charts' features

2012-10-07 Thread Rolf Lochbühler
> 1. The full worksheet as chart in excel are converted to embedded charts in > those sheets (no full charts). I don't think that feature is available in Calc. However, you may move your chart (by cut and paste) onto a separate sheet, of course. > 2. Legends are peculiar. They are named as "c

[libreoffice-users] Re: Label mail merge producing one page per record, not six records per page

2012-10-07 Thread Andreas Säger
Am 07.10.2012 05:53, robertjm wrote: > Hi all, > > Sorry for the subject being confusing, but that's the best way I could > describe it. > > I'm working with Avery 5384 Name Badge labels. These has six spots per page. > > I set up a layout in the upper left-hand "label", and then clicked > sync