[users] Re: calculating fields with a macro in a database

2009-12-13 Thread Jonathan Kaye
Andreas Saeger wrote: Jonathan Kaye wrote: Andreas Saeger wrote: menu:InsertQuery (SQL)... SELECT *, UPPER(Name) AS NAME FROM Your Table SELECT *, Charis(ENTRY Sorting) AS Beaut FROM Table1 SQL is not a programming language. It is more like a command line environment to

Re: [users] Re: Loading truetype fonts into OO

2009-12-13 Thread Michael Adams
On Sat, 12 Dec 2009 12:20:02 +0100 Came this utterance formulated by Andreas Saeger to my mailbox: Microsoft has a (patented?) mechanism which embeds True Type (tm) in their document formats. OOo/ODF does not support this. The fonts have to be installed or replaced by some equivalent

Re: [users] Diary/Calender

2009-12-13 Thread Michael Adams
On Sat, 12 Dec 2009 09:03:58 -0600 Came this utterance formulated by Programmer In Training to my mailbox: On 12/12/2009 8:51 AM, John Meyer wrote: On 12/11/2009 7:14 AM, James Wilde wrote: You're losing it. ;) Once upon a time around the end of the last century there was a calendar,

Re: [users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-13 Thread Dotan Cohen
Where is there an outline of which locales provide which formatting? I have gone through quite a bit of the docs as support.openoffice.org but I find nothing. Any number format dialog in this office suite shows all the built-in formattings with format codes for all the built-in locales and

Re: [users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-13 Thread Dotan Cohen
20091212.1714, or 2009-12-12.17:14, or 2009.12.12,  1714h, or 2009/12/12; whatever, Akron, Ohio, US; You and I are not going back to pencil and paper.  I say to configure it the universal way our tools will sort.  This [should be] the end, my friend, of obsolescent convention. I think

Re: [users] Re: Calc cell formatting: hours

2009-12-13 Thread Dotan Cohen
I cannot answer your issue - but if I may but in - have you filed a bug report about this? I just commented on this bug, already filed: http://www.openoffice.org/issues/show_bug.cgi?id=47906 -- Dotan Cohen http://what-is-what.com http://gibberish.co.il

[users] Re: calculating fields with a macro in a database

2009-12-13 Thread Andreas Saeger
You can extend the HSQL database application by means of Java libraries and you can extend the office by means of macros. Both apps are strictly separated from each other although they are bundled in your office installation and despite the fact that database data and the office data are

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-13 Thread Andreas Saeger
Dotan Cohen wrote: Thanks, Andreas, but Hebrew support is far different than -mm-dd support! -mm-dd is not the default date format for Israel, rather, I think it is the British yy/mm/dd as you are familiar with. As far as I can see, ISO date -mm-dd is among the predefined date

Re: [users] Diary/Calender

2009-12-13 Thread Programmer In Training
On 12/12/2009 3:04 PM, Michael Adams wrote: snip Now you are just tossing stupidity out there. Wordpress is for writing blogs and uses third party components. He wants a calendar and diary, not just a calendar. And you can make all entries private so it can be used for a private diary. So

[users] Labels in OOo

2009-12-13 Thread joe g
Hi can any one tell me how to populate a blank label sheet I managed to do after a long hassle with addresses? Tks

[Fwd: Re: [users] A normal user shouldn't be trying . . Who tell us what we cannot use?]

2009-12-13 Thread Tim Lungstrom
Programmer In Training wrote: snip You are completely misinterpreting the intent. Beta's, builds and RCs are meant for those who give bug reports, contribute code, and the like. Anyone can use it but you and I, as normal users, are not the intended snip PIT Who said that I was a normal

[users] testing BATV sub/unsub issue

2009-12-13 Thread Charles Marcus
Apologies... -- Best regards, Charles - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org

[users] [moderated]

2009-12-13 Thread Lawrence Barry
I have downloaded open office from the internet, but it does not appear on my computer. It has taken memory but does not show up on my all programs where is it ? pala...@genext.net

Re: [users] [moderated]

2009-12-13 Thread Rob Clement
On 10/12/2009 17:45, Lawrence Barry wrote: I have downloaded open office from the internet, but it does not appear on my computer. It has taken memory but does not show up on my all programs where is it ? pala...@genext.net Hi Lawrence. I assume you mean that the program has taken up disc

Re: [users] [moderated]

2009-12-13 Thread James Knott
Lawrence Barry wrote: I have downloaded open office from the internet, but it does not appear on my computer. It has taken memory but does not show up on my all programs where is it ? pala...@genext.net After you download the package, you have to install it. You do this by (In Windows)

Re: [users] [moderated]

2009-12-13 Thread Barbara Duprey
Lawrence Barry wrote: I have downloaded open office from the internet, but it does not appear on my computer. It has taken memory but does not show up on my all programs where is it ? pala...@genext.net It sounds as if you've downloaded (hopefully from www.openoffice.org) but not yet

[users] Very OT: Re: [users] Re: MP4 Files OOo

2009-12-13 Thread Harold Fuchs
NoOp wrote: snip @Harold: forget all that, instead see: http://www.tech-faq.com/windows-media-player-mp4-codec.shtml Download install the K-Lite Mega Codec Pack http://www.free-codecs.com/K_Lite_Mega_Codec_Pack_download.htm During the install associate w/WMP *now* the mp4 will play in both

[users] Solved (sort of) Re: Very OT: Re: [users] Re: MP4 Files OOo

2009-12-13 Thread Harold Fuchs
Harold Fuchs wrote: NoOp wrote: snip @Harold: forget all that, instead see: http://www.tech-faq.com/windows-media-player-mp4-codec.shtml Download install the K-Lite Mega Codec Pack http://www.free-codecs.com/K_Lite_Mega_Codec_Pack_download.htm During the install associate w/WMP *now* the

Re: [users] To use Alt-* or Ctrl-* for keyboard shortcuts?

2009-12-13 Thread Harold Fuchs
Dotan Cohen wrote: Many of OOo's menus have keyboard shortcuts underlined. How is the user supposed to know if the modifier key for the shortcut is Ctrl-* or Alt-*? As far as I know, in *Windows* an underlined letter in a menu item *always* means Alt and the letter. If OOo does not follow

Re: [users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-13 Thread Dotan Cohen
2009/12/13 Andreas Saeger saege...@onlinehome.de: Dotan Cohen wrote: Thanks, Andreas, but Hebrew support is far different than -mm-dd support! -mm-dd is not the default date format for Israel, rather, I think it is the British yy/mm/dd as you are familiar with. As far as I can

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-13 Thread Andreas Saeger
Dotan Cohen wrote: 2009/12/13 Andreas Saeger saege...@onlinehome.de: Dotan Cohen wrote: Thanks, Andreas, but Hebrew support is far different than -mm-dd support! -mm-dd is not the default date format for Israel, rather, I think it is the British yy/mm/dd as you are familiar with.

Re: [users] To use Alt-* or Ctrl-* for keyboard shortcuts?

2009-12-13 Thread Johnny Rosenberg
2009/12/13 Harold Fuchs hwfa.openoff...@googlemail.com: Dotan Cohen wrote: Many of OOo's menus have keyboard shortcuts underlined. How is the user supposed to know if the modifier key for the shortcut is Ctrl-* or Alt-*? As far as I know, in *Windows* an underlined letter in a menu item

Re: [Fwd: Re: [users] A normal user shouldn't be trying . . Who tell us what we cannot use?]

2009-12-13 Thread jonathon
On Fri, Dec 11, 2009 at 20:33, Tim Lungstrom wrote: Who said that I was a normal user? The assumption is that if you are _NOT_ a developer, or actively filing bug reports, or doing QA, you are a normal user. And as such, using anything other than the released stable version is akin to asking

[users] Long text in calc

2009-12-13 Thread Yogi
Hi there, I have been trying to use calc to organize some information. For example, various pieces of information about one place I am applying to for a job go in one row of the calc sheet. This means that sometimes the amount of text in one column becomes kind of large, and I was wondering if

Re: [users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-13 Thread Dotan Cohen
Yes, but it is not the default locale in any but Hungarian and Latvian. I need it to be my default date format, so when an unformatted cell gets 2005-9-2 Calc doesn't mangle it into something else. This can not work with unformatted cells (you mean number format General). You are the one to

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-13 Thread Andreas Saeger
Dotan Cohen wrote: Yes, but it is not the default locale in any but Hungarian and Latvian. I need it to be my default date format, so when an unformatted cell gets 2005-9-2 Calc doesn't mangle it into something else. This can not work with unformatted cells (you mean number format General).

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-13 Thread NoOp
On 12/13/2009 02:11 PM, Dotan Cohen wrote: Yes, but it is not the default locale in any but Hungarian and Latvian. I need it to be my default date format, so when an unformatted cell gets 2005-9-2 Calc doesn't mangle it into something else. This can not work with unformatted cells (you mean

Re: [users] File extensions

2009-12-13 Thread Sean
Ah that's it. You save the message as an attachment. Not very impressive. The operating system is Windows 2000. No I only use one copy at a time due to space restraints. Thus when I run a development version it's usually the only one. I did temporarily try installing OOo 3.1.1 beside it but that

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-13 Thread NoOp
On 12/13/2009 03:51 PM, NoOp wrote: On 12/13/2009 02:11 PM, Dotan Cohen wrote: Yes, but it is not the default locale in any but Hungarian and Latvian. I need it to be my default date format, so when an unformatted cell gets 2005-9-2 Calc doesn't mangle it into something else. This can not

Re: [Fwd: Re: [users] A normal user shouldn't be trying . . Who tell us what we cannot use?]

2009-12-13 Thread Tanstaafl
On 12/11/2009, Tim Lungstrom (timo...@lungstrom.com) wrote: What I do not like is when someone decided for me what I can and cannot do. If I did I would not have 3 degrees in the computer field. I would have stayed in farm country and either drove a tractor or worked in a fast food place.

[users] Re: To use Alt-* or Ctrl-* for keyboard shortcuts?

2009-12-13 Thread Larry Gusaas
On 2009/12/13 3:18 PM Johnny Rosenberg wrote: 2009/12/13 Harold Fuchshwfa.openoff...@googlemail.com: Dotan Cohen wrote: Many of OOo's menus have keyboard shortcuts underlined. How is the user supposed to know if the modifier key for the shortcut is Ctrl-* or Alt-*? As far

Re: [users] Long text in calc

2009-12-13 Thread Brian Barker
At 17:10 13/12/2009 -0500, Yogi Sharma wrote: * Is there a way to remove the functionality which changes *blah* to blah in bold. Yes. Go to Tools | AutoCorrect Options... | Options, and remove the tick from Automatic *bold* and _underline_. I trust this helps. Brian Barker

Re: [users] Re: To use Alt-* or Ctrl-* for keyboard shortcuts?

2009-12-13 Thread jomali
On Sun, Dec 13, 2009 at 7:26 PM, Larry Gusaas larry.gus...@gmail.comwrote: On 2009/12/13 3:18 PM Johnny Rosenberg wrote: 2009/12/13 Harold Fuchshwfa.openoff...@googlemail.com: Dotan Cohen wrote: Many of OOo's menus have keyboard shortcuts underlined. How is the user supposed to know if

[users] number to text conversion

2009-12-13 Thread SubrataNath
Sir, I want to know that how can I get a text (character) to a numeric value. Say 201 to be as Two Hundred and One or Two Zero One. ie. if a Cell (Say A1) is entered with a numeric value 21 then in Cell (say B1) will display Two Hundred and One or Two Zero One. Thanks to all for the support

Re: [Fwd: Re: [users] A normal user shouldn't be trying . . Who tell us what we cannot use?]

2009-12-13 Thread Web Kracked
jonathon wrote: snip Who said that I was a normal user? The assumption is that if you are _NOT_ a developer, or actively filing bug reports, or doing QA, you are a normal user. And as such, using anything other than the released stable version is akin to asking for your hardware to be

[users] Re: [Fwd: Re: A normal user shouldn't be trying . . Who tell us what we cannot use?]

2009-12-13 Thread Larry Gusaas
On 2009/12/13 4:08 PM jonathon wrote: The assumption is that if you are _NOT_ a developer, or actively filing bug reports, or doing QA, you are a normal user. And as such, using anything other than the released stable version is akin to asking for your hardware to be trashed, and your data to

Re: [users] Re: [Fwd: Re: A normal user shouldn't be trying . . Who tell us what we cannot use?]

2009-12-13 Thread jonathon
Web Kracked wrote: Even the big boys of industry can have you run a software update and trash your computer, but not to the point that the hardware goes bad. I take it you've never read the disclaimers that go along with those software upgrades. Those disclaimers are there, precisely because

[users] Re: [Fwd: Re: A normal user shouldn't be trying . . Who tell us what we cannot use?]

2009-12-13 Thread Larry Gusaas
On 2009/12/13 11:59 PM jonathon wrote: Web Kracked wrote: Even the big boys of industry can have you run a software updateand trash your computer, but not to the point that the hardware goes bad. I take it you've never read the disclaimers that go along with those software upgrades. Those

Re: [users] number to text conversion

2009-12-13 Thread Louis-Marc Muscat
Hi, I use all the times numeric formats, please try to explain: 21 written in (A1) then (by a function) in (B2) displays Two Hundred and One or Two Zero One (with letters). Is I understand? Best regards, LM MUSCAT FRANCE - Original Message - From: subratan...@punjlloyd.com To: