https://bugs.documentfoundation.org/show_bug.cgi?id=136364
Eike Rathke <er...@redhat.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
Ever confirmed|0 |1
Summary|Problem with not contiguous |Multiple non-contiguous
|ranges |ranges (range
| |list/concatenation/union)
| |broken on import from Excel
| |and in UI
--- Comment #2 from Eike Rathke <er...@redhat.com> ---
Fwiw, I thought there's already a bug for that but didn't find it..
Both UI and Excel import filter don't handle a single argument of a range list
of more than two ranges correctly (note the list in extra parentheses, this is
something different than simply multiple range arguments), for example
=SUM((B2:B3,C4:C5,D6:D7))
should be converted to
=SUM((B2:B3~C4:C5~D6:D7))
but instead gives
=SUM((B2:B3~C4:C5,D6:D7))
resulting in Err:509
Same for single cell list concatenation
=SUM((B2,C4,D6))
gives
=SUM((B2~C4,D6))
instead of
=SUM((B2~C4~D6))
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs