Description: Action: Format column as DATE dd MMM CCYY "6 MAY 18" Problem:fails to hold this format for subsequent cells in spreadsheet. This bug is intermittent, usually shows up after saving sheet and reloading some time later. Steps to Reproduce: 1.Select Column to format as date 2.Right click and select "Format Cells" 3.Select "Date" and "31 Dec 99" 4.Enter some dates, save and close, then reload some time later. Actual Results: 31/12/99 Expected Results: 31 Dec 99 Reproducible: Sometimes User Profile Reset: No Additional Info: This problem has been in existence for a number of versions. As an aside - activating "soffice.exe" stops Windows 7 from refreshing a screen when a change has occurred. Pressing F5 is the only way to refresh until you restart Windows. But when you again activate "soffice.exe" refresh again fails. User-Agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.139 Safari/537.36
Created attachment 141923 [details] example off cell style date format I suggest you use cell style for your custom date format and not to use direct format on the column. For me its not a bug. If you are not agree you can reopen the report as unconfirmed
You suggest using custom cell format. Why show "3 Dec 99" as a default format if it does not work?
Putting back to UNCONFIRMED until someone else confirms it...
no repro with Version: 6.1.0.0.alpha1+ Build ID: 96337c845c026236975d6a8af52867a5e8d28430 CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk2;
(In reply to sfrjoe from comment #2) > You suggest using custom cell format. > > Why show "3 Dec 99" as a default format if it does not work? Xavier thought YOU were using a custom format. For which language is that a default format for?
did forgot to give the info off LO dutch local with UI in English Version: 6.2.0.0.alpha0+ Build ID: 5708534b942c1d0ce384f6a8473da6bb569410e7 CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group threaded
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20190111
Latest version of Libre Office does not appear to have the problem: 6.0.6.2
(In reply to sfrjoe from comment #8) > Latest version of Libre Office does not appear to have the problem: 6.0.6.2 Thanks for retesting with the latest version. Setting to RESOLVED WORKSFORME as the commit fixing this issue hasn't been identified.