https://bugs.documentfoundation.org/show_bug.cgi?id=122945

Andreas Heinisch <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]

--- Comment #9 from Andreas Heinisch <[email protected]> ---
LibreOffice sets the background color of the tab in ScDocFunc::SetTabBgColor
where it checks if the tabs is protected or not. If the tab is protected, no
background will be set for the corresponding tab. 

Allowing to change the background color in the function will allow the change
of the background color via Basic macro:
ThisComponent.getCurrentController().getActiveSheet().TabColor = 255*200

In M$ Excel I can change the background color of a tab via VBA as well:
Worksheets("Sheet1").Tab.Color = RGB(25, 25, 25)

Saving the document in LibreOffice/M$ will keep the changed background color of
the tab.

Should we stick to the behaviour of M$ or try to set the background color
differently for a protected tab in LibreOffice?

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to