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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
