@Max74, Did @w_whalley's answer work for you? Please let us know so we can resolve this question.
qubit ( 2013-01-27 07:12:09 +0200 )edit
Hi there,
I need a macro that check if a sheet exists by its index instead of its name
For example:
oSheets = ThisComponent.Sheets()
If oSheets.hasByName("Invoice") Then
[...]
works fine
Instead I need something like this (that obviously doesn't work):
If oSheets.hasByIndex(2) Then
[...]
Anyone can help me?
Thanks.
Sub Main
target=2 rem looking for sheet number 2 (not sheet index 2)
oSheets=ThisComponent.Sheets()
i=oSheets.getcount() rem i is the number of sheets
if (i >= target) then
msgbox "Found it"
else
msgbox "Not found"
end if
End Sub
@Max74, Did @w_whalley's answer work for you? Please let us know so we can resolve this question.
qubit ( 2013-01-27 07:12:09 +0200 )editLibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-04-23 22:59:56 +0200
Seen: 363 times
Last updated: Apr 25 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.