Found it. With an update the default option had changed to include Formats. Unticking this and normal service has been restored.

On 06/12/2023 09:30, Budge wrote:
I have been sorting on a column using Data>Sort and extending to include the range wanted.  This worked a few weeks ago but now on the same spreadsheet I get a popup:-
Ranges containing merged cells can only be sorted without formats.

I click on OK but then nothing happens.
Something has changed but how do I now get this to work please?



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Reply via email to