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)