Re: [libreoffice-users] Sorting ranges with merged cells

At 17:47 25/02/2015 +0200, Lera Goncharuk wrote:
> If we try to sort ranges with merged cells in 
> the Calc, we see the message «Ranges containing 
> merged cells can only be sorted without 
> formats». This message implies that such ranges 
> can be sorted without splitting cells. But I do 
> not understand how to do it. Could anyone explain how to do it to me, please?

In the Sort dialogue (at Data | Sort...), on the 
Options tab, remove the tick from "Include formats".

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted