summaryrefslogtreecommitdiff
path: root/stoc/source/inspect
diff options
context:
space:
mode:
authorJean-Pierre Ledure <jp@ledure.be>2021-11-09 11:00:04 +0100
committerJean-Pierre Ledure <jp@ledure.be>2021-11-09 13:09:24 +0100
commit754247fe3fb1c8baa8f37f7ea1eb74aa3f0bcd57 (patch)
tree0a9a36e6653cd904536290e4ef8b2e7e6bc7cd20 /stoc/source/inspect
parenta14b783bbe8eda32b4b79530d85ffc48b6ed0305 (diff)
ScriptForge - (SF_Calc) First/Last * Row/Column/Cell accept sheets and ranges
The methods FirstCell FirstColumn FirstRow LastCell LastColumn LastRow SheetName accept uniformly either a sheet name or a range name. They return a single cell as an absolute address (First/LastCell), a String (SheetName) or a Long. The range name is to be understood as the extended notation for ranges. FirstCell/Column/Row accept sheet names. However they will then always return either the "A1" cell or the value 1. The LastCell/Column/Row return the real last xxx for ranges, and the last USED xxx when the argument is a sheet. The A1Style() method surrounds from now on sheet names with single quotes only when necessary. The GetRangeAddress() method has been dropped as redundant with the actual methods. (Was new in 7.3 => no effect on upward compatibiity) Change-Id: Iff1ce437ee27dfb8481361f648b3f7a33ae2c4b1 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/124904 Tested-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins Reviewed-by: Jean-Pierre Ledure <jp@ledure.be>
Diffstat (limited to 'stoc/source/inspect')
0 files changed, 0 insertions, 0 deletions