https://bugs.documentfoundation.org/show_bug.cgi?id=125910
Bug ID: 125910
Summary: Not calculating formula in existing sheet
Product: LibreOffice
Version: 6.2.4.2 release
Hardware: All
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
In an already existing sheet (with data imported from CSV) I have in cell D2:
20.12.1982
When I enter this formula in another cell
=DATE(RIGHT(D2,4), RIGHT(LEFT(D2,5), 2), LEFT(D2,2))
it's not calculated, but rather placed as text into that cell. When I fill in
the same value into D2 of a new sheet and the formula as well, it works as
expected and the cell shows:
12/20/82
Steps to Reproduce:
As written in the description
Actual Results:
As written in the description
Expected Results:
As written in the description
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
--
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
