Consider the following scenario: 1. Set a cell value to =now() - default date format is applied automatically 2. Change format to number, general - now cell displays a number of days since 1-1-1900 3. Save, close, reopen - formatting is lost, default date format is applied again Explicit formatting should be retained and may not be changed automatically. Same problem with other date functions - today(), date(), etc, if however cell value is an expression e.g. =now()+0 everything works fine.
Hello, works for me with LO 4.4.3, win7. Please test with latest version, https://www.libreoffice.org/download/libreoffice-fresh/ Thank you.
Created attachment 115761 [details] testcase
Does NOT work for me with 4.4.3.2 windows 7 32-bit. I am attaching a testcase date_autoformat_bug.ods 1. open it 2. set 'number, general' format to cell A1 - format changes to number 3. set 'number, general' format to cell A2 - format changes to number 4. save 5. close 6. open it again - cells A1 and A2 have date formats, not number formats 2 and 3 are separate steps for a reason, this bug manifests itself in another way: if you try selecting cells A1 and A2 and then apply number.general format to this selection format won't change at all.
I can confirm now with your file. Weird, when I set =NOW() in another cell then it works for me, even with your file. Looks like it works in another cells, please test it with cell D5=NOW() Setting to NEW. Version is oldest.
Yes, I can set numeric format for now() in D5, it is kept after saving and opening, and after that I can set and restore numeric format even in A1. But I still cannot set numeric format for A1:A2 selection. Weird indeed.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.5 or 5.2.1 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20160920
still reproducible with 5.2.1.2 for windows
For cells that are formatted to the standard (non-fixed) General number format a date format is applied when a function is calculated that returns a date/time result. TODAY() and NOW() are always recalculated, hence a format is applied. This won't be changed. Use an explicit number format instead of the General format, or if the automatic decimals are wanted define a format of General;General which also creates a new fixed non-standard format.
Was going to write an angry rejoinder but checked first - this bug is fixed in 5.4.1.2. All manifestations are now gone: format is saved, formatting can be applied to multiple cells, all cells behave in the same manner.