Bug ID: 125878
           Summary: Dates imported incorrectly from dbf file
           Product: LibreOffice
           Version: release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc

When I open a dbf file (foxpro), date appears to be incorrect.

For example:
01/06/2019 17:05:03 becomes 02/06/2019 10:05:02 and
02/06/2019 21:27:33 becomes 03/06/2019 18:27:32

You can try replicating the issue using this file (please change the extension
from xls to dbf, this is the only way I could upload this samle file, as dbf
format is not allowed) 

And this file is for comparison reasons only, which has the correct date. This
file is exported using "DBF Viewer Plus" - and I can confirm that date/time is

Steps to Reproduce:
1. Open a dbf file (foxpro)
2. Check the date/time
3. You will notice that they are incorrect

Actual Results:
02/06/2019 10:05:02

Expected Results:
01/06/2019 17:05:03

Reproducible: Always

User Profile Reset: Yes

Additional Info:
Please note that dbf file is a FoxPro file. Sample files can be found on the

I have tried this on Win10 as well as MacOS Mojave - results are identical.

NOTE: I will try to attach original dbf file to this report, but I'm not sure
if it will be allowed. I will try once the bug is filed.

You are receiving this mail because:
You are the assignee for the bug.
Libreoffice-bugs mailing list

Reply via email to