Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 14 Jan 2021 04:18:41 +0100'BASE' function for fractional values?https://ask.libreoffice.org/en/question/287474/base-function-for-fractional-values/ hi @all,
i'm just curious if there is something like DEC2BIN or BASE(xyz;2) which is capable handling (decimal) fractions like 1,5 or 12,004505?
'=BASE(10;2)' results in '1010' (binary), and with what i'm looking for something like 'FRACBASE(10,5;2)' should result in 1010,1 (binary),
our friend Lupp build something similar working with an external DLL and producing the digits of exponent and mantissa of the IEEE representation of decimal figures in separate cells, i tried myself with - long - expressions in a sheet, both work but are not quite handy,
is there any simple solution around?
reg.
b. newbie-02Thu, 14 Jan 2021 04:18:41 +0100https://ask.libreoffice.org/en/question/287474/no cInt() from positive numbers? cInt("+308") = 0 ???https://ask.libreoffice.org/en/question/266380/no-cint-from-positive-numbers-cint308-0/hi,
small problem,
in a macro i wanted to use a formula with 'cInt' (converts to Integer),
'cInt("+308")' -> '0' ????
while
'cInt("308")' -> '308'
and
'cInt("-308")' -> '-308'
perplexed,
b. newbie-02Wed, 16 Sep 2020 10:44:31 +0200https://ask.libreoffice.org/en/question/266380/