| Summary: | EDITING: I try a division and the result is a date | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Gravitania <rosemeer> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | luuk34, miguelangelrv |
| Priority: | medium | ||
| Version: | 4.1.4.2 release | ||
| Hardware: | Other | ||
| OS: | Windows (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | A spread sheet with this failure in sheet 2 (Hoja 2) G12 | ||
Try 'Clear direct Formatting' (CTRL+M) in the 'Format' menu If that does not help, do 'Format'/'Cells' (CTRL+1) to change the format from date to the desired format. I think from 3.6 date input is more strict and depends on locale. You can see what are the patterns for your locale in: Menu/Tools/Options/Language Settins/Language of - Date acceptance patterns. Edit it to add the pattern you want, in this case add ;D/M There is more detailed information in: http://erack.org/blog/archives/8-LibreOffice-date-acceptance-patterns.html Resolved as notabug, if you can't solve the issue in this way, please reopen it. |
Created attachment 97590 [details] A spread sheet with this failure in sheet 2 (Hoja 2) G12 Problem description: I put a division and instead of the result of division I obtain a date Steps to reproduce: 1. In one cell I write: =12/5 2. instead of 2.4 I obtain a result of 01/01/00 3. I tried =(12/5) and I obtain the same "01/01/00" Current behavior: 01/01/01 as a result Expected behavior: obtain 2.4 as a result Operating System: Windows XP Version: 4.1.4.2 release