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