https://bz.apache.org/ooo/show_bug.cgi?id=126908
--- Comment #6 from Nicolay <[email protected]> --- Sorry, I responded to comments by e-mail because they receive e-mail, too. I repeat them here. In a comment #1: I found the bug on a version of OO 3 ... The first thing I did Open Office has updated to version 4.1.2. Bug left. Asking your setting does not change the behavior of the program and the range of bug. Changing only the previously entered date. Date format also does not change anything. Maybe in the Russian version has some features? Sending video with a demonstration of a bug. In a comment #2: 1. I worked in the .xls format. But now I tried to save a document in a format .ods. Nothing changed. 2. 1899-12-30. When switching to other options improper input range does not change. 3. I tape: "14.07.1919". I see: "13.07.19" 4. Cell Format code is DD.MM.YY If I change the format code, changes the display accordingly. Number 14 still turns into 13. My more information (single email): Maybe the following will help you find a bug. I fill column serial numbers 7133, 7134, 7135, 7136, 7137. I select the filled cells and change their format to the format of the date code DD.MM.YY. I'm getting 11.07.19, 12.07.19, 13.07.19, 15.07.19, 16.07.19. Note that July 14 is absent. In a comment #4: No. The forum thread discussed the effect of the interaction of two documents with different zero dates. And my problem - bug in the conversion procedure "number to date", that is used when displaying the date: the shift by one day in the "yesterday" for the numbers from 119 to 7135. At the same time built-in functions DAY, MONTH, YEAR do not contain this bug - I tested. -- You are receiving this mail because: You are the assignee for the issue.
