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

On 7/2/23 07:42, David Carter wrote:
> 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.

Hi!  I've found Calc 7.5 still works the same as you expect. Make sure 
to have the "Standard Toolbar" displayed (at least to deal with your 
immediate issue) and make sure the "Formatting" toolbar is visible.  
With both of those in place, I was able to do what you describe:

Select a column
Change the background color of the entire column

It was literally two clicks of the mouse.  :)

I'll send you a couple of screenshots since I'm not currently setup to 
host images online.

Peace...

Tom


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