[Libreoffice-bugs] [Bug 125942] Function names are converted to lowercase and so not working

[bugzilla-daemon at bugs.documentfoundation.org]

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

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oliver.brinzing at gmx.de

--- Comment #3 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
in your example, the formula syntax in cell H45 =week(1,070,2019;31,070,2019;1)
is not correct - this should work:

=WEEKS(DATEVALUE("1.7.2019");DATEVALUE("31.7.2019");1)

or referencing dates e.g.:
A49 01.07.2019
A50 31.07.2019
=WEEKS(A49;A50;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/20190616/d2904725/attachment.html>