[Libreoffice-bugs] [Bug 119509] New: FILEOPEN wrong column format in ODS but not XLSX

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 119509
           Summary: FILEOPEN wrong column format in ODS but not XLSX
           Product: LibreOffice
           Version: 6.1.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dan at arnfield.com

Description:
I have a document with a column of dates and a second column which subtracts a
certain number from the first to get the number of days since a certain date.
For example:

A2: 06/27/2018
B2: =A2-43277

Where 43277 is the date 06/26/2018 converted to a number, so the result is 1. I
have this column formatted as general numbers. When the file is saved in xlsx
format it's displayed correctly when the file is closed and reopened, but if
it's in ODS the column displays in the date format.

Steps to Reproduce:
1. Create a column or cell with a formula of the form [date cell] - number
2. Set its format to general number
3. Save file in ODS format and reopen the file

Actual Results:
Column or cell displays in date format. The "General" option is ticked under
Format > Number Format.

Expected Results:
Column or cell displays in general number format.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 6.1.0.3
Build ID: 6.1.0-2
CPU threads: 16; OS: Linux 4.18; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); Calc: group threaded

-- 
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/20180826/1e731361/attachment.html>