+- Linux Lite Forums (https://www.freecinema2022.gq/forums)
+-- Forum: Software - Support (https://www.freecinema2022.gq/forums/forumdisplay.php?fid=5)
+--- Forum: Other (https://www.freecinema2022.gq/forums/forumdisplay.php?fid=20)
+--- Thread: xlsx spreadsheet (/showthread.php?tid=8141)
xlsx spreadsheet - LarryB1607 - 02-23-2022
I tried opening an xlsx spreadsheet I created about a year ago. I had difficulty getting it open, but finally did it by using the move command. The cells and all controls except the minimize/maximize and the minimize to tray work. Everything else is frozen and I cannot even close the sheet. The sheet is done in LibreOffice Calc. I am using LLOS 5.8 all updates applied since yesterday. What can I do to get this functional again. Thanks
Re: xlsx spreadsheet - LarryB1607 - 02-23-2022
I tried to create a new spreadsheet and it is also frozen and cannot be closed.
Re: xlsx spreadsheet - LarryB1607 - 02-23-2022
Same thing happened when I tried to open the word processor to try and find out which version of LO I was using. Same controls completely frozen.
Re: xlsx spreadsheet - stevef - 02-24-2022
If it is only libreoffice with a problem, you may want to look at trying libreoffice in 'safe-mode'. If you can create and save documents in safe-mode then it implies there might be a problem with your libreoffice user profile.
In a libreoffice window click 'Help' then 'Restart in Safe Mode...' then 'Continue in Safe Mode'
OR in a terminal window type
Code:
libreoffice --safe-modeThis should open libreoffice with a fresh, temporary user profile which will allow you to try the functions.
Re: xlsx spreadsheet - LarryB1607 - 02-24-2022
Thanks for the reply, I went into safe mode and brought up document writer and it appeared to work as it should. Have not done any more testing. I posted the output of the terminal window if that helps diagnose the problem further. What would be my recourse, there were a number of choices in the safe mode dialogue box. Thanks
larrypc ~ libreoffice --safe-mode
(soffice:22691): Gtk-WARNING **: 13:08:18.045: Theme parsing error: gtk.css:2:0: Expected a valid selector
ALSA lib conf.c:3816
config_file_open) cannot access file /home/larrypc/.asoundrcALSA lib conf.c:3736
snd_config_hooks_call) function snd_config_hook_load returned error: Permission deniedALSA lib conf.c:4190
snd_config_update_r) hooks failed, removing configurationALSA lib conf.c:3816
config_file_open) cannot access file /home/larrypc/.asoundrcALSA lib conf.c:3736
snd_config_hooks_call) function snd_config_hook_load returned error: Permission deniedALSA lib conf.c:4190
snd_config_update_r) hooks failed, removing configurationALSA lib conf.c:3816
config_file_open) cannot access file /home/larrypc/.asoundrcALSA lib conf.c:3736
snd_config_hooks_call) function snd_config_hook_load returned error: Permission deniedALSA lib conf.c:4190
snd_config_update_r) hooks failed, removing configurationALSA lib conf.c:3816
config_file_open) cannot access file /home/larrypc/.asoundrcALSA lib conf.c:3736
snd_config_hooks_call) function snd_config_hook_load returned error: Permission deniedALSA lib conf.c:4190
snd_config_update_r) hooks failed, removing configurationALSA lib conf.c:3816
config_file_open) cannot access file /home/larrypc/.asoundrcALSA lib conf.c:3736
snd_config_hooks_call) function snd_config_hook_load returned error: Permission deniedALSA lib conf.c:4190
snd_config_update_r) hooks failed, removing configurationALSA lib conf.c:3816
config_file_open) cannot access file /home/larrypc/.asoundrcALSA lib conf.c:3736
snd_config_hooks_call) function snd_config_hook_load returned error: Permission deniedALSA lib conf.c:4190
snd_config_update_r) hooks failed, removing configurationALSA lib conf.c:3816
config_file_open) cannot access file /home/larrypc/.asoundrcALSA lib conf.c:3736
snd_config_hooks_call) function snd_config_hook_load returned error: Permission deniedALSA lib conf.c:4190
snd_config_update_r) hooks failed, removing configurationALSA lib conf.c:3816
config_file_open) cannot access file /home/larrypc/.asoundrcALSA lib conf.c:3736
snd_config_hooks_call) function snd_config_hook_load returned error: Permission deniedALSA lib conf.c:4190
snd_config_update_r) hooks failed, removing configurationALSA lib conf.c:3816
config_file_open) cannot access file /home/larrypc/.asoundrcALSA lib conf.c:3736
snd_config_hooks_call) function snd_config_hook_load returned error: Permission deniedALSA lib conf.c:4190
snd_config_update_r) hooks failed, removing configurationALSA lib conf.c:3816
config_file_open) cannot access file /home/larrypc/.asoundrcALSA lib conf.c:3736
snd_config_hooks_call) function snd_config_hook_load returned error: Permission deniedALSA lib conf.c:4190
snd_config_update_r) hooks failed, removing configuration
Re: xlsx spreadsheet - stevef - 02-24-2022
If you are confident that libreoffice functions ok in safe mode, it points to a problem in the user profile which is where LO stores user related data. This includes things like customised dictionaries, colour palettes, shortcuts, toolbar mods, imported extensions.
The choices to try to reset a profile depends mainly on how much LO has been customised since you first used it.
If you don't mind losing the customisation you've made while using LO then tick one or both the 'Reset to Factory' options and then 'Apply Changes and Restart' and test. This will give you a fresh start.
If you have a lot of customisation that you'd like to try to keep then 'Restore from backup' and using the 'last know working options' might be worth a go.
If you have any extensions, the 'Configure' and 'Extensions' options might help - otherwise ignore them.
Re: xlsx spreadsheet - LarryB1607 - 02-25-2022
Thanks stevef, that fixed it. So far it does not look like I lost any of the formatting of the old spreadsheet.