https://bugs.documentfoundation.org/show_bug.cgi?id=122980
Oliver Brinzing <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
Ever confirmed|0 |1
CC| |[email protected]
--- Comment #1 from Oliver Brinzing <[email protected]> ---
reproducible with
Version: 6.1.5.1 (x64)
Build-ID: f18954c1ba9116b85c32b6bdbc0188d3e0fd24c7
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard;
Gebietsschema: de-DE (de_DE); Calc:
macro recording does not save cell selections.
btw: a better solution would be to use LO API, e.g.:
Sub DeleteRange()
Dim oDoc as Object
Dim oSheet as Object
Dim oRange as Object
Dim nFlag as Long
oDoc = ThisComponent
oSheet = oDoc.getSheets().getByName("Sheet1")
oRange = oSheet.getCellRangeByName("A2:A10")
'
https://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/CellFlags.html
nFlag = com.sun.star.sheet.CellFlags.VALUE +_
com.sun.star.sheet.CellFlags.STRING +_
com.sun.star.sheet.CellFlags.DATETIME
oRange.clearContents(nFlag)
End Sub
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
