| Summary: | Text Function returns wrong Day Of Week | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Altamiro <ADinizML> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | major | CC: | miguelangelrv |
| Priority: | medium | ||
| Version: | 4.0.1.1 rc | ||
| Hardware: | x86 (IA32) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | The affected cell and the next cells | ||
Enter your zip code here Hi ADinizML, sorry but the mistake is to use the function DAY(). The formula must be: =TEXT(E264,"ddd") which works fine for me. I think it is not a bug. If you are not agree please reopen. |
Created attachment 75656 [details] The affected cell and the next cells The Cell E264 has the value '01/14/2013' (Mon, 14/Jan/2013). The formula "=TEXT(DAY(E264),"ddd")" returns "Sat" instead of "Mon"