Array

[eugenefoxx]

Tell me how to present the page in calc as an array so that you can also manipulate data (counting by an element, finding values, etc.).

[FJCC]

The functions INDEX() and OFFSET() might be what you are looking for but I am not really sure. Please give a concrete example of what you want to do.

[robleyd]

Or possibly a Pivot Table (formerly known as Data Pilot) might do what you need. https://wiki.openoffice.org/wiki/Docume ... /DataPilot

[eugenefoxx]

Attached file, greatly reducing it. It has formulas, but since the size of the information is large, I want to simplify the calculations in the array. And this file is one of many that I want to include in the analysis file.

[eugenefoxx]

Please help me, how to insert the data we got

Code: Select all

 
         i = arr2(r)(0)
		e = arr2(r)(4)

into the range Sheets(0).getCellRangeByName("K6:K24")

Code: Select all

 
Sub test
Dim c, r, i, e as integer

arr1 = ThisComponent.Sheets(0).getCellRangeByName("B6:I24").getDataArray()
arr2 = ThisComponent.Sheets(1).getCellRangeByName("L6:P60000").getDataArray()

For a = 0 to ubound(arr1) 
	For r = 0 to ubound(arr2)
		If arr1(a)(0) = arr2(r)(3) Then

		i = arr2(r)(0)
		e = arr2(r)(4) 
		print i
		print e	
'		oRange1 = ThisComponent.Sheets(0).getCellRangeByName("K6:K24").setDataArray(i)
		
		End If
	Next r
Next a

End Sub