Ask Your Question

How to set up a formatted output from data

asked 2018-11-08 12:18:07 +0100

maydin gravatar image

updated 2018-11-08 12:19:01 +0100

Sorry for title, i am really bad at paraphrasing and terms.

I have data in Calc Spreadsheet, lets say column names are "Name, Phone, Adress".

I want to prepare a text depends on data in my sheet. For example I will choose a name from dropdown and it automatically prepare text as follows:

Hello Dear NAME,

Your message has been sent to phone number PHONE and related document will be posted to this adress: ADRESS

In this text I want to specify its format too, for example boldness, font etc. Because I want to copy this to an email body or printing.

I can do something like ="Hello Dear " & A2 but I cannot change style of cell part and cannot copy to somewhere else. (It copies as table)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-11-10 20:28:43 +0100

erAck gravatar image

You can't define inline text attributes in spreadsheet fomulas.

I guess you want to use Writer instead and do something like mail merge, see online help.

edit flag offensive delete link more


Thanks @erAck. This was what I exactly want. But there is a one thing that I cannot fix.

In Calc, I filled cell like this "- option1 <ctrl+enter> - option2". I use this information in Writer document and it looks okay. But problem is when I want to copy texts to e-mail editor, it deletes my "newline characters".

I cannot use bulleted/numbered lists in Calc, therefore I typed newline character by pressing Ctrl+Enter, everything okay until I copy to browser email editor.

maydin gravatar imagemaydin ( 2018-11-15 15:57:35 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-11-08 12:18:07 +0100

Seen: 25 times

Last updated: Nov 10 '18