Ask Your Question

How do I design a drop-down box that will displays symbols instead of only rectangles? [closed]

asked 2015-10-20 03:32:22 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Software: LibreOffice Calc OpSys: Windows 8.1

I have a drop-down box in the spreadsheet and I'm using enclosed alphanumeric numbers ( with the circle around them ) as well as chess symbols. I can get them to show up just fine in the spreadsheet, as those cells are formatted to WingDings font, and I can select them to show up.

The trouble is, the drop-down box only displays rectangles or dots instead of the symbols. Once selected, they show up OK, but you can't recognise them in the drop-down box.

I also tried using MS Arial Unicode, but still have the same problem?

Does anyone have a fix for this?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-16 13:32:19.537908

2 Answers

Sort by » oldest newest most voted

answered 2015-10-23 17:57:24 +0200

Amalit gravatar image

This actually started working all on its own.

The next day, after I reopened Calc and started playing around with it again, they just started showing up. Interestingly, I think this is the second time something like this has happened when I'm doing something new in LibreOffice; I think maybe it just needs to 'update' or something. So either switching tabs or closing and reopening might give it time to do that and change the display.

I had something similar happen last month when I was programming a bunch of pie charts and functions into a souped-up spreadsheet.'s like a piece of hardware--try turning it off and turning it back on again, lol.

edit flag offensive delete link more

answered 2015-10-21 01:03:43 +0200

m.a.riosv gravatar image

If you are talking about Data/Validity, please find attached a sample file, works for me with a list or with a cell range.DataValidityWithSymbols.ods, symbols were introduced with Insert/special character.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-10-20 03:32:22 +0200

Seen: 271 times

Last updated: Oct 21 '15