At 11:00 01/06/2018 -0400, Vince Bonly wrote:
TNX again Brian; your suggestion worked perfectly.
Good-oh!
There remains a problem, however. When attempting to sort with
extended selection data contained within B2:C14:
G L
A L
C O
[...]
the data within B2;C2 is not being included during the sorting
execution. I have seen this happen previously (shading not
involved). Any ideas on this?
Yup. On the Options tab of the Sort dialogue, you will see "Range
contains column labels". If this is ticked, the top row of the block
of values (for sorting rows, or leftmost column for sorting columns)
will be teated as labels - in other words names for the columns (or
rows) of actual data - rather than part of the data themselves. In
your case, the G and the L are being treated as labels for columns B
and C. Remove the tick and you will get what you want.
Note that Calc appears to set this option intelligently - perhaps
assuming that text values - your G and L - are likely to be labels. I
find it is always necessary to check this option before clicking OK
to carry out the sort process. I suppose the proper way to do things
is first to give all your columns labels in the preceding row and
then always to include that label row in the range you sort. Calc
should make the appropriate decision to tick that option and
everything will be hunky-dory.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
