[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