use std::fmt;
use crate::exceptions::{Error, Result};
use crate::styles::alignment::Alignment;
use crate::styles::borders::Borders;
use crate::styles::fills::Fill;
use crate::styles::fonts::Font;
use crate::styles::numbers::NumberFormat;
use crate::styles::protection::Protection;
use crate::styles::style::Style;
pub const BUILTIN_STYLES: [(&str, &str); 49] = [
("0", "Normal"),
("3", "Comma"),
("6", "Comma [0]"),
("4", "Currency"),
("7", "Currency [0]"),
("5", "Percent"),
("8", "Hyperlink"),
("9", "Followed Hyperlink"),
("15", "Title"),
("16", "Headline 1"),
("17", "Headline 2"),
("18", "Headline 3"),
("19", "Headline 4"),
("26", "Good"),
("27", "Bad"),
("28", "Neutral"),
("20", "Input"),
("21", "Output"),
("22", "Calculation"),
("24", "Linked Cell"),
("23", "Check Cell"),
("11", "Warning Text"),
("10", "Note"),
("53", "Explanatory Text"),
("25", "Total"),
("29", "Accent1"),
("30", "20 % - Accent1"),
("31", "40 % - Accent1"),
("32", "60 % - Accent1"),
("33", "Accent2"),
("34", "20 % - Accent2"),
("35", "40 % - Accent2"),
("36", "60 % - Accent2"),
("37", "Accent3"),
("38", "20 % - Accent3"),
("39", "40 % - Accent3"),
("40", "60 % - Accent3"),
("41", "Accent4"),
("42", "20 % - Accent4"),
("43", "40 % - Accent4"),
("44", "60 % - Accent4"),
("45", "Accent5"),
("46", "20 % - Accent5"),
("47", "40 % - Accent5"),
("48", "60 % - Accent5"),
("49", "Accent6"),
("50", "20 % - Accent6"),
("51", "40 % - Accent6"),
("52", "60 % - Accent6"),
];
#[derive(Debug, Clone, Copy, PartialEq)]
pub struct BuiltinStyle {
pub builtin_id: &'static str,
pub name: &'static str,
pub fill_color: Option<&'static str>,
pub font_color: Option<&'static str>,
pub size: f64,
pub bold: bool,
pub italic: bool,
pub scheme: Option<&'static str>,
pub font_name: Option<&'static str>,
pub number_format: Option<&'static str>,
}
pub const BUILTIN_DETAILS: [BuiltinStyle; 49] = [
BuiltinStyle {
builtin_id: "0",
name: "Normal",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "3",
name: "Comma",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: Some("_-* #,##0.00\\ _$_-;\\-* #,##0.00\\ _$_-;_-* \"-\"??\\ _$_-;_-@_-"),
},
BuiltinStyle {
builtin_id: "6",
name: "Comma [0]",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: Some("_-* #,##0\\ _$_-;\\-* #,##0\\ _$_-;_-* \"-\"\\ _$_-;_-@_-"),
},
BuiltinStyle {
builtin_id: "4",
name: "Currency",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: Some(
"_-* #,##0.00\\ \"$\"_-;\\-* #,##0.00\\ \"$\"_-;_-* \"-\"??\\ \"$\"_-;_-@_-",
),
},
BuiltinStyle {
builtin_id: "7",
name: "Currency [0]",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: Some("_-* #,##0\\ \"$\"_-;\\-* #,##0\\ \"$\"_-;_-* \"-\"\\ \"$\"_-;_-@_-"),
},
BuiltinStyle {
builtin_id: "5",
name: "Percent",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: Some("0%"),
},
BuiltinStyle {
builtin_id: "8",
name: "Hyperlink",
fill_color: None,
font_color: Some("theme:10"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "9",
name: "Followed Hyperlink",
fill_color: None,
font_color: Some("theme:11"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "15",
name: "Title",
fill_color: None,
font_color: Some("theme:3"),
size: 18.0,
bold: true,
italic: false,
scheme: Some("major"),
font_name: Some("Cambria"),
number_format: None,
},
BuiltinStyle {
builtin_id: "16",
name: "Headline 1",
fill_color: None,
font_color: Some("theme:3"),
size: 15.0,
bold: true,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "17",
name: "Headline 2",
fill_color: None,
font_color: Some("theme:3"),
size: 13.0,
bold: true,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "18",
name: "Headline 3",
fill_color: None,
font_color: Some("theme:3"),
size: 11.0,
bold: true,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "19",
name: "Headline 4",
fill_color: None,
font_color: Some("theme:3"),
size: 11.0,
bold: true,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "26",
name: "Good",
fill_color: Some("FFC6EFCE"),
font_color: Some("FF006100"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "27",
name: "Bad",
fill_color: Some("FFFFC7CE"),
font_color: Some("FF9C0006"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "28",
name: "Neutral",
fill_color: Some("FFFFEB9C"),
font_color: Some("FF9C6500"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "20",
name: "Input",
fill_color: Some("FFFFCC99"),
font_color: Some("FF3F3F76"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "21",
name: "Output",
fill_color: Some("FFF2F2F2"),
font_color: Some("FF3F3F3F"),
size: 12.0,
bold: true,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "22",
name: "Calculation",
fill_color: Some("FFF2F2F2"),
font_color: Some("FFFA7D00"),
size: 12.0,
bold: true,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "24",
name: "Linked Cell",
fill_color: None,
font_color: Some("FFFA7D00"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "23",
name: "Check Cell",
fill_color: Some("FFA5A5A5"),
font_color: Some("theme:0"),
size: 12.0,
bold: true,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "11",
name: "Warning Text",
fill_color: None,
font_color: Some("FFFF0000"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "10",
name: "Note",
fill_color: Some("FFFFFFCC"),
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "53",
name: "Explanatory Text",
fill_color: None,
font_color: Some("FF7F7F7F"),
size: 12.0,
bold: false,
italic: true,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "25",
name: "Total",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: true,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "29",
name: "Accent1",
fill_color: None,
font_color: Some("theme:0"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "30",
name: "20 % - Accent1",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "31",
name: "40 % - Accent1",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "32",
name: "60 % - Accent1",
fill_color: None,
font_color: Some("theme:0"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "33",
name: "Accent2",
fill_color: None,
font_color: Some("theme:0"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "34",
name: "20 % - Accent2",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "35",
name: "40 % - Accent2",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "36",
name: "60 % - Accent2",
fill_color: None,
font_color: Some("theme:0"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "37",
name: "Accent3",
fill_color: None,
font_color: Some("theme:0"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "38",
name: "20 % - Accent3",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "39",
name: "40 % - Accent3",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "40",
name: "60 % - Accent3",
fill_color: None,
font_color: Some("theme:0"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "41",
name: "Accent4",
fill_color: None,
font_color: Some("theme:0"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "42",
name: "20 % - Accent4",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "43",
name: "40 % - Accent4",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "44",
name: "60 % - Accent4",
fill_color: None,
font_color: Some("theme:0"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "45",
name: "Accent5",
fill_color: None,
font_color: Some("theme:0"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "46",
name: "20 % - Accent5",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "47",
name: "40 % - Accent5",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "48",
name: "60 % - Accent5",
fill_color: None,
font_color: Some("theme:0"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "49",
name: "Accent6",
fill_color: None,
font_color: Some("theme:0"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "50",
name: "20 % - Accent6",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "51",
name: "40 % - Accent6",
fill_color: None,
font_color: Some("theme:1"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
BuiltinStyle {
builtin_id: "52",
name: "60 % - Accent6",
fill_color: None,
font_color: Some("theme:0"),
size: 12.0,
bold: false,
italic: false,
scheme: Some("minor"),
font_name: Some("Calibri"),
number_format: None,
},
];
pub fn builtin_style(name: &str) -> Option<&'static str> {
builtin(name).map(|style| style.builtin_id)
}
pub fn builtin(name: &str) -> Option<&'static BuiltinStyle> {
let wanted = name.trim().to_lowercase();
BUILTIN_DETAILS
.iter()
.find(|style| style.name.to_lowercase() == wanted)
}
pub fn builtin_styles() -> &'static [BuiltinStyle] {
&BUILTIN_DETAILS
}
pub fn builtin_name(id: &str) -> Option<&'static str> {
BUILTIN_DETAILS
.iter()
.find(|style| style.builtin_id == id)
.map(|style| style.name)
}
#[derive(Debug, Clone, PartialEq)]
pub struct NamedStyle {
pub name: String,
pub font: Font,
pub fill: Fill,
pub border: Borders,
pub alignment: Alignment,
pub number_format: NumberFormat,
pub protection: Protection,
pub builtin_id: Option<String>,
pub hidden: Option<bool>,
}
impl Default for NamedStyle {
fn default() -> Self {
NamedStyle {
name: String::new(),
font: Font::new(),
fill: Fill::new(),
border: Borders::default(),
alignment: Alignment::new(),
number_format: NumberFormat::default(),
protection: Protection::default(),
builtin_id: None,
hidden: None,
}
}
}
impl NamedStyle {
pub fn new(name: &str) -> Self {
NamedStyle {
name: name.to_string(),
..NamedStyle::default()
}
}
pub fn builtin(name: &str) -> Option<Self> {
let record = builtin(name)?;
let mut font = Font::new();
if let Some(font_name) = record.font_name {
font.name = font_name.to_string();
}
font.size = record.size;
font.bold = record.bold;
font.italic = record.italic;
if let Some(colour) = record.font_color {
font.color = crate::styles::colors::Color::new(colour);
}
if let Some(scheme) = record.scheme {
font.scheme = scheme.to_string();
}
let mut fill = Fill::new();
if let Some(colour) = record.fill_color {
fill.fill_type = Some(Fill::FILL_SOLID.to_string());
fill.start_color = crate::styles::colors::Color::new(colour);
}
let mut number_format = NumberFormat::default();
if let Some(code) = record.number_format {
number_format.set_format_code(code);
}
Some(NamedStyle {
name: record.name.to_string(),
font,
fill,
number_format,
builtin_id: Some(record.builtin_id.to_string()),
..NamedStyle::default()
})
}
pub fn from_style(name: &str, style: &Style) -> Self {
NamedStyle {
name: name.to_string(),
font: style.font.clone(),
fill: style.fill.clone(),
border: style.borders.clone(),
alignment: style.alignment.clone(),
number_format: style.number_format.clone(),
protection: style.protection,
builtin_id: None,
hidden: None,
}
}
pub fn to_style(&self) -> Style {
Style {
font: self.font.clone(),
fill: self.fill.clone(),
borders: self.border.clone(),
alignment: self.alignment.clone(),
number_format: self.number_format.clone(),
protection: self.protection,
..Style::default()
}
}
pub fn number_format_code(&self) -> &str {
self.number_format.format_code()
}
pub fn with_font(mut self, font: Font) -> Self {
self.font = font;
self
}
pub fn with_fill(mut self, fill: Fill) -> Self {
self.fill = fill;
self
}
pub fn with_border(mut self, border: Borders) -> Self {
self.border = border;
self
}
pub fn with_alignment(mut self, alignment: Alignment) -> Self {
self.alignment = alignment;
self
}
pub fn with_number_format(mut self, code: &str) -> Self {
self.number_format.set_format_code(code);
self
}
pub fn hidden(mut self, hidden: bool) -> Self {
self.hidden = Some(hidden);
self
}
}
impl fmt::Display for NamedStyle {
fn fmt(&self, f: &mut fmt::Formatter<'_>) -> fmt::Result {
f.write_str(&self.name)
}
}
#[derive(Debug, Clone, Default, PartialEq)]
pub struct NamedStyleList {
styles: Vec<NamedStyle>,
}
impl NamedStyleList {
pub fn new() -> Self {
NamedStyleList::default()
}
pub fn add(&mut self, style: NamedStyle) -> Result<()> {
if style.name.trim().is_empty() {
return Err(Error::Value("a named style needs a name".to_string()));
}
match self.index_of(&style.name) {
Some(at) => self.styles[at] = style,
None => {
if style.name == NORMAL {
self.styles.insert(0, style);
} else {
self.styles.push(style);
}
}
}
Ok(())
}
pub fn get(&self, name: &str) -> Option<&NamedStyle> {
self.index_of(name).map(|at| &self.styles[at])
}
pub fn get_mut(&mut self, name: &str) -> Option<&mut NamedStyle> {
let at = self.index_of(name)?;
Some(&mut self.styles[at])
}
pub fn remove(&mut self, name: &str) -> Option<NamedStyle> {
if name == NORMAL {
return None;
}
let at = self.index_of(name)?;
Some(self.styles.remove(at))
}
pub fn len(&self) -> usize {
self.styles.len()
}
pub fn is_empty(&self) -> bool {
self.styles.is_empty()
}
pub fn names(&self) -> Vec<&str> {
self.styles.iter().map(|s| s.name.as_str()).collect()
}
pub fn iter(&self) -> impl Iterator<Item = &NamedStyle> {
self.styles.iter()
}
pub fn index_of(&self, name: &str) -> Option<usize> {
self.styles.iter().position(|style| style.name == name)
}
pub fn by_index(&self, index: usize) -> Option<&NamedStyle> {
self.styles.get(index)
}
pub fn is_known(name: &str) -> bool {
builtin_style(name).is_some()
}
}
pub const NORMAL: &str = "Normal";
impl fmt::Display for NamedStyleList {
fn fmt(&self, f: &mut fmt::Formatter<'_>) -> fmt::Result {
f.write_str(&self.names().join(", "))
}
}
pub fn unknown_style(name: &str, available: &[&str]) -> Error {
let hint = if available.is_empty() {
"the workbook defines no named styles".to_string()
} else {
format!("known: {}", available.join(", "))
};
Error::Key(format!("{name} is not a named style; {hint}"))
}
#[cfg(test)]
mod tests {
use super::*;
#[test]
fn the_built_in_table_matches_openpyxl() {
assert_eq!(BUILTIN_STYLES.len(), 49);
assert_eq!(BUILTIN_STYLES[0], ("0", "Normal"));
assert_eq!(builtin_style("Good"), Some("26"));
assert_eq!(builtin_style("Bad"), Some("27"));
assert_eq!(builtin_style("Title"), Some("15"));
assert_eq!(builtin_name("26"), Some("Good"));
}
#[test]
fn built_in_lookup_ignores_case_and_padding() {
assert_eq!(builtin_style("good"), Some("26"));
assert_eq!(builtin_style(" Good "), Some("26"));
assert_eq!(builtin_style("not a style"), None);
}
#[test]
fn a_built_in_style_carries_its_formatting_as_well_as_its_id() {
let good = NamedStyle::builtin("Good").expect("Good is built in");
assert_eq!(good.builtin_id.as_deref(), Some("26"));
assert_eq!(good.name, "Good");
assert_eq!(good.fill.start_color.index, "FFC6EFCE");
assert_eq!(good.font.color.index, "FF006100");
assert_eq!(good.font.scheme, "minor");
let normal = NamedStyle::builtin("Normal").expect("Normal is built in");
assert!(normal.fill.start_color == Fill::new().start_color);
assert!(NamedStyle::builtin("Nonsense").is_none());
}
#[test]
fn the_generated_table_agrees_with_the_49_the_tool_counts() {
assert_eq!(BUILTIN_DETAILS.len(), 49);
assert_eq!(BUILTIN_DETAILS[0].name, "Normal");
assert_eq!(BUILTIN_DETAILS[0].builtin_id, "0");
let title = builtin("Title").expect("Title is built in");
assert_eq!(title.font_name, Some("Cambria"));
assert!(title.bold);
let accent = builtin("Accent1").expect("Accent1 is built in");
assert!(accent.fill_color.is_none());
assert_eq!(accent.font_color, Some("theme:0"));
}
#[test]
fn a_number_format_survives_the_two_levels_of_unescaping() {
let comma = builtin("Comma").expect("Comma is built in");
let code = comma.number_format.expect("Comma carries a format");
assert!(
code.contains(r"\ "),
"single backslash before the space: {code}"
);
assert!(!code.contains("\\\\"), "no doubled backslashes: {code}");
}
#[test]
fn a_named_style_round_trips_through_a_cell_style() {
let style = NamedStyle::new("Band")
.with_number_format("0.00%")
.with_font(Font::new().with_bold(true));
let as_style = style.to_style();
assert_eq!(as_style.number_format_code(), "0.00%");
assert!(as_style.font.bold);
assert_eq!(
NamedStyle::from_style("Band", &as_style).number_format_code(),
"0.00%"
);
}
#[test]
fn the_list_replaces_rather_than_refuses() {
let mut list = NamedStyleList::new();
list.add(NamedStyle::new("Total")).expect("added");
list.add(NamedStyle::new("Total").with_number_format("0.00"))
.expect("replaced");
assert_eq!(list.len(), 1);
assert_eq!(
list.get("Total")
.expect("Total")
.number_format
.format_code(),
"0.00"
);
}
#[test]
fn the_index_is_the_xf_id_a_cell_writes() {
let mut list = NamedStyleList::new();
list.add(NamedStyle::new("Normal")).expect("added");
list.add(NamedStyle::new("Good")).expect("added");
assert_eq!(list.index_of("Normal"), Some(0));
assert_eq!(list.index_of("Good"), Some(1));
assert_eq!(list.index_of("Missing"), None);
}
#[test]
fn normal_stays_first_however_late_it_arrives() {
let mut list = NamedStyleList::new();
list.add(NamedStyle::new("Good")).expect("added");
list.add(NamedStyle::new("Accent1")).expect("added");
list.add(NamedStyle::new("Normal")).expect("added");
assert_eq!(list.index_of("Normal"), Some(0));
assert_eq!(list.names(), ["Normal", "Good", "Accent1"]);
}
#[test]
fn normal_cannot_be_removed() {
let mut list = NamedStyleList::new();
list.add(NamedStyle::new("Normal")).expect("added");
list.add(NamedStyle::new("Good")).expect("added");
assert!(list.remove("Normal").is_none());
assert!(list.remove("Good").is_some());
assert_eq!(list.len(), 1);
}
#[test]
fn a_style_needs_a_name() {
let mut list = NamedStyleList::new();
assert!(list.add(NamedStyle::new(" ")).is_err());
}
#[test]
fn an_unknown_style_says_what_is_known() {
let err = unknown_style("Nonsense", &["Normal", "Good"]);
let message = err.to_string();
assert!(message.contains("Normal"), "{message}");
assert!(message.contains("Good"), "{message}");
}
#[cfg(test)]
mod round_trip_tests {
use super::*;
use crate::cell::cell::CellValue;
use crate::workbook::Workbook;
#[test]
fn a_named_style_survives_a_package_round_trip() {
let mut workbook = Workbook::new();
let mut list = NamedStyleList::new();
list.add(NamedStyle::new("Normal")).expect("normal");
list.add(
NamedStyle::new("Band")
.with_number_format("0.00%")
.with_font(Font::new().with_bold(true)),
)
.expect("band");
workbook.named_styles = list;
let bytes = workbook.to_bytes().expect("saved");
let loaded = crate::reader::excel::load_workbook_from_bytes(bytes, Default::default())
.expect("loaded");
assert_eq!(loaded.named_styles.len(), 2);
let band = loaded.named_styles.get("Band").expect("Band survived");
assert_eq!(band.number_format_code(), "0.00%");
assert!(band.font.bold);
assert_eq!(loaded.named_styles.index_of("Normal"), Some(0));
assert_eq!(loaded.named_styles.index_of("Band"), Some(1));
}
#[test]
fn a_built_in_style_can_be_applied_and_reads_back() {
let mut workbook = Workbook::new();
let sheet = workbook.active_sheet_mut().expect("sheet");
sheet.set("A1", CellValue::number(1.0)).expect("cell");
sheet
.apply_named_style("A1", "Good")
.expect("Good is built in");
let bytes = workbook.to_bytes().expect("saved");
let loaded = crate::reader::excel::load_workbook_from_bytes(bytes, Default::default())
.expect("loaded");
assert!(loaded.worksheets[0].get_style("A1").fill != Fill::new());
}
#[test]
fn an_unknown_name_is_refused_rather_than_defaulted() {
let mut workbook = Workbook::new();
let sheet = workbook.active_sheet_mut().expect("sheet");
sheet.set("A1", CellValue::number(1.0)).expect("cell");
assert!(sheet.apply_named_style("A1", "Nonsense").is_err());
assert_eq!(sheet.get_style("A1"), Style::default());
}
}
}