(In reply to rolf.kuehlwein from comment #0)
> Hello Team,
> i use the event function(Sheet - events - content changed) in Calc to start
> a makro,this work's only in the first sheet. If I set this in other sheets
> it does not work in these.

Hi, can you provide more details that help to reproduce the error?

I use a macro that controls the input of a cell in column 0.

This makro works only on Table number 0.

I set up the macro under the menu item Table - Events - Content changed, under Table 0 and it works. If I do the same with Table 1, the macro does not work in this Table.

makro :
Sub Zellegeaendert

	Dim oCell as Object
	Dim Zeile As Integer
	Dim Spalte As Integer
	Dim Zellinhalt As String
	
	Dim oDokument As Object
	Dim oTabelle As Object
	Dim oTabellen As Object

	oDokument = ThisComponent  
 	oTabellen   = oDokument.Sheets
	oTabelle     = oDokument.Sheets.getByName(TabellenName)
	
        Zeile = AktuelleZeile    'geaenderdeZelle.CellAddress.Row '-8
	Spalte = AktuelleSpalte  'geaenderdeZelle.CellAddress.Column

	If Spalte <> 0 Then Exit Sub 

	'Msgbox Zeile & "  " & Spalte
	Zellinhalt = oTabelle.getCellByPosition(Spalte ,Zeile).String
	'Msgbox Zeile & "  " & Spalte & "  " & Zellinhalt
	If val(Zellinhalt) = 0 Then Exit sub

	SuchenNach(Zellinhalt)

End Sub

Sorry ,

For the Sheet "oTabelle" i used "oDokument.currentcontroller.activesheet"

Hallo

It is impossible for us to check whether and what the functions »AktuelleZeile ... AktuelleSpalte... and last not least SuchenNach(...)« actually do!!

Hello Team ,

I' sorry . I tryed it in a new Document.
And there it works.
I looked after the error.

Sorry , many thank's.
Rolf