# How to put text and value in relatorio ODS

**URL:** https://discuss.tryton.org/t/how-to-put-text-and-value-in-relatorio-ods/1936
**Category:** User
**Tags:** relatorio
**Created:** [November 12, 2019, 9:02am UTC](https://discuss.tryton.org/t/how-to-put-text-and-value-in-relatorio-ods/1936 "2019-11-12T09:02:40Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![risto3](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/r/a87d85/32.png) [@risto3](https://discuss.tryton.org/u/risto3)
#### Post date: [November 12, 2019, 9:02am UTC](https://discuss.tryton.org/t/how-to-put-text-and-value-in-relatorio-ods/1936/1 "2019-11-12T09:02:40Z")

</div>

There seems to be limitation in ODS template, if my testing is correct.

In a single cell I try to put some text followed by the relatorio link, literally the translation from (fodt):

> \<text:p text:style-name=“Header”\>Company: \<text:placeholder text:placeholder-type=“text”\>\<company.rec\_name\>\</text:placeholder\>\</text:p\>

to (fods):

> \<table:table-cell office:value-type=“string” calcext:value-type=“string”\>text:p\<text:span text:style-name=“T1”\>Company:\</text:span\> \<text:a xlink:href=“relatorio://company.rec\_name” xlink:type=“simple”\>company.rec\_name\</text:a\>\</text:p\>

But only the company name is printed in the cell, without the ‘Company:’ label.

Is this not a bug? Is there not a work-around?

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [November 12, 2019, 12:42pm UTC](https://discuss.tryton.org/t/how-to-put-text-and-value-in-relatorio-ods/1936/2 "2019-11-12T12:42:49Z")

</div>

For me, it was fixed by [Tryton / Relatorio · GitLab](https://relatorio.tryton.org/bug42)  
If you do not think so, please create a bug on [relatorio.tryton.org](http://relatorio.tryton.org) with a running example exposing the issue.

---

<div class="post-metadata">

### Author: ![risto3](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/r/a87d85/32.png) [@risto3](https://discuss.tryton.org/u/risto3)
#### Post date: [November 13, 2019, 10:38am UTC](https://discuss.tryton.org/t/how-to-put-text-and-value-in-relatorio-ods/1936/3 "2019-11-13T10:38:40Z")

</div>

okay, I filed [Tryton / Relatorio · GitLab](https://relatorio.tryton.org/bug56)
