I can change the cell background that appears when I'm entering data by setting:
Tools - LibreOffice - Application Colors - Document Background - Green
We don't want the cell color to be green or any other solid color, we want to see the image under the cell while we type. For this example, I set the Document Background to Green. In the case shown, we can't tell what the value on the image is until we finish entering the data. If we make a mistake, we have to go back and correct the value. If we could see the image as we type, we would be less likely to make an error.
Steps to Reproduce:
1. Have a background image of tabular data
2. Start entering the data in a cell.
The cell turns a solid color, obscuring the image underneath
Requested results: the image remains visible in the cell as you type
User Profile Reset: No
See my question here which has shows an image:
Created attachment 172651 [details]
Image of the Calc page with a background image of tabular data.
If the cell background is transparent then the document background colour is taken for visibility. That could be made an option.
I assume you do Insert > Image and Format > Arrange > To Background to make it appear behind the editable cells (with access later via the Navigator). Whether the document background is the automatic default or any user defined color does not affect the transparency (or rather opacity), but the goal is to show the background anyway.
I would prefer a different workflow with Format > Page Style and a background image. This image is currently only shown in the preview but I could imagine to have it also in edit mode - users who prefer the current behavior could use a background color for cells. Either changing the page style or an option to not print the background could be handy for printing.
Using Tools - LibreOffice - Application Colors - Document Background has the disadvantage to be also effective in other modules like Writer.
Created attachment 187320 [details]
Background image via page style
Example showing also some other issues: a) to cover the background image cells with content need some background color (could be done automatically with a macro), b) empty cells are not added to the printout and the background image is cut-off (could be solved by explicitly setting a grid color).
(In reply to Heiko Tietze from comment #3)
> I assume you do Insert > Image and Format > Arrange > To Background to make
> it appear behind the editable cells (with access later via the Navigator).
> Whether the document background is the automatic default or any user defined
> color does not affect the transparency (or rather opacity), but the goal is
> to show the background anyway.
> I would prefer a different workflow with Format > Page Style and a
> background image. This image is currently only shown in the preview but I
> could imagine to have it also in edit mode - users who prefer the current
> behavior could use a background color for cells. Either changing the page
> style or an option to not print the background could be handy for printing.
> Using Tools - LibreOffice - Application Colors - Document Background has the
> disadvantage to be also effective in other modules like Writer.
This is a chunk of our macro that loads the image.
' Get graphic using Dispatcher; code from macro recorder
' Direct URL retrieval methods do not fail gracefully
args1(0).Name = "FileName"
args1(0).Value = imgURL
args1(1).Name = "FilterName"
args1(1).Value = "<All formats>"
args1(2).Name = "AsLink"
args1(2).Value = false
dispatcher.executeDispatch(document, ".uno:InsertGraphic", "", 0, args1())
' Get image as object for manipulation
imgCount = DrawPage.Count
flagFound = False
' Search for proper image
For x = 0 To imgCount-1
objImage = DrawPage.getByIndex(x)
If objImage.Name = "Image 1" Then
' Image found
objSize = objImage.getSize
newWidth = (objSize.width)*imgScale
newHeight = (objSize.height)*imgScale
' Set new dimensions
objSize.width = newWidth
objSize.height = newHeight
' Image enhancements
If EnhanceFlag = "Y" Then
If Brightness <> 0 Then objImage.AdjustLuminance = Brightness
If Contrast <> 0 Then objImage.AdjustContrast = Contrast
If Gamma <> 0 Then objImage.Gamma = Gamma
If ColorMode = "C" Then
objImage.GraphicColorMode = com.sun.star.drawing.ColorMode.STANDARD
If ColorMode = "G" Then
objImage.GraphicColorMode = com.sun.star.drawing.ColorMode.GREYS
' Get crop properties and validate
Cell = Doc.Sheets.GetByName("Setup").getCellRangeByName("Crop")
CropFlag = Cell.String
CropFlag = UCase(Left(CropFlag, 1))
If (CropFlag <> "Y") and (CropFlag <> "N") Then
GoToNamedCell("Setup", "Crop", 1, 1)
MsgBox "Enter Yes or No in the Crop Image Cell to indicate" + CHR$(10) +_
"whether you want the image cropped."
If (CropFlag = "Y") Then
objImage = Crop_Image(ObjImage, imgScale)
' Image found - background LayerID = 1, foreground LayerID = 0
objImage.LayerID = 1
flagFound = True
Whether you insert an image (manually or per macro) or use the page style (wouldn't be shown yet) or cell style (has no image option yet), if the cell has a background image the edit mode should use a transparent background.
Easy hackable, Eike?