[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

--- Comment #5 from Elmar <roberg at iafrica.com> ---
My work-around: to change locale setting to English (UK).

However, if I pass this spreadsheet on to someone who has a different locale,
then it may give error again.
the formula is :
=MID(CELL("Filename",A1),SEARCH("$",CELL("Filename",A1),1)+1,100)

You can see how +1,100 can be 1.1 in one locale and 1,100.0 in another.

-- 
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/20190909/e8d26721/attachment.html>