Cell selection issues in sheets with colSpan or rowSpan

[RajuSuranagi]

I have cells A:D and 1:10 with varying colSpans and rowSpans. When selecting all cells, the selection works perfectly. But when selecting few rows with colSpan or rowSpan, the cells selected will be 'n' where n > number of cells in given row under the selection greater than number of cells (irrespective of any colSpan) in any other row.

Example: Rows: A1:D1 (colSpan 4) E1 F1 A2 B2 C2 D2 E2:F2

Mouse drag: A1:D1 and down

Selected Cells (Result): A1:D1, E1, F1, A2, B2, C2

Expected: A1:D1 A2, B2, C2

[ettanass]

I have the same issue, any informations?

[resulyrt93]

i have same problem. did you any progress?