Ask Your Question
1

Hatching for cells not found in Calc 5.0.4

asked 2016-05-12 03:52:45 +0100

konsultor gravatar image

Want to cross-hatch a range of cells in Calc. Docs for ver. 3 say there is such a feature, but can't find it in version 5.0.4 distributed with openSuse 42.1. Is hatching no longer available or did my install go wrong and omit some files? Where would I look to confirm?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
2

answered 2016-06-29 16:29:05 +0100

Ratslinger gravatar image

updated 2017-02-22 04:45:49 +0100

Because of this post I have found a way to insert hatch patterns onto the draw page :

image description

I packaged it up and it is now available, if interested, in LO Extensions - see below

Edit 2/20/2017:

It has been mentioned that the hatch is not visible when a cell background color is applied. This is true because of layering.
At this point there is no acceptable layer for hatching and cell background color together.

Edit 2/22/2017 - Release 1.1.0 with background colors available - click here.

edit flag offensive delete link more

Comments

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

DEKKA129 gravatar imageDEKKA129 ( 2017-02-20 22:01:55 +0100 )edit

After clicking "Insert Hatch In Selected Cells" just below that what is displayed next to "Hatch Cells Applied =". If the number is greater than 0 maybe the "Transparency" is set too high to easily see. Message at top should be either "Ready for Processing" or "Please wait while request is processing". Cell selection can only occur when dialog is closed. Will correct with next revision (minor performance change soon). If further problems please state OS & LO version.

Ratslinger gravatar imageRatslinger ( 2017-02-20 23:01:23 +0100 )edit

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!

DEKKA129 gravatar imageDEKKA129 ( 2017-02-20 23:34:58 +0100 )edit

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

DEKKA129 gravatar imageDEKKA129 ( 2017-02-20 23:36:41 +0100 )edit

Thank you for the information. I will look into this. Possibly a layering situation not previously considered.

Ratslinger gravatar imageRatslinger ( 2017-02-20 23:38:47 +0100 )edit

@DEKKA129 I have found the solution and will edit my answer with a temporary fix. Thank you again.

Ratslinger gravatar imageRatslinger ( 2017-02-21 00:00:17 +0100 )edit

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.

DEKKA129 gravatar imageDEKKA129 ( 2017-02-21 00:02:54 +0100 )edit

@DEKKA129 - Sorry but layering is not the answer. Other layers available are not acceptable for this purpose. There is, however, background color available in hatching itself. Have an idea on how to accomplish by utilizing existing background color. Will develop and post with result in day or two.

Ratslinger gravatar imageRatslinger ( 2017-02-21 04:16:18 +0100 )edit

Current URL for the extension is https://extensions.libreoffice.org/ex...

Mike Kaganski gravatar imageMike Kaganski ( 2017-02-21 07:59:51 +0100 )edit

@Mike Kaganski - Thank You.

@DEKKA129 Have posted updated extension which covers background colors. Instructions are on the page itself. Site updated since last used. Will figure out how to post actual document then. Here is the link for release 1.1.0 - click here.

Ratslinger gravatar imageRatslinger ( 2017-02-22 04:31:38 +0100 )edit
0

answered 2016-05-12 13:58:49 +0100

m.a.riosv gravatar image

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2016-05-12 03:52:45 +0100

Seen: 535 times

Last updated: Feb 22 '17