https://bugs.documentfoundation.org/show_bug.cgi?id=71225
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #7 from Eike Rathke <[email protected]> ---
(In reply to m.a.riosv from comment #5)
> Semicolon is accepted as separator but it is not converted in tilde "~"
> (help mention this), so the function gives an error as result.
> I think this is the bug, entering directly the tilde "~" between ranges,
> works as expected. (In windows ~ = Alt+0126)
That's not a bug. The parameter separator (';' or ',' or whatever) is exactly
that, it separates parameters. AREAS takes only one parameter though, hence one
has to use the reference union / list operator '~'. Either that or for
convenience for those accustomed to Excel behavior enclose a parameter
separated list in additional parentheses, e.g. AREAS((range1,range2,range3))
which then is converted to AREAS((range1~range2~range3)). This is also
mentioned in the help.
The bug here is that when selecting areas once having entered a separator or
any operator, already existing input field content should not be overwritten
(as it is not selected at that stage anymore) but the new selection appended to
the input at the cursor position instead. This is not specific to the AREAS
function, e.g. range1+range2 could be a valid argument for many functions
(using operator '+' with two position dependent implicit intersections for
example).
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
