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 16:37:11 +0200 |
| commit | f7ef2421af666b4df4d82b6e897eaa9bd38c3508 (patch) | |
| tree | 2dec09694361c8345b9b4927ba2128b976aefea6 /scripting | |
| parent | 9fa8c9d3772a9c3197f73698ed8c4a9050e3750e (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>
Reviewed-on: https://gerrit.libreoffice.org/52318
Diffstat (limited to 'scripting')
| -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 |