[Libreoffice-bugs] [Bug 122945] VIEWING: Tab colors of protected worksheets not shown in Excel 2007 spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=122945 --- Comment #10 from Ben Elliston --- I vote for mimicking MS Excel behaviour. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 122945] VIEWING: Tab colors of protected worksheets not shown in Excel 2007 spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=122945
Andreas Heinisch changed:
What|Removed |Added
CC||andreas.heini...@yahoo.de
--- Comment #9 from Andreas Heinisch ---
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.
[Libreoffice-bugs] [Bug 122945] VIEWING: Tab colors of protected worksheets not shown in Excel 2007 spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=122945 --- Comment #8 from ethan young --- Protecting any sheets in an xlsx-formatted file with intact tab colors will also strip it of its tab colors. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 122945] VIEWING: Tab colors of protected worksheets not shown in Excel 2007 spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=122945 --- Comment #7 from ethan young --- I can confirm this bug persists in LO 7.3.2.2 The issue only affects protected sheets in documents saved in xlsx format. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 122945] VIEWING: Tab colors of protected worksheets not shown in Excel 2007 spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=122945 Leroy changed: What|Removed |Added OS|Linux (All) |All Hardware|x86-64 (AMD64) |All -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 122945] VIEWING: Tab colors of protected worksheets not shown in Excel 2007 spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=122945 --- Comment #6 from Leroy --- Also in LibreOffice 6.4.7.2 (x86) and 7.0.2.2 (x64). Do not matter if file is created with Calc or Excel. Unprotected sheet tabs retain its color. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 122945] VIEWING: Tab colors of protected worksheets not shown in Excel 2007 spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=122945 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||113113 --- Comment #5 from Roman Kuznetsov <79045_79...@mail.ru> --- still repro in current 7.1 master Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=113113 [Bug 113113] [META] Sheet tabs bar bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 122945] VIEWING: Tab colors of protected worksheets not shown in Excel 2007 spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=122945 --- Comment #4 from Ben Elliston --- Any progress on this? Thanks. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 122945] VIEWING: Tab colors of protected worksheets not shown in Excel 2007 spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=122945 raal changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #3 from raal --- Confirm. Version: 6.3.0.0.alpha0+ Build ID: 3fa4674615b747e219afe5bf0a9b689df3840439 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: x11; -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 122945] VIEWING: Tab colors of protected worksheets not shown in Excel 2007 spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=122945 Ben Elliston changed: What|Removed |Added Summary|VIEWING: Worksheet tab |VIEWING: Tab colors of |colours not shown in Excel |protected worksheets not |2007 spreadsheet|shown in Excel 2007 ||spreadsheet -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
