diff options
author | Tor Lillqvist <tml@collabora.com> | 2018-05-09 15:11:20 +0300 |
---|---|---|
committer | Andras Timar <andras.timar@collabora.com> | 2018-08-20 11:56:55 +0200 |
commit | ff90c61e747a7b5a5bfcb6375837888a4b4e600f (patch) | |
tree | 584b406526d6a5f824f1af1ab623563dba22a58e | |
parent | 30b74c1dd424d6e9af6c772a4ae1554ee357e694 (diff) |
Use the . separator between sheet name and cell range instead of ! to match UI
Also put a dollar in front of the sheet name.
Change-Id: I93d610dad8ad085718b0fe389e460b588939e5d2
(cherry picked from commit 79fa6ac73caeae089d255c6b8629075364b4a477)
Reviewed-on: https://gerrit.libreoffice.org/54035
Reviewed-by: Miklos Vajna <vmiklos@collabora.co.uk>
Tested-by: Miklos Vajna <vmiklos@collabora.co.uk>
(cherry picked from commit 849fb9927b85752787e34039a6e243eb5e399c02)
-rw-r--r-- | scripting/examples/python/NamedRanges.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/scripting/examples/python/NamedRanges.py b/scripting/examples/python/NamedRanges.py index b699f286fc26..34307ae8440c 100644 --- a/scripting/examples/python/NamedRanges.py +++ b/scripting/examples/python/NamedRanges.py @@ -37,7 +37,7 @@ def DefineNamedRange(sheet, x0, y0, width, height, name): # FIXME: Is there some Python-callable API to turn a row and column into an A1 string? # This obviously works only for the first 26 columns. abc = "ABCDEFGHIJKLMNOPQRSTUVWXYZ" - content = sheet +"!" + "$" + abc[x0 : x0+1] + "$" + str(y0+1) + ":" + "$" + abc[x0+width-1 : x0+width] + "$" + str(y0+height) + content = "$" + sheet + "." + "$" + abc[x0 : x0+1] + "$" + str(y0+1) + ":" + "$" + abc[x0+width-1 : x0+width] + "$" + str(y0+height) position = uno.createUnoStruct('com.sun.star.table.CellAddress') position.Sheet = 0 position.Column = 0 |