[Libreoffice-bugs] [Bug 127451] return sheet name formula does not work

[bugzilla-daemon at bugs.documentfoundation.org]

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

Xisco Faulí <xiscofauli at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |xiscofauli at libreoffice.org
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEEDINFO

--- Comment #7 from Xisco Faulí <xiscofauli at libreoffice.org> ---
=MID(CELL("Filename",A1),SEARCH("$",CELL("Filename",A1)0,1)+1,1)

also gives an error in

Version: 5.4.0.0.alpha1+
Build ID: 9feb7f7039a3b59974cbf266922177e961a52dd1
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group

however

=MID(CELL("Filename";A1);SEARCH("$";CELL("Filename";A1);1)+1;100)

works fine in master and 6.0

@Elmar, please recheck the formula...

-- 
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/20191016/e574495f/attachment.html>