[Dropped] Need some help for Calc macro function

[Ricky]

i started a new calc macro function

and having some problems and need help

first problem is with a for loop

it does read the first value but cannot read the other values function of rows!

Code: Select all

for i = Xrow to xrowmax
		my_cell = ThisComponent.Sheets(0).getCellByPosition( 1  , i )
		com.sun.star.table.CellContentType.VALUE
		cell_value = my_cell.Value

		MsgBox "cell value = " & cell_value
	next i

can someone help to make this loop work as it should !


thanks for feedback

[FJCC]

I can run your code as a Sub with no problem. This version reads back the first 5 values in column B of the first sheet.

Code: Select all

Sub Main
Xrow=0
xrowmax=4
for i = Xrow to xrowmax


my_cell = ThisComponent.Sheets(0).getCellByPosition( 1 , i )


'com.sun.star.table.CellContentType.VALUE
cell_value = my_cell.Value

MsgBox "cell value = " & cell_value


next i
End Sub

How exactly are you using your code?

[Zizi64]

A macro Function can modify only the value of that cell, where the function was called.

If you want to modify the values more than one cells, then you must
- create an array Function.
- use the macro as a Subroutine, launched by some user activity or event.