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

2012-10-08 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 like is should

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

2012-10-08 Thread Cor Nouws
Hi all, Brian Barker wrote (07-10-12 16:01) At 11:08 07/10/2012 +0200, Johnny Rosenberg wrote: The problem I encountered was that the paragraph breaks was replaced with the characters \t, not the [tab] (tab) character, no matter if Regular expressions were ticked or not. I got the same

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

2012-10-08 Thread MiguelAngel
El 08/10/12 9:03, Cor Nouws escribió: Hi all, Brian Barker wrote (07-10-12 16:01) At 11:08 07/10/2012 +0200, Johnny Rosenberg wrote: The problem I encountered was that the paragraph breaks was replaced with the characters \t, not the [tab] (tab) character, no matter if Regular expressions

Base list, was: Fw: [libreoffice-users] Re: Update SQL does nothing using Run SQL directly button

2012-10-08 Thread Tom Davies
Hi :) All the threads about Base are buried in the archives: scattered and hidden, incoherent amongst hundreds of threads about things that are nothing to do with Base.  If there was a Base List then some of those threads might have been referenced on it.  There isn't.  So any thread about

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

2012-10-08 Thread Andreas Säger
Am 08.10.2012 09:03, Cor Nouws wrote: Of course I used this workaround. But I wondered if I did something wrong, or missed some special trick to replace $ with a tab in one run. The $ does not match any character. It matches a position. You may think of the position where the bar cursor

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

2012-10-08 Thread Brian Barker
At 12:09 08/10/2012 +0200, Andreas Säger wrote: The $ does not match any character. It matches a position. That's what I understood too. But, contrary to this, searching for $ *does* match the paragraph break (whether or not it is supposed to). Strangely, though, \t in the Replace with

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

2012-10-08 Thread Tom Davies
Hi :) Perhaps Viral Orpe is not properly subscribed to the list?  Perhaps he/she used a different email account that is supposed to filter mails through to the main one he/she uses?  When you subscribe to these lists there are a few options you can choose.  One is for the list to cleverly NOT

[libreoffice-users] Re: [libreoffice-accessibility] bug 50926

2012-10-08 Thread Tom Davies
Hi :)  I'm not sure how to forwards this to the devs list.  There has been some talk of getting accessibility bugs marked out to differentiate them from others and perhaps raise the priority on them to hopefully get them fixed faster.  Thanks to IBM's gift of their Lotus Symphony code to

[libreoffice-users] Re: Base list, was: Fw: Re: Update SQL does nothing using Run SQL directly button

2012-10-08 Thread Andreas Säger
Am 08.10.2012 12:01, Tom Davies wrote: Hi :) All the threads about Base are buried in the archives: scattered and hidden, incoherent amongst hundreds of threads about things that are nothing to do with Base. If there was a Base List then some of those threads might have been

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

2012-10-08 Thread Marcello Romani
Il 05/10/2012 17:18, Marcello Romani ha scritto: Il 05/10/2012 16:31, webmaster-Kracked_P_P ha scritto: On 10/05/2012 10:10 AM, Marcello Romani wrote: Il 05/10/2012 11:07, John Clegg ha scritto: One feature I miss isn't actually a feature in MSO as such, but LO behaves differently. If I open

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

2012-10-08 Thread John Clegg
OK, if I accept everything that has been said, then why wouldn't opening an in-memory r/w copy be the sensible default action? On 8 October 2012 13:08, Marcello Romani mrom...@ottotecnica.com wrote: Il 05/10/2012 17:18, Marcello Romani ha scritto: Il 05/10/2012 16:31, webmaster-Kracked_P_P ha

Re: [libreoffice-users] Re: Base list, was: Fw: Re: Update SQL does nothing using Run SQL directly button

2012-10-08 Thread Tom Davies
Hi :) Thanks Andreas! :)  I have been looking for that link for a while.  It feels a bit cheeky to send people from here to AOO but it's probably a good idea if we are going to keep helping Base users.  Regards from Tom :)  --- On Mon, 8/10/12, Andreas Säger ville...@t-online.de wrote:

[libreoffice-users] Re: Base list, was: Fw: Re: Update SQL does nothing using Run SQL directly button

2012-10-08 Thread Andreas Säger
Am 08.10.2012 14:15, Tom Davies wrote: Hi :) Thanks Andreas! :) I have been looking for that link for a while. It feels a bit cheeky to send people from here to AOO but it's probably a good idea if we are going to keep helping Base users. Regards from Tom :) When the whole

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

2012-10-08 Thread Andreas Säger
Am 08.10.2012 14:13, John Clegg wrote: OK, if I accept everything that has been said, then why wouldn't opening an in-memory r/w copy be the sensible default action? Tell your mail client, browser, whatever to call soffice with the -n switch. The -n switch treats every document as if it were

Re: [libreoffice-users] Re: [libreoffice-accessibility] bug 50926

2012-10-08 Thread Joel Madero
On 10/08/2012 04:11 AM, Tom Davies wrote: Hi :) I'm not sure how to forwards this to the devs list. There has been some talk of getting accessibility bugs marked out to differentiate them from others and perhaps raise the priority on them to hopefully get them fixed faster. Thanks to IBM's

[libreoffice-users] Re: Base list, was: Fw: Re: Update SQL does nothing using Run SQL directly button

2012-10-08 Thread Alex Thurgood
Le 08/10/2012 15:24, Andreas Säger a écrit : When the whole OpenOffice.org project was at risk, LibreOffice could have had it all. Unfortunately, some extra smart meritocrats rejected the idea of taking over that forum at the price of hosting it. Now it is part of the Apache infrastructure.

Re: [libreoffice-users] Re: calc cells spacing to contents not working as it should

2012-10-08 Thread Tom Davies
Hi :) We try to play nicely with non-native formats because they are still so dominant.  So it is worth posting bug-report.  Finding that it is only xls that is affected and not ods may help the devs pin-point the problem which usually makes it easier to solve.  So, good work :) Many thanks

Re: [libreoffice-users] attempting to find an answer and instead ...

2012-10-08 Thread Jay Lozier
On 10/08/2012 12:21 PM, Tom Davies wrote: Hi :) Speculation can provide a lot of amusement. I like Anne-ology's explanation. The real answer is quite good too. So, where did boot-up come from? Wasn't that soem engineering term to do with subs too? Regards from Tom :) I think it

Re: [libreoffice-users] attempting to find an answer and instead ...

2012-10-08 Thread Séamas Ó Brógáin
Tom wrote: So, where did boot-up come from? “Boot” (restart) a computer was originally “bootstrap,” from “pull (oneself) up by the bootstraps,” i.e. to start by oneself. The “up” is a gratuitous addition. Now back to work, everyone. -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] query re. volunteering w/ LO

2012-10-08 Thread anne-ology
Thanks for responding; I've been attempting to do just that - it states I must log-in to the wiki site ... so I attempt to set-up an account ... each time it states there's some math question with a blank to fill-in to prove I'm not some robot - but not finding

Re: [libreoffice-users] Special characters help

2012-10-08 Thread anne-ology
There should be a 'character map' on your machine - this may be found by clicking on start -- type char -- this box will appear -- then choose the font character within that font desired; There are also keys you may click to access that particular character in the future.

[libreoffice-users] Re: attempting to find an answer and instead ...

2012-10-08 Thread Tom
Hi :) Errr, there doesn't seem to be a question to answer in this thread. I suppose acceptable etiquette just about covers it. the main points are 1. Try to keep questions on-list. If you go off-list then people may well not respond and there are many reasons why not which have nothing to

RE: [libreoffice-users] query re. volunteering w/ LO

2012-10-08 Thread V Stuart Foote
Anne, Correctly completing the CAPTCHA (Completely Automated Public Turing test to tell Computers and Humans Apart) is your key to establishing an account on the Wiki site maintained by the Document Foundation. We all have to pass that test to establish an account. And then, as we all do, you

[libreoffice-users] Re: help needed ...

2012-10-08 Thread Tom
Hi :) It would be great if you could upload a screen-shot to Nabble. After you click on Reply to any message in your thread in Nabble the top-option in the More button allows you to upload a screen-shot. I can't remember which OS you are using. Screenshot are trickier in Windows but not really

[libreoffice-users] Re: LO 3.6.1 (Impress): Can't copy slides from PPTX to ODP file

2012-10-08 Thread Tom
Hi :) Sorry for the slow response! It seems you are not properly subscribed to the mailing list so no-one is receiving your question! I don't know why copypaste is not working between the two formats. You should be able (from either file) to choose File - Save As ... and then save the

[libreoffice-users] Re: Calc 3.6.6.2 regression - ods file as example

2012-10-08 Thread Tom
Hi :) Sorry for the slow response! It seems you are not properly subscribed to the mailing list so no-one is receiving your question! Have you tried renaming your User Profile http://wiki.documentfoundation.org/Documentation/UserProfile That usually solves all sorts of weird problems.

Re: [libreoffice-users] seperatiors between cross reference elements

2012-10-08 Thread Tom Davies
Hi :) This link might help http://wiki.documentfoundation.org/Bug_Report One of the drop-downs in the bug-reporting thing has the feature request option Thanks and regards from Tom :)  From: rost52 bugquestcon...@online.de To: users@global.libreoffice.org

Re: [libreoffice-users] help needed ...

2012-10-08 Thread Tom Davies
Hi :) It would be great if you could upload a screen-shot to Nabble.  After you click on Reply to any message in your thread in Nabble the top-option in the More button allows you to upload a screen-shot. I can't remember which OS you are using.  Screenshot are trickier in Windows but not

Re: [libreoffice-users] attempting to find an answer and instead ...

2012-10-08 Thread Felmon Davis
On Mon, 8 Oct 2012, Tom Davies wrote: Hi :) Speculation can provide a lot of amusement.  I like Anne-ology's explanation.  The real answer is quite good too.  So, where did boot-up come from?  Wasn't that soem engineering term to do with subs too? Regards from Tom :)   Baron von Münchhausen

Re: [libreoffice-users] query re. volunteering w/ LO

2012-10-08 Thread Tom Davies
Hi :) +1 Ahah, that was what this was about.  You aren't supposed to solve the maths puzzle, just re-type it into the box just the way it appears. Regards from Tom :)  From: V Stuart Foote vstuart.fo...@utsa.edu To: anne-ology lagin...@gmail.com Cc:

Re: [libreoffice-users] Special characters help

2012-10-08 Thread Tom Davies
Hi :) +1 or try Insert - Special character Good luck and regards form Tom :)  From: anne-ology lagin...@gmail.com To: Ken ken_ha...@globalsouthservices.com Cc: users@global.libreoffice.org Sent: Monday, 8 October 2012, 20:45 Subject: Re:

[libreoffice-users] Nabble broken?

2012-10-08 Thread Tom Davies
Hi :) Nabble appears to be broken.  There are a lot of unanswered questions there that haven't appeared on the list and when i try to post my mail doesn't get through either!  I have tried sending personal messages (against my own advice) to people asking them to post directly to the Users List

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

2012-10-08 Thread Tom Davies
Hi :) I keep forgetting about this one even though i have added it to the Publications page https://wiki.documentfoundation.org/Documentation/Publications Regards from Tom :) From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Sent:

Re: [libreoffice-users] Special characters help

2012-10-08 Thread Simos Xenitellis
On Fri, Oct 5, 2012 at 7:31 PM, Ken-GSS ken_ha...@globalsouthservices.com wrote: In the T language project, we are using Libre Office 3.5.5.3 and would like to use the special characters needed for several of the languages. For example in one of the languages we need a special “l”. The

Re: [libreoffice-users] attempting to find an answer and instead ...

2012-10-08 Thread Doug
On 10/08/2012 04:52 PM, Felmon Davis wrote: On Mon, 8 Oct 2012, Tom Davies wrote: Hi :) Speculation can provide a lot of amusement. I like Anne-ology's explanation. The real answer is quite good too. So, where did boot-up come from? Wasn't that soem engineering term to do with subs too?

[libreoffice-users] regexp function

2012-10-08 Thread Steve Edmonds
Hi. I have had a look, and before I go writing a macro I thought I would check there is no easier solution. I want to return the part of a string in a cell matched by a regular expression. I have strings in cells that could be X12.4Y.2Z1.234 or any combination of any letter followed by a

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

2012-10-08 Thread anne-ology
Just a thought ... could both LO versions still be operational on your machine? On Sun, Oct 7, 2012 at 8:22 AM, Johnny Rosenberg gurus.knu...@gmail.comwrote: When I start up LibreOffice, the title bar first displays, for example, ”LibreOffice 3.5 Calc”. When finished doing

Re: [libreoffice-users] MS problems

2012-10-08 Thread anne-ology
Sounds as if the Peter Principle as returned ;-) will folks heed it this time 'round; I guess not ;-( On Sat, Oct 6, 2012 at 2:25 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Just thought people might like a few equations to see what Wolfgang is driving at As

Re: [libreoffice-users] MS problems

2012-10-08 Thread anne-ology
so true. On Sat, Oct 6, 2012 at 2:57 AM, Dr. R. O Stapf reinh...@stapf-online.comwrote: I think the market share of MSO has nothing to do with the users being idiots or not. The 90% share is caused by 3 things 1 - When you buy a PC you often get the MSO already pre-installed 2 - Not

Re: [libreoffice-users] seperatiors between cross reference elements

2012-10-08 Thread rost52
Tom,Thanks for the link, but I could not find the drop-down feature request (maybe I am an IY moron) but could you please publish/send me a screen shot?On 2012-10-09 05:32, Tom Davies wrote: Hi :)This link might helphttp://wiki.documentfoundation.org/Bug_ReportOne of the drop-downs in the

Re: [libreoffice-users] Re: help needed ...

2012-10-08 Thread anne-ology
Thanks, but since **I use WIN and still haven't figured out what this Nabble is ... ;-) well, The more I learn of these machines, the less I seem to know ... with apologies to Socrates who said, The more I learn, the more I learn how little I know On Mon, Oct

Re: [libreoffice-users] Nabble broken?

2012-10-08 Thread anne-ology
So long fair the well, oh nabble ... and before I could figure out where you were ;-) well, to scrabble for nabble ... if one dabbles on nabble, then perhaps babbling on nabble - would that be rabble ;-) anyone care for a game of Scrabble?

Re: [libreoffice-users] query re. volunteering w/ LO

2012-10-08 Thread anne-ology
I have no problem with registering; but HOW when this CAPTCHA is no where to be found ??? On Mon, Oct 8, 2012 at 3:06 PM, V Stuart Foote vstuart.fo...@utsa.eduwrote: Anne, Correctly completing the CAPTCHA (Completely Automated Public Turing test to tell Computers and Humans Apart)

Re: [libreoffice-users] query re. volunteering w/ LO

2012-10-08 Thread anne-ology
CAPTCHA CAPTCHA CAPTCHA wherefore art thou, CAPTCHA ;-) with apologies to the bard ;-) On Mon, Oct 8, 2012 at 3:53 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) +1 Ah ah, that was what this was about. You aren't supposed to solve the maths puzzle, just

RE: [libreoffice-users] query re. volunteering w/ LO

2012-10-08 Thread V Stuart Foote
Anne, Oops, looks like the Wiki maintainers have removed the graphical CAPTCHA. The math problem performs the same function and allows screen reader assistive technologies to function (although easier to circumvent). So, solve the math problem and complete the registration (if you've not

Re: [libreoffice-users] documentation for LO base

2012-10-08 Thread Hank Alper
Hi I have found that a good source of documentation for LO base is found in some of the documentation written for OO Base. I've been using Marano Casanova's excellent work available at Base_tutorial.pdf (application/pdf Object)https://wiki.documentfoundation.org/images/0/02/Base_tutorial.pdf.

Re: [libreoffice-users] regexp function

2012-10-08 Thread Brian Barker
At 12:05 09/10/2012 +1300, Steve Edmonds wrote: I have had a look, and before I go writing a macro I thought I would check there is no easier solution. I want to return the part of a string in a cell matched by a regular expression. I have strings in cells that could be X12.4Y.2Z1.234 or any