Re: [libreoffice-users] Sheet name vs. sheet index

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: users+help@global.libreoffice.org
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