Custom Cell Background

Discuss the spreadsheet application
Post Reply
Sheffey
Posts: 27
Joined: Sat Mar 29, 2008 8:30 pm

Custom Cell Background

Post by Sheffey »

Hi,

I am wondering if it is possible to create a custom background for a cell or group of cells. Is it possible to insert a photo or file as the backround for a cell?

I searched the forums and didn't find anything on this topic.

Thanks for any help!
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Custom Cell Background

Post by acknak »

Sorry, no. Nothing is supported as a cell background except solid colors.

Support for images or patterns has been requested:
Issue 16642: Allow patterns as cells background
Issue 69092: there is no way to set image as background for cell
You can register there and add your vote (up to two) or comment.
AOO4/LO5 • Linux • Fedora 23
User avatar
RoryOF
Moderator
Posts: 35064
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Custom Cell Background

Post by RoryOF »

If your requirement is static, such as for a name on the image, you could edit it in a drawing program and add the text, then insert the modified image into a cell, if that is possible.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.5 LTS
User avatar
Charlie Young
Volunteer
Posts: 1559
Joined: Fri May 14, 2010 1:07 am

Re: Custom Cell Background

Post by Charlie Young »

I had played around with this a few months ago after someone had asked about hatching cell backgrounds. I never got around to posting it. The attached spreadsheet adds cell "backgrounds" by fitting drawing rectangles to the selected cells and then working with the rectangle area fill, including options for gradient, hatching, and bitmaps. For this to work as expected, some degree of transparency needs to be specified for the area fills. Also, there are issues involved in resizing cells and deleting rows and columns, so this is mostly meant to be suggestive.

Note that options to "Fill Cell Background" and "Clear Cell Background" appear on both the Format Menu and the Cell Selection Context Menu.

Some of the discussion of how this works belongs in the macro forum, but I'll start by posting it here. I haven't carefully reviewed the macros before posting, so there may be some irrelevant crap in there.
Attachments
Fill_Cell_Backgrounds.ods
Cell Backgrounds
(71.04 KiB) Downloaded 572 times
Apache OpenOffice 4.1.1
Windows XP
Post Reply