Hi Max74, Max74 schrieb:
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?
The sheets are numbered, beginning with 0. So you need to compare the search index with the total number of sheets.
To test, whether a sheet with index 2 exists: If oSheets.Count > 2 Then [...] Existing indices 0, 1, 2 results in Count=3. The indices are consecutive, so indices 0, 1, 2, 4, 5 is impossible. Kind regards Regina -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
