Skip to content
This repository has been archived by the owner on Jul 22, 2022. It is now read-only.

New line in a cell with more than 255 characters #323

Open
duanyukai opened this issue Oct 15, 2020 · 0 comments
Open

New line in a cell with more than 255 characters #323

duanyukai opened this issue Oct 15, 2020 · 0 comments

Comments

@duanyukai
Copy link

I've found this tricky way to insert new line in a cell with excel4node.
ws.cell(1, 1).formula('="first line"&CHAR(10)&"second line"');
But when the cell has more than 255 characters, the cell content disappeared.
Though I can split the text and use CONCATENATE, but is there an more elegant way to insert a long piece of text with new line?

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant