Hi gurus...
- I'm using OOcalc in danish. It annoys me that all formula keywords
have been (doh!!) translated into hard to understand danish...
I.e., 'if' becomes 'hvis' and worse than that.
Is there a way to have OOcalc use standard (english) keywords in calc?
--
Dotan Cohen wrote:
No, my locale is not US English:
$ locale
LANG=he_IL.utf8
This is the only relevant setting which is read from the OS when a
default locale has to be evaluated.
I figured that I could get away with not posting that as I posted this:
$ date +%x
2009-12-08
The program
John Meyer wrote:
On 12/9/2009 10:25 AM, Johnny Rosenberg wrote:
2009/12/8 John Meyerpueblonat...@opensuse.us:
Have you tried =CELL(…)?
Doesn't have an infotype returning the sheet name.
My default template for Calc has 2 named references:
1. InsertNamesDefine...[Ctrl+F3]
Terry Ehrhart wrote:
Is there a way to convert a Base file back to Access.
I have a program that only recognizes an Access data file.
I should think that if you can connect to both databases it shouldn't be
too difficult to pump the table data from one to the other.
I don't use OpenOffice
Dotan Cohen wrote:
Input masks are made for database forms where you have fields and records
rather than cells:
http://user.services.openoffice.org/en/forum/viewtopic.php?t=22506p=102636#p102636
I knew that I was using the wrong term, but what I meant was: a way
to tell the computer that an
Brian Barker wrote:
At 10:23 08/12/2009 +0200, Dotan Cohen wrote:
I have a column formatted as HH:MM. When the user enters 14 I need
it to be registered as 14:00 assuming a 24-hour clock. How can this
be achieved?
One obvious workaround is to have two columns: one in which the user
enters
Harald und Doris Kral wrote:
Hallo,
ich nutze Windows XP Home Edition, Open Office 3.1.1
Da ich viele Tabellen mit Spaltenbeschriftungen habe, wollte ich gern die
Option: Daten/Sortieren/Bereich enthält Spaltenbeschriftungen/ dauerhaft
anwählen, was aber leider nicht funktioniert. Bei jedem
menu:InsertQuery (SQL)...
SELECT *, UPPER(Name) AS NAME FROM Your Table
Selects all the fields from a table named Your Table plus a calculated
field labeled NAME having the upper cased value of a text field named
Name.
Just replace the quoted object names with you actual ones.
This type of
Frank Lee wrote:
Thanks Dave,
I found /fonts/ in the windows folder.
In windows 7 a Load Fonts button magically appeared.
Work related files seem to hold format in OO.
Now I will try the same OO edited files at work in MS Word.
Next Ill try excel. If it works my bussiness will go off MS O!!!
Verner Kjærsgaard wrote:
Hi gurus...
- I'm using OOcalc in danish. It annoys me that all formula keywords
have been (doh!!) translated into hard to understand danish...
I.e., 'if' becomes 'hvis' and worse than that.
Is there a way to have OOcalc use standard (english) keywords in calc?
At 20:04 12/12/2009 +1100, Pierre Noname wrote:
Terry Ehrhart wrote:
Is there a way to convert a Base file back to Access. I have a
program that only recognizes an Access data file.
I should think that if you can connect to both databases it
shouldn't be too difficult to pump the table data
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, but I
think you have to go back to version 1 or even 0.x for that. Since then
there's been none.
Evolution is free or, if you are a Mozilla man,
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, but I think you have to go back to version 1 or even 0.x for
that. Since then there's been none.
Evolution is
No, my locale is not US English:
$ locale
LANG=he_IL.utf8
This is the only relevant setting which is read from the OS when a default
locale has to be evaluated.
Really? In my opinion it is wrong behaviour to ignore the user's
specifically-set Time and other settings. Is there a place where
I knew that I was using the wrong term, but what I meant was: a way
to tell the computer that an integer [0,23] should be read as
belonging to the hour.
If [0,23] means two integers 0 and 23 to be read as hours and minutes:
A1: 0
B1: 23
other cell, formatted as time: =A1/24+B1/1440
No,
Andreas
Do you know if there any help-FAQ on how?
some equivalent (ToolsOptions...Fonts...).
On Sat, Dec 12, 2009 at 6:20 AM, Andreas Saeger saege...@onlinehome.dewrote:
Frank Lee wrote:
Thanks Dave,
I found /fonts/ in the windows folder.
In windows 7 a Load Fonts button magically
jomali wrote:
Your answer leads me to believe that you haven't really investigated the
possibilities of using the database facilities for solving your problem,
since you aren't even aware that OOo provides HSQLDB as its default, not
MySQL. If you really need to use a database to manage your
If you need to produce documents from php data the class: OpenTBS
is great.
http://www.phpclasses.org/browse/package/5797.html
It is a plugin to the TinyButStrong php class that merges XML
documents. http://www.tinybutstrong.com/
OpenTBS will open OpenOffice documents as templates, merge
Andreas Saeger wrote:
menu:InsertQuery (SQL)...
SELECT *, UPPER(Name) AS NAME FROM Your Table
Selects all the fields from a table named Your Table plus a calculated
field labeled NAME having the upper cased value of a text field named
Name.
Just replace the quoted object names with you
Dotan Cohen wrote:
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
Dotan Cohen wrote:
I knew that I was using the wrong term, but what I meant was: a way
to tell the computer that an integer [0,23] should be read as
belonging to the hour.
If [0,23] means two integers 0 and 23 to be read as hours and minutes:
A1: 0
B1: 23
other cell, formatted as time:
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 manipulate most relational databases
Brian Barker wrote:
Though no doubt well meant, I think this and other replies may have
missed the point. As I read the original query, the questioner has
OpenOffice installed but not Access. S/he also has some third-party
software that expects its data in the form of an Access database
Dotan Cohen wrote:
BIG SNIP
Simple, flat database table used in a spreadsheet:
http://user.services.openoffice.org/en/forum/viewtopic.php?t=21099p=96427#p96427
(input form, user defined filter form, data pilot, free of macro code)
This is a great link and I will make use of it in the
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.
James Liebert
How do I make OOo recognize file extensions?
I'm currently using OOo 3.2 build 9460 (soon to be 9466) and I'm having a
little trouble with this.
I've had to assign each filetype manually but I was hoping there was a
better way.
I thought someone said that it can be done in a release version rather
On 12/12/2009 4:39 PM, Sean wrote:
How do I make OOo recognize file extensions?
I'm currently using OOo 3.2 build 9460 (soon to be 9466) and I'm having a
little trouble with this.
I've had to assign each filetype manually but I was hoping there was a
better way.
I thought someone said that
- Original Message -
From: Programmer In Training p...@joseph-a-nagy-jr.us
To: users@openoffice.org
Cc: Sean u...@frightenstein.com
Sent: Saturday, December 12, 2009 6:42 PM
Subject: Re: [users] File extensions
Ditto to you, my friend.
But what is that supposed to mean?
On 12/12/2009 6:57 PM, Sean wrote:
Ditto to you, my friend.
But what is that supposed to mean?
If you're responding to the thread, what operating system are you using?
-
To unsubscribe, e-mail:
Sean wrote:
How do I make OOo recognize file extensions?
I'm currently using OOo 3.2 build 9460 (soon to be 9466) and I'm having a
little trouble with this.
I've had to assign each filetype manually but I was hoping there was a
better way.
I thought someone said that it can be done in a release
- Original Message -
From: John Meyer pueblonat...@opensuse.us
To: users@openoffice.org
Sent: Saturday, December 12, 2009 9:19 PM
Subject: Re: [users] File extensions
On 12/12/2009 6:57 PM, Sean wrote:
Ditto to you, my friend.
But what is that supposed to mean?
It's supposed to
- Original Message -
From: Andreas Saeger saege...@onlinehome.de
To: users@openoffice.org
Sent: Saturday, December 12, 2009 9:21 PM
Subject: [users] Re: File extensions
3.2 is a version that has not been released to the public yet. It has
been released as an unstable version to be
On 12/12/2009 9:42 PM, Sean wrote:
- Original Message -
From: John Meyer pueblonat...@opensuse.us
To: users@openoffice.org
Sent: Saturday, December 12, 2009 9:19 PM
Subject: Re: [users] File extensions
On 12/12/2009 6:57 PM, Sean wrote:
Ditto to you, my friend.
But what is
On 12/13/2009 12:26 AM, Programmer In Training wrote:
Then it should already be associated with all the OOo files.
Never mind, didn't know that dev versions don't grab file association.
signature.asc
Description: OpenPGP digital signature
34 matches
Mail list logo