Re: Showing number as binary

2020-02-19 Thread Johnny Rosenberg
Den ons 19 feb. 2020 kl 22:18 skrev Brian Barker : > At 21:08 19/02/2020 +0100, Johnny Rosenberg wrote: > >Here's one way. I don't have Apache OpenOffice so I can't test it, > >but I tested it with LibreOffice and I think it would work in Apache > >OpenOffice too: > >=VALUE(BASE(42;2)) > >Now

Re: Loading dictionary extension

2020-02-19 Thread Chuck Spalding
The text refers to version "20200*2*01", but the link goes to version "20200 *1*01". I believe the correct link is: https://sourceforge.net/projects/aoo-extensions/files/17102/51/dict-en-20200201.oxt/download When I double-click on an OXT file (with OpenOffice 4.1.7 for Mac), OpenOffice freezes

Re: Showing number as binary

2020-02-19 Thread Brian Barker
At 21:08 19/02/2020 +0100, Johnny Rosenberg wrote: Here's one way. I don't have Apache OpenOffice so I can't test it, but I tested it with LibreOffice and I think it would work in Apache OpenOffice too: =VALUE(BASE(42;2)) Now format the cell like the following: [...] " " Note that if

Re: Showing number as binary

2020-02-19 Thread Andrew Pitonyak
Can I just say that this is for certain the best solution I have seen to accomplish this. Did not know that you could do that. On Wednesday, February 19, 2020 15:16 EST, Johnny Rosenberg wrote:  Den ons 19 feb. 2020 kl 21:08 skrev Johnny Rosenberg : > Den ons 19 feb. 2020 kl 10:09 skrev

Re: Showing number as binary

2020-02-19 Thread Johnny Rosenberg
Den ons 19 feb. 2020 kl 21:08 skrev Johnny Rosenberg : > Den ons 19 feb. 2020 kl 10:09 skrev Andrea Vt : > >> Hi all :-) >> >> Is there a way to show a number as binary with a separation? >> > Yes, there seems to be. > >> >> E.g. 42 as 0010 1010. (BASE(42;2;8) -> 00101010) >> >> Thanks and have a

Re: Showing number as binary

2020-02-19 Thread Johnny Rosenberg
Den ons 19 feb. 2020 kl 10:09 skrev Andrea Vt : > Hi all :-) > > Is there a way to show a number as binary with a separation? > Yes, there seems to be. > > E.g. 42 as 0010 1010. (BASE(42;2;8) -> 00101010) > > Thanks and have a nice day > Have a nice day you too. And maybe I should answer the

Re: Open Office und Java

2020-02-19 Thread Mechtilde
Hallo Marianne, die stabile Version von Apache OpenOffice 4.1.7 funktioniert nur mit Java 8. Viele Grüße Mechtilde Am 19.02.20 um 16:44 schrieb Jörg Schmidt: > Hallo, > >> -Original Message- >> From: Marianne Orschmann [mailto:mwhj...@gmail.com] >> Sent: Wednesday, February 19,

Re: Showing number as binary

2020-02-19 Thread Brian Barker
At 10:09 19/02/2020 +0100, Andrea Vt wrote: Is there a way to show a number as binary with a separation? E.g. 42 as 0010 1010. (BASE(42;2;8) -> 00101010) You do mean the binary equivalent of 42 but split into two groups - not the separate binary equivalents of the digits 4 and 2 - right?

RE: Open Office und Java

2020-02-19 Thread Jörg Schmidt
Hallo, > -Original Message- > From: Marianne Orschmann [mailto:mwhj...@gmail.com] > Sent: Wednesday, February 19, 2020 1:39 PM > To: users-de@openoffice.apache.org > Subject: Open Office und Java > > Hallo, > > läuft Open Office (Datenbankmodul) mit der neuesten Java >

Open Office und Java

2020-02-19 Thread Marianne Orschmann
Hallo, läuft Open Office (Datenbankmodul) mit der neuesten Java Laufzeitumgebung ? Es ist mir bis jetzt nicht gelungen, die entsprechende javaw.exe in den Einstellungen Opene Office einzubinden. Mit der älteren Javaversion läuft alles bestens. Aus Sicherheitsgründen würde ich aber gern die

Re: Showing number as binary

2020-02-19 Thread Andrew Pitonyak
I wrote a macro to convert to / from binary. You cannot specify the base or the number of digits. I don't remember if it is published in OOME or AndrewMacro, but but are on my web site for download. ⁣Sent from BlueMail ​ On Feb 19, 2020, 4:09 AM, at 4:09 AM, Andrea Vt wrote: >Hi all :-) >

Re: Interpreting a number as enumerator and show the text

2020-02-19 Thread David Robley
Assuming you have a list of the numbers and associated text in separate adjacent columns, you would use VLOOKUP. There is a VLOOKUP tutorial at https://forum.openoffice.org/en/forum/viewtopic.php?f=75=46746 On 19/2/20 8:08 pm, Andrea Vt wrote: Thank you David for the question I use calc to

Re: Interpreting a number as enumerator and show the text

2020-02-19 Thread Andrea Vt
Thank you David for the question I use calc to extract numbers which ha a meaning ... My english is not very good - is it clear now? :-) Am 19.02.2020 um 10:32 schrieb David Robley: In which component of OpenOffice are you needing to do this? You seem to be using inadequate, or

Re: Interpreting a number as enumerator and show the text

2020-02-19 Thread David Robley
In which component of OpenOffice are you needing to do this? You seem to be using inadequate, or insufficient, words here also. On 19/2/20 7:52 pm, Andrea Vt wrote: Text in the or another field doesn't matter Am 19.02.2020 um 10:19 schrieb Andrea Vt: Hello world :-) I decided to send two

Re: Interpreting a number as enumerator and show the text

2020-02-19 Thread Andrea Vt
Sorry for typo: ... in the same or ... Am 19.02.2020 um 10:22 schrieb Andrea Vt: Text in the or another field doesn't matter Am 19.02.2020 um 10:19 schrieb Andrea Vt: Hello world :-) I decided to send two message because .. I hit send to early *rotfl* Question 2: How can I show a text,

Re: Spell check and Update

2020-02-19 Thread David Robley
As you have been sending mails to the users list - users@openoffice.apache.org - that would presumably be the list to which you want to subscribe. To assist you further, I'll repeat below the information for that list, taken from the link I provided earlier: Users Mailing List (Public) This

Re: Interpreting a number as enumerator and show the text

2020-02-19 Thread Andrea Vt
Text in the or another field doesn't matter Am 19.02.2020 um 10:19 schrieb Andrea Vt: Hello world :-) I decided to send two message because .. I hit send to early *rotfl* Question 2: How can I show a text, depending on a number. E.g. 1 -> "That's one" 2 -> "First digit of e" 3 -> "Less

Interpreting a number a enumerator and show the text

2020-02-19 Thread Andrea Vt
Hello world :-) I decided to send two message because .. I hit send to early *rotfl* Question 2: How can I show a text, depending on a number. E.g. 1 -> "That's one" 2 -> "First digit of e" 3 -> "Less than Pi" .. Texts on a separate sheet? Table?...  I irritated google long enough,

Re: Loading dictionary extension

2020-02-19 Thread Rory O'Farrell
On Wed, 19 Feb 2020 15:59:45 +1030 Greg Mayman wrote: > After running the suggested "python" app, I found the red wiggly lines > under all the words had stopped appearing. But now there is no automatic > spell checking going on. When I open Tools > Spell Checker I see no > dictionaries are

Showing number as binary

2020-02-19 Thread Andrea Vt
Hi all :-) Is there a way to show a number as binary with a separation? E.g. 42 as 0010 1010. (BASE(42;2;8) -> 00101010) Thanks and have a nice day Andrea - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org