I am trying to understand why getRangeByIndex does not work when copy pasting from one sheet to another sheet
Here is the getRange script
`function main(workbook: ExcelScript.Workbook) {
let temp = workbook.getWorksheet("Temp");
let selectedSheet = workbook.getActiveWorksheet();
// Paste to range A1 on temp from range F9:J9 on selectedSheet
temp.getRange("A1").copyFrom(selectedSheet.getRange("F9:J9"), ExcelScript.RangeCopyType.all, false, false);
}`
Here is the getRangeByIndex
`function main(workbook: ExcelScript.Workbook) {
let temp = workbook.getWorksheet("Temp");
let selectedSheet = workbook.getActiveWorksheet();
// Paste to range A1 on temp from range F9:J9 on selectedSheet
temp.getRange("A1").copyFrom(selectedSheet.getRangeByIndexes(0,5,1,5), ExcelScript.RangeCopyType.all, false, false);
}`