In Calc, the background can only be set to some fill color.
There seems to be no way to specify a fill pattern e.g. hatching (like in Excel, sorry to compare)
Steps to Reproduce:
1.Open any spreadsheet with Calc (ods or xls)
2.Select any cell
3.Right-click to format
4.Select Background tab
No way to choose a fill pattern
A tab (or a part of the background tab) with a choice of fill patterns (lines, diamonds, dots, ...) with their own background and foreground colors.
User Profile Reset: No
The new cell background was changed in https://cgit.freedesktop.org/libreoffice/core/commit/?id=76d9d6c9bf0167d4203d7e2f6867254687915caa
@Jim, Any opinion here?
There is an extension for that:
I have downloaded "CalcHatchCells-L-1.2.1.oxt" and tried to install the hatch-patter-for-cells extension on my dualboot 64 bits laptop.
When logged under Linux Mint either as user or administrator, the extension does not install with the extension manager. The message box says: "Failed to register package for vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/lu1737bspybr.tmp_/CalcHatchCells-L-1.2.1.oxt/python1/"
When logged under Windows 7 as user, the extension does install with the extension manager, but is not functional. There is no obvious way for the user to add a fill pattern to a cell. If the workbook has been created with Excel (sorry!) and the cell does have a fill pattern, then the cell appears with a background color and no pattern.
(In reply to Pierre from comment #3)
> When logged under Windows 7 as user, the extension does install with the
> extension manager, but is not functional. There is no obvious way for the
> user to add a fill pattern to a cell. If the workbook has been created with
> Excel (sorry!) and the cell does have a fill pattern, then the cell appears
> with a background color and no pattern.
Works for me on Linux. It by default shows a floating toolbar. You can (de)activate it from View - Toolbars - Hatch cells.
"Insert Hatch in Selected Cells" in the dialog does the trick.
Arch Linux 64-bit
Build ID: 51e6a95757906dff8b2819a4141bf3dc7938e95f
CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3_kde5;
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Built on 24 November 2018
Unless we have a reason not to do it, let's accept this as an enhancement.
With no promises or expectations that it will be solved, except by a volunteer.
*** This bug has been marked as a duplicate of bug 31205 ***