use crate::error::ExcelError;
use alloc::string::String;
pub const UNIX_EPOCH_SERIAL: i64 = 25_569;
const PHANTOM_LEAP_SERIAL: i64 = 60;
const MARCH_1_1900_SERIAL: i64 = 61;
#[must_use]
pub const fn days_from_civil(y: i64, m: i64, d: i64) -> i64 {
let y = if m <= 2 { y - 1 } else { y };
let era = if y >= 0 { y } else { y - 399 } / 400;
let yoe = y - era * 400; let mp = (m + 9) % 12; let doy = (153 * mp + 2) / 5 + d - 1; let doe = yoe * 365 + yoe / 4 - yoe / 100 + doy; era * 146_097 + doe - 719_468
}
#[must_use]
pub const fn civil_from_days(z: i64) -> (i64, i64, i64) {
let z = z + 719_468;
let era = if z >= 0 { z } else { z - 146_096 } / 146_097;
let doe = z - era * 146_097; let yoe = (doe - doe / 1460 + doe / 36524 - doe / 146_096) / 365; let y = yoe + era * 400;
let doy = doe - (365 * yoe + yoe / 4 - yoe / 100); let mp = (5 * doy + 2) / 153; let d = doy - (153 * mp + 2) / 5 + 1; let m = if mp < 10 { mp + 3 } else { mp - 9 }; (if m <= 2 { y + 1 } else { y }, m, d)
}
pub fn serial_to_ymd(serial: i64) -> Result<(i64, i64, i64), ExcelError> {
if !(1..=2_958_465).contains(&serial) {
return Err(ExcelError::Num);
}
if serial == PHANTOM_LEAP_SERIAL {
return Ok((1900, 2, 29)); }
let unix_days = if serial >= MARCH_1_1900_SERIAL {
serial - UNIX_EPOCH_SERIAL
} else {
serial - UNIX_EPOCH_SERIAL + 1
};
Ok(civil_from_days(unix_days))
}
#[must_use]
pub fn ymd_to_serial(y: i64, m: i64, d: i64) -> i64 {
if (y, m, d) == (1900, 2, 29) {
return 60;
}
let unix_days = days_from_civil(y, m, d);
let serial = unix_days + UNIX_EPOCH_SERIAL;
if serial < MARCH_1_1900_SERIAL {
serial - 1
} else {
serial
}
}
#[must_use]
pub fn fraction_to_hms(frac: f64) -> (u32, u32, u32) {
let f = if frac.is_finite() && frac >= 0.0 {
frac % 1.0
} else {
0.0
};
let secs = libm::round(f * 86_400.0) as i64;
let secs = if secs >= 86_400 { 0 } else { secs };
(
(secs / 3600) as u32,
((secs % 3600) / 60) as u32,
(secs % 60) as u32,
)
}
#[must_use]
pub fn weekday_name(serial: i64, long: bool) -> &'static str {
const SHORT: [&str; 7] = ["Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun"];
const LONG: [&str; 7] = [
"Monday",
"Tuesday",
"Wednesday",
"Thursday",
"Friday",
"Saturday",
"Sunday",
];
let idx = (serial - 25_569 + 3).rem_euclid(7) as usize;
let names: [&str; 7] = if long { LONG } else { SHORT };
names.get(idx).copied().unwrap_or("")
}
pub(crate) fn pad2(out: &mut String, n: i64) {
if n < 10 {
out.push('0');
}
append_int(out, n);
}
pub(crate) fn append_int(out: &mut String, n: i64) {
let _ = core::fmt::Write::write_fmt(out, format_args!("{n}"));
}
#[cfg(test)]
mod tests {
#![allow(
clippy::unwrap_used,
clippy::expect_used,
clippy::panic,
clippy::indexing_slicing
)]
use super::*;
#[test]
fn civil_roundtrip() {
for &(y, m, d) in &[
(1900i64, 1i64, 1i64),
(1970, 1, 1),
(2000, 2, 29),
(2026, 10, 4),
(9999, 12, 31),
] {
let days = days_from_civil(y, m, d);
assert_eq!(civil_from_days(days), (y, m, d));
}
}
#[test]
fn serial_anchors() {
assert_eq!(ymd_to_serial(1900, 1, 1), 1);
assert_eq!(ymd_to_serial(1900, 2, 28), 59);
assert_eq!(ymd_to_serial(1900, 3, 1), 61);
assert_eq!(ymd_to_serial(1970, 1, 1), 25_569);
assert_eq!(ymd_to_serial(9999, 12, 31), 2_958_465);
assert_eq!(serial_to_ymd(60).unwrap(), (1900, 2, 29)); assert_eq!(serial_to_ymd(59).unwrap(), (1900, 2, 28));
assert_eq!(serial_to_ymd(1).unwrap(), (1900, 1, 1));
assert_eq!(serial_to_ymd(25_569).unwrap(), (1970, 1, 1));
assert_eq!(serial_to_ymd(0), Err(ExcelError::Num));
assert_eq!(serial_to_ymd(2_958_466), Err(ExcelError::Num));
}
#[test]
fn weekday_anchor() {
assert_eq!(weekday_name(25_569, false), "Thu");
assert_eq!(weekday_name(ymd_to_serial(2026, 10, 4), true), "Sunday");
}
}