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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Jun 16 07:54:19 UTC 2019


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

Sophia Schroeder <sophia.schroeder at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |WORKSFORME
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #4 from Sophia Schroeder <sophia.schroeder at libreoffice.org> ---
(In reply to Oliver Brinzing from comment #3)
> 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)

This is what I mean: It is autoconverted in lowercase. 

But will just try your suggestion with the latest daily.

Copypasting works, fine.
Now self-typing, works too, hm.

No longer autoconverting, even with the SUM function. \o/ 
Will close it for now as WFM, reopen if this will happen again.

Thank you for your help. :-D

-- 
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/0dd6d77f/attachment-0001.html>


More information about the Libreoffice-bugs mailing list