Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

At 18:45 25/02/2015 -0500, Alan Bonly wrote:
On Wed, Feb 25, 2015 at 10:47 AM, Lera Goncharuk wrote:
Ā«Ranges containing merged cells can only be sorted without formatsĀ». This message implies that such ranges can be sorted without splitting cells.

I believe this is a poorly worded information message. I have not found any way to sort a range with merged cells including selecting the whole range, right-clicking and selecting "Clear direct formatting". It seems merging of cells is treated as a formatting option, at least in the case of this message.

Well, the message has certainly misled you. You are suggesting here that "without formats" means that you cannot sort cells to which some sort of formatting has been applied. But no: that's not what it means.

When you sort cells generally, the range may have different formatting applied to different cells: imagine, for example, that one of the cells has a different font colour. Is that colouring associated with the particular cell or with the value it contains? It could be either. When you sort the values, do you want that colouring to stay in the same cell or to move with the value as the range is sorted? That will depend on why you have applied that colouring, so you have a choice. This is controlled by "Include formats" on the Options tab of the Sort dialogue. If you have this ticked, then formatting moves with the values; otherwise it stays in the same cells.

You can certainly sort a range that includes merged cells, but you can do so only if you leave the formatting where it is, not move it with the values. If you try to sort a range including merged cells with the "Include formats" option ticked (which appears to be so by default), you will be warned that - although you can sort the range - you can do so only with that option deselected.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.