

Returns the first used cell in a given range or sheet. The single selected range as a string or the list of selected ranges as an array. The properties specifically available for Calc documents are: For more information, read the Document service Help page. The current selection in the active sheetĪll the properties generic to any document are implicitly applicable also to Calc documents. The examples below illustrate in which cases the use of single quotes is mandatory:Įxcept for the CurrentSelection property, the Calc service considers only single ranges of cells.Īll cells in contiguous columns or rows up to the last used cellĪ range named "myRange" at spreadsheet levelĪ range within the sheet SheetX in file associated with the myDoc Calc instance When specifying a SheetName as a string, the use of single quotes to enclose the sheet name are required if the name contains blank spaces " " or periods ".". Surrounding single quotes and $ signs are allowed but ignored.

If no sheet name is provided, then the active sheet is used. The sheet name is optional when defining a range.

The shortcut "*" represents all used cells. The shortcut "~" (tilde) represents the current selection or the first selected range if multiple ranges are selected. RangeNameĮither a string designating a set of contiguous cells located in a sheet of the current instance or an object produced by the. The shortcut "~" (tilde) represents the current sheet. DocA = ui.OpenDocument(r"C:\Documents\FileA.ods", hidden = True, readonly = True)ĭocB = ui.OpenDocument(r"C:\Documents\FileB.ods")ĭocB.CopyToRange(docA.Range("SheetX.D4:F8"), "D2:F6")Įither the sheet name as a string or an object produced by the.
