| Summary: | FORMATTING: Cell Formatting Date DD-MM-YY | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | claimer |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | 3.6.1.2 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Document created with LO3.5.0 | ||
I can't reproduce using Linux Mint 14 with LibreOffice 3.5.0 and Version 4.1.0.0.alpha0+ (Build ID: f1bca26afcc7593d0124c216c0400a9e2e47fc1) Is it possible for you to retest with more recent versions? I'll also attach the file I create with LO 3.5.0. Thanks for reporting and taking the time to retest. Kind regards, Joren Created attachment 73701 [details]
Document created with LO3.5.0
I mark this bug as RESOLVED WORKSFORME because I figured out you can edit the range LibreOffice'll try to interpret it as a date. Please go to Tools -> Options -> LibreOffice -> General: Interpret as years between: 1930 and 2029. So if you try to enter a date beyond that range, it'll not try to interpret this as a date. |
Problem description: Steps to reproduce: 1. Create a Calc-File with an older (release) version with a date, formattet with "DD-MM-YY" 2. Open that file in 3.6.1.2-release 3. Type a new date in that cell like "31-12-15" for the 31st of Dec. 2015 Current behavior: Calc will display: "15.12.31" (15th of Dec. 2031) Expected behavior: Calc should display "31.12.15" - like the other versions before also did, when typing the date with "-" instead of "."... (When typing the date with ".", the correct date will appear). Platform (if different from the browser): Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20100101 Firefox/16.0 Win 7 (64 Bit)