I'm trying to optimize the performance of a simulator by using an array(364,839) as buffer for the daily results in a named-range with 1 row and 840 Columns.
Code: Select all
cResults1Y = ThisComponent.Sheets(0).getCellRangeByName("ResultsYearSim")
cResults1D = ThisComponent.Sheets(0).getCellRangeByName("ResultsDaySim")
ArrayY = cResults1Y.Data 'Result: Object(0 to 364)
ArrayD = cResults1D.Data 'Result: Object(0 to 0)
Code: Select all
ArrayY(i-1) = ArrayD() 'Result: Object(0 to 364)
named range "ResultsYearSim" (cResults1Y). I have tried several different methods found
on the forum without success.
Code: Select all
cResults1Y.Data = ArrayY
What am I missing?
Thanks in advance