🚀 go-pugleaf

That not-brilliantly named function sorts out the columns that are part of the selection. The problem could be that included in the selection is one or more merged cells. For example, the user might select just two cells in a row and run the script, but if the two cells are merged, for my script to work, I need the leftmost column of the first cell and the rightmost column of the last cell.

When I wrote the function, I thought I had to deal with non-rectangular selections (where a merged cell sticks out to the right of a selection of cells), so I thought I had to visit every cell in the selection.

Later, I was to discover the bug that makes such a selection impenetrable to a script but by then I had forgotten that I had handled the possibility in that function.

Because you can't know which (if any) cell might be sticking out, I processed every cell in the selection. That statement primes the initial values of Lcol and Rcol to be impossibly large and small respectively so that the first time around the loop the calls to Math.min and Math.max will generate the values of the first cell. After that, Lcol and Rcol will adjust appropriately.

Now that I'm revisiting this logic with such detail, I can see that all I really needed to do was pick up Lcol from the first cell and Rcol from the last.

Dave