| Summary: | EDITING: Error in date time interpretation | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | jmlapointe |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | barta, jmadero.dev |
| Priority: | medium | ||
| Version: | 4.1.2.3 release | ||
| Hardware: | Other | ||
| OS: | Linux (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
I suggest to upgrade to current stable release which is 4.1.4.2 I get the same results using 3.6alpha and Version: 4.2.3.3. Marking as WORKSFORME. Ubuntu 14.04 LibreOffice 3.6alpha and 4.2.3.3 If you still see the problem in 4.2.3.3 please provide a test document that shows a different result in 4.0 vs. 4.1+ so that I can test it out. Also if you still see the problem please mark the bug as UNCONFIRMED so that QA makes sure to look at it again. Thanks for reporting! |
Problem description: Hi, in a spreadsheet, I convert unix timestamp using this formula: =<unix_timestamp>/86400+DATE(1970;1;1). It worked up until now. But this morning, for some reason, it does not take into account my time zone offset. So for "1386588960" it outputs "dec. 9 2013, 11:36" instead of "dec. 9 2013, 06:36". For other time stamps like "1379598660", it outputs the write time. Is this a bug or am I just making a mistake ? Thanx ! Operating System: Ubuntu Version: 4.1.2.3 release