#![allow(
clippy::unwrap_used,
clippy::expect_used,
clippy::panic,
clippy::field_reassign_with_default
)]
use excelerate::CellRef;
use excelerate::model::{CellValue, Spreadsheet};
use excelerate::reader::html::read_html_str;
use excelerate::style::{NumberFormat, Style};
use excelerate::writer::html::{HtmlOptions, write_html_to};
fn at(address: &str) -> CellRef {
CellRef::parse(address).unwrap()
}
#[test]
fn a_page_we_wrote_reads_back_the_same_values() {
let mut book = Spreadsheet::new();
let money = book.styles.intern(Style {
number_format: NumberFormat::Custom("#,##0.00".to_owned()),
..Default::default()
});
let sheet = book.sheet_mut(0).unwrap();
sheet.set(at("A1"), CellValue::Number(1234.5));
sheet.entry(at("A1")).style = money;
sheet.set(at("B1"), CellValue::Bool(true));
sheet.set(at("C1"), CellValue::text("007"));
sheet.set(at("D1"), CellValue::text("two\nlines"));
sheet.set(
at("E1"),
CellValue::Formula {
formula: "A1*2".to_owned(),
cached: Some(Box::new(CellValue::Number(2469.0))),
},
);
let mut page = Vec::new();
write_html_to(&book, &mut page, &HtmlOptions::default()).unwrap();
let back = read_html_str(&String::from_utf8(page).unwrap());
let sheet = back.sheet(0).unwrap();
let value = |a: &str| sheet.get(at(a)).unwrap().value.clone();
assert_eq!(value("A1"), CellValue::Number(1234.5));
assert_eq!(value("B1"), CellValue::Bool(true));
assert_eq!(value("C1"), CellValue::text("007"));
assert_eq!(value("D1"), CellValue::text("two\nlines"));
assert_eq!(
value("E1"),
book.sheet(0).unwrap().get(at("E1")).unwrap().value
);
let style = back.styles.get(sheet.get(at("A1")).unwrap().style).unwrap();
assert_eq!(style.number_format.code(), "#,##0.00");
}
#[test]
fn a_merge_keeps_its_format_wrap_border_and_spaces() {
use excelerate::Range;
use excelerate::style::{Border, BorderStyle};
let thin = || Border {
style: BorderStyle::parse("thin"),
..Default::default()
};
let mut book = Spreadsheet::new();
let top = book.styles.intern({
let mut s = Style::default();
s.number_format = NumberFormat::Custom("#,##0.00".to_owned());
s.alignment.wrap_text = true;
s.borders.top = thin();
s
});
let bottom = book.styles.intern({
let mut s = Style::default();
s.borders.bottom = thin();
s
});
let sheet = book.sheet_mut(0).unwrap();
sheet.set(at("A1"), CellValue::Number(5.0));
sheet.entry(at("A1")).style = top;
sheet.entry(at("A2")).style = bottom;
sheet.merges.push(Range::parse("A1:A2").unwrap());
sheet.set(at("B1"), CellValue::text("two spaces "));
let mut page = Vec::new();
write_html_to(&book, &mut page, &HtmlOptions::default()).unwrap();
let back = read_html_str(&String::from_utf8(page).unwrap());
let sheet = back.sheet(0).unwrap();
let style = |a: &str| {
back.styles
.get(sheet.get(at(a)).unwrap().style)
.unwrap()
.clone()
};
for a in ["A1", "A2"] {
assert_eq!(style(a).number_format.code(), "#,##0.00", "{a}");
assert!(style(a).alignment.wrap_text, "{a}");
}
assert_eq!(style("A1").borders.bottom.style, thin().style);
assert_eq!(style("A1").borders.top.style, thin().style);
assert_eq!(
sheet.get(at("B1")).unwrap().value,
CellValue::text("two spaces ")
);
}