Error in XLDateTime

[dobiega]

Hi
For serial number 43791.583333333299 returned date (at least hour) is not correct
returned hour is 13:59:60 but shall be 14:00:00

[jason-fan]

/**
 * @details Get the time point as a std::tm object.
 */
std::tm XLDateTime::tm() const
// ...

    // ===== Calculate the number of days.
    result.tm_mday = static_cast<int>(serial);
    serial -= result.tm_mday;
    // fix calculation accuracy <--
    auto tm_sec = static_cast<int>(lround(serial * 24 * 60 * 60));
    serial = tm_sec / (24.0 * 60.0 * 60.0);

    // ===== Calculate the number of hours.
    result.tm_hour = static_cast<int>(serial * 24);
    serial -= (result.tm_hour / 24.0);

// ...

[aral-matrix]

Hi @dobiega - My apologies for the late response, I am going through the backlog of issues and just fixed this in the development-aral branch, feel free to have a look at patch 4760629.
I will close the issue when merging the patch into master.

[aral-matrix]

merged the patch into master today