Re: [libreoffice-users] Calc - Can't highlight a column and set background shading

Dear David,

a new installation will not touch personal settings.
All settings you have made will be stored in the so-called user profile.

https://wiki.documentfoundation.org/UserProfile

This user profile is not touched during installations.

So if you want to turn a toolbar on or off, choose View>Toolbars from 
the menu.
The toolbar you are looking for is probably "Formatting".

Formatting with toolbars is also called direct formatting, and is not 
well suited for larger documents.

To format cells (or columns/rows), cell styles should be used.
How to do that you can find here:
https://wiki.documentfoundation.org/Videos/Cell_Styles_in_Calc

Good luck!

Best Regards
Harald



Am 02.07.2023 um 16:42 schrieb David Carter:
> Been using Open Office and then LibreOffice since 1993.  Used to use 
> Bugzilla occasionally in the past.
> . . . This is my first post to this mailing list, to seek support from 
> the community.
>
> I have a spreadsheet I've been using for 3 years.  I modify it 
> occasionally.
>
> I have previously selected a column and clicked the "background 
> highlight" icon with color of yellow selected - that would turn the 
> entire column yellow - it no longer works!
>
> I suspect I "thrashed around" and changed something about the Toolbars 
> that has caused this problem.
>
> I just uninstalled and re-installed Libre Office on my Windows 7 
> Professional desktop computer - LibreOffice 7.5.4.2.  I did this to 
> get away from any "unintended" changes I may have made.  It did not 
> fix any of the problems noted in the next paragraph.
>
> I also seem to have changed how the toolbars display:  They have the 
> "system blue" background color, the icons seem larger or different, 
> and the "background highlight" tool seems to be different - has black 
> "ab" over yellow line.  See attached screen shot.
> *_. . . I can no longer highlight a cell or column of cells and change 
> the background to yellow._**_
> _**_
> _**_This is the problem I am reporting and for which I am asking for 
> help._**_
> _*
> Urgency:  I am "dead in the water" on my number one priority task. 


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy