When you select fixtures in a spreadsheet (DATA view), the selection order is not respected. Example: select spot 1,2,3 in a spreadsheet, then select a focus line in CAD holding CTRL. If you assign the fixtures to the focus object, this ha the exact same result as selecting spot 3,2 and then 1 from the spreadsheet. If you make the same selections in your CAD view, the selection order is respected.