Den ons 19 feb. 2020 kl 22:18 skrev Brian Barker <b.m.bar...@btinternet.com.invalid>:
> 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: > >[...] > >0000" "0000 > > > >Note that if omitting the quotes, typing 0000 0000 in that field > >will fail, (the cell will display 00 101 010). I'm not sure why > >though. As I said, I tested this in LibreOffice, hopefully it will > >work in Apache OpenOffice too. > > For what it's worth, the version without quotes works too in my OpenOffice. > > At 21:16 19/02/2020 +0100, Johnny Rosenberg wrote: > >After some more experimenting I found this way, ... > >And the cell formula looks like this: > >=TEXT(VALUE(BASE(42;2));"0000"" ""0000") > > Again, > =TEXT(VALUE(BASE(42;2));"0000 0000") > works in my OpenOffice. > > Ok, seems to be a bug (or feature…) in LibreOffice then. I just saw that Apache OpenOffice is available in AUR (Arch User Repository), so I'm installing it right now, so I don't have to guess in the future… 😁 Kind regards Johnny Rosenberg > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > >
