umya-spreadsheet 2.3.3

umya-spreadsheet is a library written in pure Rust to read and write xlsx file.
Documentation
use crate::xml_read_loop;
use crate::StringValue;

use super::vml::office::InsetMarginValues;
use super::vml::spreadsheet::Anchor;
use super::vml::spreadsheet::CommentColumnTarget;
use super::vml::spreadsheet::CommentRowTarget;
use super::vml::spreadsheet::MoveWithCells;
use super::vml::spreadsheet::ResizeWithCells;
use super::vml::Fill as VmlFill;
use super::vml::Path;
use super::vml::Shadow;
use super::vml::TextBox;
use super::CommentText;
use super::Coordinate;
use super::Fill;
use crate::helper::coordinate::*;
use crate::reader::driver::*;
use crate::structs::vml::Shape;
use crate::traits::AdjustmentCoordinate;
use crate::writer::driver::*;
use quick_xml::events::{BytesStart, Event};
use quick_xml::Reader;
use quick_xml::Writer;
use std::io::Cursor;

#[derive(Clone, Default, Debug)]
pub struct Comment {
    coordinate: Coordinate,
    author: Box<str>,
    text: CommentText,
    shape: Shape,
    id: StringValue,
}

impl Comment {
    #[inline]
    pub fn get_coordinate(&self) -> &Coordinate {
        &self.coordinate
    }

    #[inline]
    pub fn get_coordinate_mut(&mut self) -> &mut Coordinate {
        &mut self.coordinate
    }

    #[inline]
    pub fn get_author(&self) -> &str {
        &self.author
    }

    #[inline]
    pub fn set_author<S: Into<String>>(&mut self, value: S) -> &mut Self {
        self.author = value.into().into_boxed_str();
        self
    }

    #[inline]
    pub fn get_text(&self) -> &CommentText {
        &self.text
    }

    #[inline]
    pub fn get_text_mut(&mut self) -> &mut CommentText {
        &mut self.text
    }

    #[inline]
    pub fn set_text(&mut self, value: CommentText) -> &mut Self {
        self.text = value;
        self
    }

    #[inline]
    pub fn set_text_string<S: Into<String>>(&mut self, value: S) -> &mut Self {
        self.text.set_text_string(value);
        self
    }

    #[inline]
    pub fn get_anchor(&self) -> &Anchor {
        self.shape.get_client_data().get_anchor()
    }

    #[inline]
    pub fn get_anchor_mut(&mut self) -> &mut Anchor {
        self.shape.get_client_data_mut().get_anchor_mut()
    }

    #[inline]
    pub fn set_anchor(&mut self, value: Anchor) -> &mut Self {
        self.shape.get_client_data_mut().set_anchor(value);
        self
    }

    #[inline]
    pub fn get_shape(&self) -> &Shape {
        &self.shape
    }

    #[inline]
    pub fn get_shape_mut(&mut self) -> &mut Shape {
        &mut self.shape
    }

    #[inline]
    pub fn set_shape(&mut self, value: Shape) -> &mut Self {
        self.shape = value;
        self
    }

    #[inline]
    pub fn get_id(&self) -> &str {
        &self.id.get_value_str()
    }

    #[inline]
    pub(crate) fn set_id<S: Into<String>>(&mut self, value: S) -> &mut Self {
        self.id.set_value(value);
        self
    }

    #[inline]
    pub fn new_comment<T>(&mut self, coordinate: T) -> &mut Self
    where
        T: Into<CellCoordinates>,
    {
        let CellCoordinates { col, row } = coordinate.into();
        self.get_coordinate_mut().set_col_num(col).set_row_num(row);

        self.get_shape_mut()
            .set_type("#_x0000_t202")
            .set_style("position:absolute;margin-left:275.25pt;margin-top:61.5pt;width:207.75pt;height:145.5pt;z-index:1;visibility:hidden;mso-wrap-style:tight")
            .set_fill_color("infoBackground [80]")
            .set_inset_mode(InsetMarginValues::Auto);

        let mut fill = VmlFill::default();
        fill.set_color_2("infoBackground [80]");
        self.get_shape_mut().set_fill(fill);

        let mut shadow = Shadow::default();
        shadow.set_color("none [81]").set_obscured(true);
        self.get_shape_mut().set_shadow(shadow);

        let mut path = Path::default();
        path.set_connection_point_type(super::vml::office::ConnectValues::None);
        self.get_shape_mut().set_path(path);

        let mut textbox = TextBox::default();
        textbox
            .set_style("mso-direction-alt:auto")
            .set_innder("<div style='text-align:left'></div>");
        self.get_shape_mut().set_text_box(textbox);

        let movewithcells = MoveWithCells::default();
        self.get_shape_mut()
            .get_client_data_mut()
            .set_move_with_cells(movewithcells);

        let resizewithcells = ResizeWithCells::default();
        self.get_shape_mut()
            .get_client_data_mut()
            .set_resize_with_cells(resizewithcells);

        self.get_shape_mut()
            .get_client_data_mut()
            .get_anchor_mut()
            .set_left_column(col)
            .set_left_offset(15)
            .set_top_row(if row > 1 { row - 1 } else { 1 })
            .set_top_offset(8)
            .set_right_column(col + 1)
            .set_right_offset(71)
            .set_bottom_row(row + 3)
            .set_bottom_offset(15);

        let mut comment_col = CommentColumnTarget::default();
        comment_col.set_value(col - 1);
        let mut comment_row = CommentRowTarget::default();
        comment_row.set_value(row - 1);
        self.get_shape_mut()
            .get_client_data_mut()
            .set_comment_column_target(comment_col)
            .set_comment_row_target(comment_row);

        self
    }

    #[inline]
    pub(crate) fn set_attributes<R: std::io::BufRead>(
        &mut self,
        reader: &mut Reader<R>,
        e: &BytesStart,
        authors: &[String],
    ) {
        let coordinate = get_attribute(e, b"ref").unwrap();
        self.get_coordinate_mut().set_coordinate(coordinate);

        let author_id = get_attribute(e, b"authorId")
            .unwrap()
            .parse::<usize>()
            .unwrap();
        let author = authors.get(author_id).unwrap();
        self.set_author(author);

        set_string_from_xml!(self, e, id, "id");

        xml_read_loop!(
            reader,
            Event::Start(ref e) => {
                if e.name().into_inner() == b"text" {
                    self.get_text_mut().set_attributes(reader, e);
                }
            },
            Event::End(ref e) => {
                if e.name().into_inner() == b"comment" {
                    return
                }
            },
            Event::Eof => panic!("Error: Could not find {} end element", "comment")
        );
    }

    pub(crate) fn write_to(&self, writer: &mut Writer<Cursor<Vec<u8>>>, authors: &[String]) {
        // comment
        let mut attributes: Vec<(&str, &str)> = Vec::new();
        let coordinate = self.coordinate.to_string();
        attributes.push(("ref", &coordinate));
        let author_id = authors
            .iter()
            .position(|value| self.get_author() == value)
            .map_or(String::new(), |i| i.to_string());
        attributes.push(("authorId", &author_id));
        if self.id.has_value() {
            attributes.push(("id", self.id.get_value_str()));
        }
        write_start_tag(writer, "comment", attributes, false);

        // text
        self.get_text().write_to(writer);

        write_end_tag(writer, "comment");
    }
}
impl AdjustmentCoordinate for Comment {
    #[inline]
    fn adjustment_insert_coordinate(
        &mut self,
        root_col_num: &u32,
        offset_col_num: &u32,
        root_row_num: &u32,
        offset_row_num: &u32,
    ) {
        self.coordinate.adjustment_insert_coordinate(
            root_col_num,
            offset_col_num,
            root_row_num,
            offset_row_num,
        );
        self.shape.adjustment_insert_coordinate(
            root_col_num,
            offset_col_num,
            root_row_num,
            offset_row_num,
        );
    }

    #[inline]
    fn adjustment_remove_coordinate(
        &mut self,
        root_col_num: &u32,
        offset_col_num: &u32,
        root_row_num: &u32,
        offset_row_num: &u32,
    ) {
        self.coordinate.adjustment_remove_coordinate(
            root_col_num,
            offset_col_num,
            root_row_num,
            offset_row_num,
        );
        self.shape.adjustment_remove_coordinate(
            root_col_num,
            offset_col_num,
            root_row_num,
            offset_row_num,
        );
    }

    #[inline]
    fn is_remove_coordinate(
        &self,
        root_col_num: &u32,
        offset_col_num: &u32,
        root_row_num: &u32,
        offset_row_num: &u32,
    ) -> bool {
        self.coordinate.is_remove_coordinate(
            root_col_num,
            offset_col_num,
            root_row_num,
            offset_row_num,
        )
    }
}