[Solved] Cell contents via Basic while cell is in input mode

[brody]

[SOLVED]Hi:
Wrote the following to test zeroing out data in a group of cells.

Sub zeroOnButtonPress
xKtr = 0
yKtr = 0
oSheet = ThisComponent.getSheets().getByName("Sheet1")
for xKtr = 2 to 3
for yKtr = 6 to 9
oCell = oSheet.getCellByPosition(xKtr,yKtr)
oCell.value = 0
next
next
End Sub


During testing though, I noticed that if I started editing a cell - ie typing "asdf" into the cell, and then clicked on the button to run the macro, all of the cell values change EXCEPT the cell I was in edit mode with.

How do you force the cell out of edit mode prior to changing the data?

Thanks,
Brody

[FJCC]

Here is an ugly hack that seems to work.

Code: Select all

Sub zeroOnButtonPress
oCntrl = ThisComponent.CurrentController

xKtr = 0
yKtr = 0
oSheet = ThisComponent.getSheets().getByName("Sheet1")

oCell = oSheet.getCellByPosition(0,0)
oCntrl.select(oCell)

for xKtr = 2 to 3
for yKtr = 6 to 9
oCell = oSheet.getCellByPosition(xKtr,yKtr)
oCell.value = 0
next
next
End Sub

[brody]

Oh clever. Selecting a indifferent cell rather than DE-selecting the current one. I like this. Thank you so much!