[Libreoffice-bugs] [Bug 116106] New: FORMATTING: LO Calc Date as Number lost in saving

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 116106
           Summary: FORMATTING: LO Calc Date as Number lost in saving
           Product: LibreOffice
           Version: 5.1.6.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: lambda.halbe at web.de

Description:
LO Calc: recalculation of formulas at document open or save creates cell format
even when format previously removed

Steps to Reproduce:
1. LO Calc: New document, A1=1.1. -> date format will be detected, enter cell
formula for B1 =A1+1 -> date format will be detected, B1 Ctrl-M (no format at
cell B1, i.e. number), save (.ods)
2. open that document -> cell B1 has date format again

Actual Results:  
cell B1 has date format

Expected Results:
cell B1 should have number format (or no format)


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Ubuntu Chromium/64.0.3282.167 Chrome/64.0.3282.167 Safari/537.36

-- 
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/20180301/5718140c/attachment.html>