[Libreoffice-bugs] [Bug 123922] a cell with function is not evaluate properly

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Mar 8 20:25:00 UTC 2019


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

--- Comment #5 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
(In reply to Nicolas from comment #4)
> Thanks a lot. Indeed it solved my problem. I am not completely agree about
> not a bug. That happens not with an ODF file but an docx import and if I
> modify the file as you mention to solve the problem on LO, the same problem
> is happening now (with the .) on Excel. 

you could try something like this:

=IF(ISERROR(INDIRECT("calendar!D"&(C13+1)));INDIRECT("calendar.D"&(C13+1));INDIRECT("calendar!D"&(C13+1)))

-- 
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/20190308/40e88cf4/attachment.html>


More information about the Libreoffice-bugs mailing list