Maybe solved I don't know for sure.
I don't know if this is the way to fix this problem but it worked as far as file associations are concerned.
I think I found a way to correct the spreadsheets file associations problem I've been having.
First goto preferred applications in control center.
Select the office tab.
Select spreadsheet editor drop down list.
I selected WPS spreadsheet application
Close all windows
Now all spread sheets, even Libre Office calc (ODS) will use WPS to open which ODS spreadsheet files won't open (error will be displayed). Now right click on any ODS file goto "properties>open with" and select Libre Office. Now xlsx files will open with WPS Office program and ODS files will open with Libre Office.
I had problems with fractions displaying decimal to fraction conversion in Libre Office calc. Some decimals like .750 would display a 1(one) instead of 3/4. I did not have this problem on WPS office spreadsheet. That's why I set up the file associations this way. I submitted a bug on the Libre Office site.