Ask Your Question

DEKKA129's profile - activity

2017-02-21 00:02:54 +0200 commented answer Hatching for cells not found in Calc 5.0.4

You're very welcome.

Actually, I just tried one more thing. I added hatching to an empty cell, then added a background color (hatching disappeared, as before) and then highlighted the same cell and selected "no fill" as the new background color. The hatching was indeed still under there.

So you're right. Rather than the background color actually overriding the hatching, it's simply covering the hatching with a new layer. Same result when adding hatching to a cell that already has a bg color.

2017-02-20 23:36:41 +0200 commented answer Hatching for cells not found in Calc 5.0.4

(By the bye, this was all done in Windows 10 using LibreOffice version 5.2.5.)

2017-02-20 23:34:58 +0200 commented answer Hatching for cells not found in Calc 5.0.4

I did a little more experimentation, and I figured out the issue.

I was trying to apply hatching to cells with background colors, and it looks like that's a no-go. Empty cells or cells with text and no background color, no problem. But cells with background color don't take the hatching, and adding background color to a cell that already contains hatching results in the color overriding the hatching.

In other words, I was doing it wrong. ;^)

Thanks again!

2017-02-20 22:01:55 +0200 commented answer Hatching for cells not found in Calc 5.0.4

Thanks so much for putting this extension together! It'll really be of help.

One question, though. I've downloaded and added the extension, and everything works just as the instructions say, except... when I click "Insert Hatch In Selected Cells" it doesn't insert the hatch pattern. Also, after I click "Insert..." the red text at the top of the dialog box displays "Ready for Processing" instead of "Ready for Selection."

Any idea what might not working properly (or what I might be doing wrong?)