Date column showing “FALSE” on Excel Export

  • Resolved stevoli

    (@stevoli)


    7 years ago

    Exporting orders as XLS and all dates show FALSE, switched it to CSV and dates are exporting correctly. Did something change in the last update?

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter stevoli

    (@stevoli)

    Screen shot: https://i.imgur.com/MtHmR7r.jpg

    Plugin Author algol.plus

    (@algolplus)

    hi

    Yes, I added Excel dates in last update ( Excel showed dates as strings).

    Could you attach the screenshot of settings ( section “Format” only)?

    thanks, Alex

    Thread Starter stevoli

    (@stevoli)

    Yes, here is the format section: https://i.imgur.com/WDA8qSJ.jpg

    Dates show correct in the preview, and in CSV, but always show “FALSE” in the Excel export.

    Plugin Author algol.plus

    (@algolplus)

    Could you submit ticket and attach 2 samples files ( csv and excel) ?

    Thread Starter stevoli

    (@stevoli)

    Submitted

    Plugin Author algol.plus

    (@algolplus)

    If you have same problem , please edit file
    classes/formats/class-woe-formatter-xls.php

    and replace
    $text = PHPExcel_Shared_Date::PHPToExcel($text);
    with
    $text = PHPExcel_Shared_Date::PHPToExcel( new DateTime($text) );

    The fix will be included in next version.

    Thread Starter stevoli

    (@stevoli)

    Thanks for the help, problem solved

    Plugin Author algol.plus

    (@algolplus)

    The bug was fixed in version 1.5.3.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Date column showing “FALSE” on Excel Export’ is closed to new replies.