If the current active sheet is empty when this method is called, it

        will be removed from the spreadsheet.

        """

        try:

            empty_sheet = not self.sheet.hasChildNodes()

        except AttributeError:

            empty_sheet = False

        if empty_sheet:

            self.document.spreadsheet.removeChild(self.sheet)

        self.sheet = self.ensure_child(

            self.document.spreadsheet, odf.table.Table, name=name,

        )

        return self.sheet

    ### Initialization hooks

    def init_settings(self) -> None:

        """Hook called to initialize settings

        This method is called by __init__ to populate

        ``self.document.settings``. This implementation creates the barest

        skeleton structure necessary to support other methods, in particular

        ``lock_first_row``.

        """

        view_settings = self.ensure_child(

            self.document.settings, odf.config.ConfigItemSet, name='ooo:view-settings',

        )

        views = self.ensure_child(

            view_settings, odf.config.ConfigItemMapIndexed, name='Views',

        )

        self.view = self.ensure_child(views, odf.config.ConfigItemMapEntry)

        self.set_config(self.view, 'ViewId', 'view1')

    def init_styles(self) -> None:

        """Hook called to initialize settings

        This method is called by __init__ to populate

        ``self.document.styles``. This implementation creates basic building

        block cell styles often used in financial reports.

        """

        styles = self.document.styles

        self.style_bold = self.ensure_child(

            styles, odf.style.Style, name='Bold', family='table-cell',

        )

        self.ensure_child(

            self.style_bold, odf.style.TextProperties, fontweight='bold',

        )

        date_style = self.replace_child(styles, odf.number.DateStyle, name='ISODate')

        date_style.addElement(odf.number.Year(style='long'))

        date_style.addElement(odf.number.Text(text='-'))

        date_style.addElement(odf.number.Month(style='long'))

        date_style.addElement(odf.number.Text(text='-'))

        date_style.addElement(odf.number.Day(style='long'))

        self.style_date = self.ensure_child(

            styles,

            odf.style.Style,

            name=f'{date_style.getAttribute("name")}Cell',

            family='table-cell',

            datastylename=date_style,

        )

        self.style_starttext: odf.style.Style

        self.style_centertext: odf.style.Style

        self.style_endtext: odf.style.Style

        for textalign in ['start', 'center', 'end']:

            aligned_style = self.replace_child(

                styles, odf.style.Style, name=f'{textalign.title()}Text',

            )

            aligned_style.setAttribute('family', 'table-cell')

            aligned_style.addElement(odf.style.ParagraphProperties(textalign=textalign))

            setattr(self, f'style_{textalign}text', aligned_style)

    ### Rows and cells

    def add_row(self, *cells: odf.table.TableCell, **attrs: Any) -> odf.table.TableRow:

        row = odf.table.TableRow(**attrs)

        for cell in cells:

            row.addElement(cell)

        self.sheet.addElement(row)

        return row

    def balance_cell(self, balance: Balance, **attrs: Any) -> odf.table.TableCell:

        balance = balance.clean_copy() or balance

        balance_currency_count = len(balance)

        if balance_currency_count == 0:

            return self.float_cell(0, **attrs)

        elif balance_currency_count == 1:

            amount = next(iter(balance.values()))

            attrs['stylename'] = self.merge_styles(

                attrs.get('stylename'), self.currency_style(amount.currency),

            )

            return self.currency_cell(amount, **attrs)

        else:

            lines = [babel.numbers.format_currency(

    '-1cm',

    'in',

    '.cm',

])

def test_ods_column_style_invalid_width(ods_writer, width):

    with pytest.raises(ValueError):

        ods_writer.column_style(width)

@pytest.mark.parametrize('currency_code', [

    'USD',

    'EUR',

    'BRL',

])

def test_ods_currency_style(ods_writer, currency_code):

    style = ods_writer.currency_style(currency_code)

    assert style.getAttribute('family') == 'table-cell'

    curr_style = get_child(

        ods_writer.document.styles,

        odf.number.CurrencyStyle,

        name=style.getAttribute('datastylename'),

    )

    check_currency_style(curr_style)

    mappings = get_children(curr_style, odf.style.Map)

    assert mappings

    for mapping in mappings:

        check_currency_style(get_child(

            ods_writer.document.styles,

            odf.number.CurrencyStyle,

            name=mapping.getAttribute('applystylename'),

        ))

def test_ods_currency_style_caches(ods_writer):

    expected = ods_writer.currency_style('USD')

    _ = ods_writer.currency_style('EUR')

    actual = ods_writer.currency_style('USD')

    assert actual is expected

def test_ods_currency_style_cache_considers_properties(ods_writer):

    bold_text = odf.style.TextProperties(fontweight='bold')

    plain = ods_writer.currency_style('USD')

    bold = ods_writer.currency_style('USD', positive_properties=bold_text)

    assert plain is not bold

    assert plain.getAttribute('name') != bold.getAttribute('name')

    assert plain.getAttribute('datastylename') != bold.getAttribute('datastylename')

@pytest.mark.parametrize('attr_name,child_type,checked_attr', [

    ('style_bold', odf.style.TextProperties, 'fontweight'),

    ('style_centertext', odf.style.ParagraphProperties, 'textalign'),

    ('style_endtext', odf.style.ParagraphProperties, 'textalign'),

    ('style_starttext', odf.style.ParagraphProperties, 'textalign'),

])

def test_ods_writer_style(ods_writer, attr_name, child_type, checked_attr):

    root = ods_writer.document.styles

    style = getattr(ods_writer, attr_name)

    actual = get_child(root, odf.style.Style, name=style.getAttribute('name'))

    assert actual is style

    child = get_child(actual, child_type)

    assert child.getAttribute(checked_attr)

@pytest.mark.parametrize('edges,width,style,color', [

    (core.Border.TOP,

     '5px', 'solid', '#ff0000'),

    (core.Border.RIGHT | core.Border.LEFT,

     '2pt', 'dashed', '#00ff00'),

    (core.Border.BOTTOM | core.Border.RIGHT | core.Border.LEFT,

     '1em', 'dotted', '#0000ff'),

    (core.Border.TOP | core.Border.BOTTOM | core.Border.RIGHT | core.Border.LEFT,

     '1cm', 'thick', '#aaaaaa'),

])

def test_ods_writer_border_style(ods_writer, edges, width, style, color):

    actual = ods_writer.border_style(edges, width, style, color)

    props, = actual.childNodes

    attr_s = f'{width} {style} {color}'

    for edge_exp, edge_name in enumerate(['top', 'right', 'bottom', 'left']):

        expected = attr_s if edges & (2 ** edge_exp) else None

        assert props.getAttribute(f'border{edge_name}') == expected

def test_ods_writer_border_style_caches(ods_writer):

    expected = ods_writer.border_style(core.Border.TOP)

    width, style, color = expected.childNodes[0].getAttribute('bordertop').split()

    actual = ods_writer.border_style(core.Border.TOP, width, style, color)

    assert actual is expected

@pytest.mark.parametrize('argname,val1,val2', [

    ('edges', core.Border.TOP, core.Border.LEFT),

    ('edges', core.Border.TOP, core.Border.TOP | core.Border.BOTTOM),

    ('style', 'solid', 'dashed'),

    ('width', '1px', '1em'),

    ('width', '1px', '2px'),

    ('color', '#0000fe', '#0000ff'),

])

def test_ods_writer_border_no_caching(ods_writer, argname, val1, val2):

    kwargs = {'edges': core.Border.TOP}

    kwargs[argname] = val1

    style1 = ods_writer.border_style(**kwargs)

    kwargs[argname] = val2

    style2 = ods_writer.border_style(**kwargs)

    assert style1 is not style2

def test_ods_writer_merge_styles(ods_writer):

    actual = get_child(

        ods_writer.document.styles,

        odf.style.Style,

        name=style.getAttribute('name'),

    )

    assert actual is style

    assert actual.getAttribute('family') == 'table-cell'

    text_props = get_child(actual, odf.style.TextProperties)

    assert text_props.getAttribute('fontweight') == 'bold'

    cell_props = get_child(actual, odf.style.TableCellProperties)

    assert cell_props.getAttribute('borderbottom')

def test_ods_writer_merge_styles_with_children_and_attributes(ods_writer):

    jpy_style = ods_writer.currency_style('JPY')

    style = ods_writer.merge_styles(ods_writer.style_bold, jpy_style)

    actual = get_child(

        ods_writer.document.styles,

        odf.style.Style,

        name=style.getAttribute('name'),

    )

    assert actual is style

    assert actual.getAttribute('family') == 'table-cell'

    assert actual.getAttribute('datastylename') == jpy_style.getAttribute('datastylename')

    text_props = get_child(actual, odf.style.TextProperties)

    assert text_props.getAttribute('fontweight') == 'bold'

def test_ods_writer_merge_styles_caches(ods_writer):

    style1 = ods_writer.merge_styles(*sources)

    style2 = ods_writer.merge_styles(*reversed(sources))

    assert style1 is style2

    assert get_child(

        ods_writer.document.styles,

        odf.style.Style,

        name=style1.getAttribute('name'),

    )

def test_ods_writer_layer_merge_styles(ods_writer):

    usd_style = ods_writer.currency_style('USD')

    layer2 = ods_writer.merge_styles(layer1, usd_style)

    style_name = layer2.getAttribute('name')

    assert style_name.count('Merge_') == 1

    actual = get_child(

        ods_writer.document.styles,

        odf.style.Style,

        name=style_name,

    )

    assert actual is layer2

    assert actual.getAttribute('family') == 'table-cell'

    assert actual.getAttribute('datastylename') == usd_style.getAttribute('datastylename')

    text_props = get_child(actual, odf.style.TextProperties)

    assert text_props.getAttribute('fontweight') == 'bold'

    cell_props = get_child(actual, odf.style.TableCellProperties)

    assert cell_props.getAttribute('borderbottom')

def test_ods_writer_merge_one_style(ods_writer):

    actual = ods_writer.merge_styles(None, ods_writer.style_bold)

    assert actual is ods_writer.style_bold

def test_ods_writer_merge_no_styles(ods_writer):

    assert ods_writer.merge_styles() is None

def test_ods_writer_merge_nonexistent_style(ods_writer):

    name = 'Non Existent Style'

    with pytest.raises(ValueError, match=repr(name)):

        ods_writer.merge_styles(ods_writer.style_bold, name)

def test_ods_writer_merge_conflicting_styles(ods_writer):

    sources = [ods_writer.currency_style(code) for code in ['USD', 'EUR']]

    with pytest.raises(ValueError, match='conflicting datastylename'):

        ods_writer.merge_styles(*sources)

def test_ods_writer_date_style(ods_writer):

    data_style_name = ods_writer.style_date.getAttribute('datastylename')

    actual = get_child(

        ods_writer.document.styles,

        odf.style.Style,

        family='table-cell',

        datastylename=data_style_name,

    )

    assert actual is ods_writer.style_date

    data_style = get_child(

        ods_writer.document.styles,

        odf.number.DateStyle,

        name=data_style_name,

    )

    assert len(data_style.childNodes) == 5