https://bugs.documentfoundation.org/show_bug.cgi?id=145827
Bug ID: 145827
Summary: 'Standard' cell format turns to Date if it's the first
cell in a column
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
In a new spreadsheet:
1. Put '=TODAY()' to A1
2a. Format A1 as Number->Standard
3a. Save as ODS and reload
The cell format reverts to date.
Alternatively, do not do 2a, and do the following:
2b. Put =A1 to A2
3b. Put =A1 to B1
4b. Format A2 and B1 as Number->Standard (but keep A1 formatted as date)
5b. Save as ODS and reload
The format of A2 will stay numeric, but format of B1 will revert to date.
Tested with Version: 7.2.3.1 (x64) / LibreOffice Community
Build ID: 1d5dee817bde88d78dbcc0d00f88492568e131d5
CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded
and with Version: 4.3.0.4
Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0
In versions 4.1-4.2, A2 and B1 both showed date after reload, and had Date
format in cell format dialog.
In version 4.0 and older, A2 and B1 also both showed date after reload, but had
Number->Standard format in the dialog.
--
You are receiving this mail because:
You are the assignee for the bug.
