Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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 - click here.

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 - click here.

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. There will be a revision to the extension soon which will correct this and include a slight increase in performance. In the meantime, there is a very simple fix which will allow cells with background colors & hatching as such:

image description

This is a one character change in the code in two locations. From the menu select Tools->Macros->Edit Macros (Preferences for Mac). In "Object Catalog" panel (left pane), under "My Macros & Dialogs" (click + if not expanded) then "CalcHatchCellsLib" then "Module1", Double click "CreateHatchCells". In the right pane is the code:

image description

Scroll down near the end of the SUB and change oRectangle.LayerID = 1 to oRectangle.LayerID = 2. Next do the same in "RebuildHatchFromCells":

image description

Then "Save" and you can now apply hatch patterns to cells even with background colors.

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 - click here.

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. There will be a revision to the extension soon which will correct this and include a slight increase in performance. In the meantime, there is a very simple fix which will allow cells with background colors & hatching as such:

image description

This is a one character change in the code in two locations. From the menu select Tools->Macros->Edit Macros (Preferences for Mac). In "Object Catalog" panel (left pane), under "My Macros & Dialogs" (click + if not expanded) then "CalcHatchCellsLib" then "Module1", Double click "CreateHatchCells". In the right pane is the code:

image descriptionimage description

Scroll down near the end of the SUB and change oRectangle.LayerID = 1 to oRectangle.LayerID = 23. Next do the same in "RebuildHatchFromCells":

image descriptionimage description

Then "Save" and you can now apply hatch patterns to cells even with background colors.

FYI - Layer 1 = background; Layer 2 is where functions are retained. Thus using Layer 3. Don't know of anything else using this layer.

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 - click here.

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. There will be a revision to the extension soon which will correct
At
this and include a slight increase in performance. In the meantime, point there is a very simple fix which will allow cells with no acceptable layer for hatching and cell background colors & hatching as such:color together.

image description

This is a one character change in the code in two locations. From the menu select Tools->Macros->Edit Macros (Preferences for Mac). In "Object Catalog" panel (left pane), under "My Macros & Dialogs" (click + if not expanded) then "CalcHatchCellsLib" then "Module1", Double click "CreateHatchCells". In the right pane is the code:

image description

Scroll down near the end of the SUB and change oRectangle.LayerID = 1 to oRectangle.LayerID = 3. Next do the same in "RebuildHatchFromCells":

image description

Then "Save" and you can now apply hatch patterns to cells even with background colors.

FYI - Layer 1 = background; Layer 2 is where functions are retained. Thus using Layer 3. Don't know of anything else using this layer.

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 - click here.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.