Calc Style Page

Overview

Applying Page Styles can be accomplished using the ooodev.format.calc.style.Page class.

The CalcStylePageKind enum is used to lookup the style to be applied.

Setup

General function used to run these examples.

import uno
from ooodev.format.calc.style import Page, CalcStylePageKind
from ooodev.office.calc import Calc
from ooodev.gui import GUI
from ooodev.loader.lo import Lo


def main() -> int:
    with Lo.Loader(connector=Lo.ConnectPipe()):
        doc = Calc.create_doc()
        GUI.set_visible(True, doc)
        Lo.delay(500)
        Calc.zoom_value(doc, 400)

        sheet = Calc.get_active_sheet()

        cell_obj = Calc.get_cell_obj("A1")
        Calc.set_val(value="Hello", sheet=sheet, cell_obj=cell_obj)

        style = Page(name=CalcStylePageKind.REPORT)
        style.apply(sheet)

        page_style = Page.from_obj(sheet)
        assert page_style.prop_name == str(CalcStylePageKind.REPORT)

        Lo.delay(1_000)
        Lo.close_doc(doc)
    return 0


if __name__ == "__main__":
    SystemExit(main())

Apply Style to a sheet

# ... other code
style = Page(name=CalcStylePageKind.REPORT)
style.apply(sheet)

Result be seen in Fig. 463.

Style applied to Cell

Fig. 463 Style applied to Cell

Get Style from a Cell

Get Style from a sheet by calling Page.from_obj() passing in the sheet object.

# ... other code

page_style = Page.from_obj(sheet)
assert page_style.prop_name == str(CalcStylePageKind.REPORT)