I am creating a fillable form using list and combo boxes that are taking entries from spreadsheet. I am trying to figure out if its possible to apply any formatting or line breaks to entries in the list. Some of the entries will be drawing from several cells from the spreadsheet and I want the single list entry to be displayed over multiple lines such as:
A2
B2
C2
Unfortunately my attempts to format in calc such as using “=A2&CHAR(10)&B2&CHAR(10)&C2” don’t transfer to the list box and just comes out as A2B2C2. From what I can tell its only the text box forms that have any options for formatting but not for lists that draw from a spreadsheet. Is there a way to format list box entries?