[Solved] Macro to obtain row column like Ctrl-End does

[norisezp]

I need a basicmacro in Calc that will get the row and column of the last filled cell like ctrl+end does, but without moving the cursor. Any ideas?

[FJCC]

Try something like this

Code: Select all

  oSheets = ThisComponent.getSheets()
  oSheet = oSheets.getByName("Sheet1")
  oCurs = oSheet.createCursor()
  
  oCurs.gotoEndOfUsedArea(False)
  print oCurs.AbsoluteName
  print " Column Index = " & oCurs.RangeAddress.StartColumn & " Row Index = " & OCurs.RangeAddress.StartRow

[norisezp]

Thank you. Question: If code gets serially reused, is it necessary to delete the oCurs object on each trip through, to avoid filling up the heap and/or stack?

[FJCC]

Once you create the cursor with oCurs = oSheet.createCursor(), you can reuse that object as much as you want. You don't need to create a new cursor for each use. For example, if you have a loop in your code, put the createCursor() statement outside of the loop and the commands to move the cursor inside of the loop. Is that the sort of use you are asking about?

[norisezp]

It's actually in a function, but I can make it global easily enough. Thank you very much. I'll punch he Answered key.