Showing number as binary

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 For

Re: Loading dictionary extension

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 loa

Interpreting a number a enumerator and show the text

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, u

Re: Interpreting a number as enumerator and show the text

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 t

Re: Spell check and Update

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 l

Re: Interpreting a number as enumerator and show the text

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: Interpreting a number as enumerator and show the text

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 mes

Re: Interpreting a number as enumerator and show the text

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 insufficient,

Re: Interpreting a number as enumerator and show the text

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&t=46746 On 19/2/20 8:08 pm, Andrea Vt wrote: Thank you David for the question I use calc to

Re: Showing number as binary

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 :-) > >Is

Re: Showing number as binary

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? Try

Re: Showing number as binary

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 qu

Re: Showing number as binary

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

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 Andr

Re: Showing number as binary

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 o

Re: Loading dictionary extension

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

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 form