How to fix an error when shaping Excel through EPPlus?

Question

C++ / C#

The essence of the error when filling out the cell is making a transfer When opening Excel, the text is written in one line until the cell is edited. If you put the cursor in a cell, then the text in the line form is displayed in 2 lines. At the same time, LibreOffice Calc opens as expected.sheet.Cells[row, col].Value = "Вх. №\r\nВх. Дата";

Answer 1

Try to specify Style.WrapText = true for the cell