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

Uwe Dippel <udip...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|NOTABUG                     |---
     Ever confirmed|0                           |1

--- Comment #2 from Uwe Dippel <udip...@gmail.com> ---
You are right w.r.t. concatenation of an expression using the tilde.

I need it in a larger spreadsheet, where I use the formula 
=IF(ISBLANK(ID.A2),"",INDEX(SRows,QUOTIENT(ID.A2-1,COLUMNS(Seats))*DRows+1)&"
"&INDEX(Seats,MOD(ID.A2-1,COLUMNS(Seats))+1))

(Whatever this formula does) if I set the field 'Seats' to 
$'LA Mensa'.$D$6:$E$6
my sheet works; with 
$'LA Mensa'.$D$6~$'LA Mensa'.$E$6
my sheet does not work (Errors 504)

In any case, my understanding is that both expressions ought to parse to
exactly the same array 'Seats' (see formula above) for calculation.

Therefore I reopen it cautiously. 
Should my understanding be wrong, please inform me likewise.

-- 
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

Reply via email to