Line breaks in spreadsheet cells--how to code on server side?

Hi.  I have labels that I'm merging into cells of an ods spreadsheet.  What value or tag can I supply in my source arrays that will result in line breaks in my text?  And is it different for odt or MS Office templates?  Thanks.

Ken

Its is different.
ODT accepts the line break (<text:line-break/>) inside a paragraph, while ODS uses a paragraph for the text in a cell but doesn't accepts the line break.

The workaround is to replace the line-break in your data with a "paragraph break" : </text:p><text:p>

XSLX accepts natural line breaks.

When I try that, the tags don't seem to be interpreted, and just end up as text in my label cell.

For example, I'm aiming for a label that says:
staff
email

But I get this as my text, all on one line:

staff</text:p><text:p>email

Is there a solution to this, or some step I'm missing?

It works with ods files if the cell variable is declared with "strconv=no" param. Example:
then you can send strings to the template as you mentioned  ( staff</text:p><text:p>email )

Also, you can format cells with "Wrap text automatically" (https://help.libreoffice.org/Common/Inserting_Line_Breaks_in_Cells)

Is there a solution to this, or some step I'm missing?

Sorry--I reloaded the page and it posted my question again.  I haven't tried it yet, but thanks in advance for the info!

Hi, did you solve your problem ?