[Libreoffice-bugs] [Bug 125910] New: Not calculating formula in existing sheet

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: fabianosidler at swissonline.ch

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190613/11b28730/attachment.html>