https://bugs.documentfoundation.org/show_bug.cgi?id=155239
TBeholder <turbobehol...@mail.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |turbobehol...@mail.ru
--- Comment #4 from TBeholder <turbobehol...@mail.ru> ---
It would be good for import/export, not necessary internally.
On the other appendage, some sort of a “strict type check mode” to catch
mistakes better would not be a bad idea, but it requires more support.
There already are format checks including ISLOGICAL(…).
So what’s left is adding some explicit conversion functions for the rest of
conversions as an equivalent of TEXT(…) / NUMBERVALUE(…) / N(…) and type filter
functions as an equivalent of T().
So maybe just add some explicit function for boolean-to-number type conversion.
In the lax type check mode it’s redundant, but for now it would serve as a
simple and unambiguous way to import/export that odd Excel operator once an
equivalent function exists.
> =SUM(--(F1:F4)).
I just tried this. This returns 1 if the cell in F on the same row (F1 for A1)
is TRUE, 0 if F1 is FALSE… and F1 if F1 is a number, ignoring the rest of that
range,
that is if F1:F4 = [99 1 2 3] it returns
99 if in A1 or B1,
1 in A2 or B2,
2 in A3 or B3,
3 in A4 or B4;
error in A5 or B5,
even though the formula was copied exactly (without allowing it to auto-adjust
relative addresses). It’s not an array formula and there’s no highlights, other
than of F1:F4 on edit per reference from the formula. Is this the expected
behaviour somehow?
Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 2; OS: Linux 5.4; UI render: default; VCL: x11
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 4:7.5.3~rc2-0ubuntu0.18.04.1~lo1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
