odk/examples/DevelopersGuide/FirstSteps/FirstLoadComponent.py | 62 ++++++++++
1 file changed, 62 insertions(+)
New commits:
commit 7dc3be651b050c7b4d383d8ee25b69728418acc7
Author: Hossein <hoss...@libreoffice.org>
AuthorDate: Fri Sep 8 01:16:29 2023 +0200
Commit: Hossein <hoss...@libreoffice.org>
CommitDate: Fri Sep 8 10:16:06 2023 +0200
tdf#143123 Port DevelopersGuide/FirstSteps/FirstLoadComponent to Python
Porting FirstSteps/FirstLoadComponent.java to Python is done. More
information on this example can be found on LibreOffice DevGuide:
LibreOffice Developer's Guide: Chapter 1 - First Steps - First Contact
https://wiki.documentfoundation.org/Documentation/DevGuide/First_Steps
This is the last of the 3 examples in the first chapter which are ported
to Python.
Change-Id: Iac0682943d4286168bbdadf792423670f41bdee6
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/156686
Tested-by: Hossein <hoss...@libreoffice.org>
Reviewed-by: Hossein <hoss...@libreoffice.org>
diff --git a/odk/examples/DevelopersGuide/FirstSteps/FirstLoadComponent.py
b/odk/examples/DevelopersGuide/FirstSteps/FirstLoadComponent.py
new file mode 100755
index 000000000000..a5d93d799f8c
--- /dev/null
+++ b/odk/examples/DevelopersGuide/FirstSteps/FirstLoadComponent.py
@@ -0,0 +1,62 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This file is part of the LibreOffice project.
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# License, v. 2.0. If a copy of the MPL was not distributed with this
+# file, You can obtain one at http://mozilla.org/MPL/2.0/.
+#
+
+import uno
+import officehelper
+import sys
+import traceback
+from com.sun.star.sheet.CellFlags import FORMULA
+
+
+def main():
+ try:
+ remote_context = officehelper.bootstrap()
+ if remote_context is None:
+ print("ERROR: Could not bootstrap default Office.")
+ sys.exit(1)
+ srv_mgr = remote_context.getServiceManager()
+ desktop =
srv_mgr.createInstanceWithContext("com.sun.star.frame.Desktop", remote_context)
+ spreadsheet_component =
desktop.loadComponentFromURL("private:factory/scalc", "_blank", 0, tuple())
+ spreadsheets = spreadsheet_component.getSheets()
+ spreadsheets.insertNewByName("MySheet", 0)
+ elem_type = spreadsheets.getElementType()
+ print(elem_type)
+ sheet = spreadsheets.getByName("MySheet")
+ cell = sheet.getCellByPosition(0, 0)
+ cell.setValue(21)
+ cell = sheet.getCellByPosition(0, 1)
+ cell.setValue(21)
+ cell = sheet.getCellByPosition(0, 2)
+ cell.setFormula("=sum(A1:A2)")
+
+ cell.setPropertyValue("CellStyle", "Result")
+
+ spreadsheet_controller = spreadsheet_component.getCurrentController()
+ spreadsheet_controller.setActiveSheet(sheet)
+ cell.setPropertyValue("VertJustify",
"com.sun.star.table.CellVertJustify.TOP")
+ formula_cells = sheet.queryContentCells(FORMULA)
+ formulas = formula_cells.getCells()
+ formula_enum = formulas.createEnumeration()
+
+ while formula_enum.hasMoreElements():
+ formula_cell = formula_enum.nextElement()
+ print("Formula cell in column " +
str(formula_cell.getCellAddress().Column)
+ + ", row " + str(formula_cell.getCellAddress().Row)
+ + " contains " + cell.getFormula())
+
+ except Exception as e:
+ print(e)
+ traceback.print_exc()
+ sys.exit(1)
+
+
+if __name__ == "__main__":
+ main()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
