Ask Your Question

sort of xls file hangs

asked 2015-10-07 02:56:48 +0100

updated 2015-10-16 15:41:06 +0100

Alex Kemp gravatar image

I have a .xls spreadsheet that I have been updating monthly using OpenOffice. I just installed Linux 6.7 and with it came LibreOffice instead of OpenOffice. LibreOffice will NOT sort this spreadheet. My screen goes gray and then an hour later I have to force shutdown the program. This is a monthly process that I need to complete ASAP. Can you help me get this spreadsheet sorted? Please? Thanks, Bonnie

edit retag flag offensive close merge delete


i am using the menu bar. selecting 'Data' then 'Sort'

cobonnie gravatar imagecobonnie ( 2015-10-07 14:20:52 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2015-10-07 15:37:23 +0100

Alex Kemp gravatar image

Hi cobonnie

It is possible to install AOO & LO in tandem.

That .xls file needs to be saved in native AOO/LO format (.ods) - both AOO & LO will be able to open those files. XLS is far more problematical due to differing standards of compatibility with MS. If you need to later transfer it to someone running M$ Office you can then save in XLS format.


If this helps then please tick the answer (✔)
...and/or show you like it with an uptick ()

edit flag offensive delete link more


I saved my .xls file as a .ods file and the sort still hangs. my it support has tried to install OpenOffice but get an error saying there is a file conflict. We even tried removing LibreOffice and installing OpenOffice but again we got an error saying there is a file conflict. Evidently LibreOffice cannot be removed (?). Transaction Check Error: file /usr/bin/soffice from install of ibm-config-openoffice-1:4.1.1-9775.el6.6.x86_64 conflicts with file from package libreoffice-core-1:

cobonnie gravatar imagecobonnie ( 2015-10-15 17:48:19 +0100 )edit

"LibreOffice cannot be removed": nonsense. "Transaction Check Error": evidently LO is NOT uninstalled. Good job, IT Support.

Alex Kemp gravatar imageAlex Kemp ( 2015-10-16 15:40:19 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-10-07 02:56:48 +0100

Seen: 40 times

Last updated: Oct 07 '15