diff options
| author | Tor Lillqvist <tml@collabora.com> | 2018-03-28 16:52:28 +0300 |
|---|---|---|
| committer | Miklos Vajna <vmiklos@collabora.co.uk> | 2018-04-03 14:33:39 +0200 |
| commit | ca6dc501e3b888a59d2ec906010d6db2c2cda919 (patch) | |
| tree | 26623f08515763ec2b1877be77c4cfd0b24662ae | |
| parent | 82dd9f10f1c64736f06f8c224a383751e3b70f74 (diff) | |
Add DeleteNamedRange function
Change-Id: I081614cb34aee704c9162f58c78dbaa6a350d30b
(cherry picked from commit f21e341d0fbfb39f7d5d976f89f00f844e201576)
Reviewed-on: https://gerrit.libreoffice.org/52095
Reviewed-by: Miklos Vajna <vmiklos@collabora.co.uk>
Tested-by: Miklos Vajna <vmiklos@collabora.co.uk>
| -rw-r--r-- | scripting/examples/python/NamedRanges.py | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/scripting/examples/python/NamedRanges.py b/scripting/examples/python/NamedRanges.py index abdef141f397..812cabb583e0 100644 --- a/scripting/examples/python/NamedRanges.py +++ b/scripting/examples/python/NamedRanges.py @@ -35,3 +35,14 @@ def DefineNamedRange(sheet, x0, y0, width, height, name): position.Row = 0 model.NamedRanges.addNewByName(name, content, position, 0) return None + +def DeleteNamedRange(name): + try: + desktop = XSCRIPTCONTEXT.getDesktop() + model = desktop.getCurrentComponent() + model.NamedRanges.removeByName(name) + except Exception as e: + print("Caught Exception: " + str(e)) + tb = e.__traceback__ + traceback.print_tb(tb) + return None |