At 11:43 28/05/2016 -0400, Vince Bonly wrote:
Two observations when using the Toolbar A-Z sort button:
I've noted that if/whenever another cell within the same row does
/_not_/ have anything entered, the sorted result appears to be messed up.
I don't see this (and it appears no-one else does either).
I select a (key) column and afterward do click on the "Extend
selection" button. Must I enter dummy data (hyphen, for example) to
satisfy the apparent requirement that every adjacent cell in the row
must have some data?
I don't see any such requirement. I hope there isn't, as it would be
silly. If you continue to see this, you may have to construct and
describe a simple-as-possible set of instructions to reproduce the problem.
Are the contents of the adjacent cells actual values (numbers, text,
whatever?) or are they the results of formulae? If they are formulae
(no matter how simple), remember that the results of those formulae
may be affected by the process of sorting. Is that what you are seeing?
For example, suppose that you have text values (to be sorted) in
column A and formulae in column B, with column headings in row 1. Say
that B3 has =LEFT(A2) and so on, filled down column B. The result of
this will be that each B cell will have just the initial letter of
the A cell in the *previous* row. If you now sort on column A as you
describe, the values in column B will correspond to the *new*
preceding row and not what preceded it before the sort process. That
may or may not be what anyone would want.
Some cells are formatted for Wrap Text alignment. The row height of
those rows that do contain wrapped-text is varied (made too small)
after executing the sort routine, forcing me to readjust the row's
height. Is this normal behavior?
Yes and no. If you have set the row heights manually, I think these
settings will be preserved - which may create the effect you see.
Is there a method to freeze the row height?
Er, do you want to preserve the row heights where they are - so that
the data may no longer fit - or do you wish the heights not to be
frozen but to move around with the data?
If you use the default row height (double-click on the row separator
below the relevant row in the row headers) and then choose "Wrap text
automatically" in the cell formatting (is that what you mean?), I
think you will see what you need.
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
