[Libreoffice-bugs] [Bug 136364] Multiple non-contiguous ranges (range list/concatenation/union) broken on import from Excel and in UI

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136364

Eike Rathke <erack at 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 <erack at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200901/ac3489d3/attachment-0001.htm>