seznam/pyoo

Insert line break in text cell

nektor211 opened this issue · 1 comments

nektor211 commented

Is it possible to insert line break into text cell using pyoo? If so could you please provide an example?

Libre Office relevant page - https://help.libreoffice.org/Common/Inserting_Line_Breaks_in_Cells

nektor211 commented

I've found a solution using a formula:

cell.formula = '=CONCATENATE("{}")'.format('";CHAR(10);"'.join(text.split('\n')))