Ask Your Question
0

sort of xls file hangs [closed]

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

cobonnie gravatar image

updated 2020-08-26 13:47:51 +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 4.2.8.2 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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-26 13:48:02.491879

Comments

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
0

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.

HTH

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

edit flag offensive delete link more

Comments

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:4.2.8.2-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

Question Tools

1 follower

Stats

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

Seen: 59 times

Last updated: Oct 07 '15