Hi :) When you find and select the merged cells i think that option changes from "Merge cells" to "unmerge cells". Any chance of uploading the file to Nabble? If it's confidential then don't as this is a public mailing-list. Regards from Tom :)
--- On Fri, 3/2/12, Rich Shepard <[email protected]> wrote: From: Rich Shepard <[email protected]> Subject: [libreoffice-users] Sorting Rows: Merged Cells Error To: [email protected] Date: Friday, 3 February, 2012, 23:58 I have a spreadsheet sent by a client as .xlsx and saved by me as .ods. When I try to sort the rows on one tab I am prevented from doing so by this error message: "Ranges containing merged cells can only be sorted without formats." How do I identify what cells have been merged? I see none. And, once identified do I unmerge them by putting the cursor in one of the cells and selecting Edit -> Merge cells? Rich -- For unsubscribe instructions e-mail to: [email protected] 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 -- For unsubscribe instructions e-mail to: [email protected] 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
