https://bugs.documentfoundation.org/show_bug.cgi?id=125942
Sophia Schroeder <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |WORKSFORME
Status|UNCONFIRMED |RESOLVED
--- Comment #4 from Sophia Schroeder <[email protected]> ---
(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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
