Two lines of content in the same cell. ALT + Enter Type content supported with ExcelPackage?

Topics: Developer Forum, User Forum
Feb 6, 2008 at 5:08 PM
Thanks for the amazing project. I’m trying to generate Excel Files on the server and this product is really helpful. Everything seems to work fine for me but I’m running into a small problem which I describe below.

In excel I can hit <ALT>+<ENTER> to add a new line within a cell. So I could actually have content like:
“Line1
Line2”

The same cell can contain two lines of text. Excel seems to treat this quite differently when I looked at the Open XML. Does ExcelPackage allow adding such content to a cell? If not, are there any workarounds?

Again, thanks for the great work on this project!
Jun 27, 2008 at 7:54 PM
I didn't see any difference in the shared string table for a multiline string. Can you give an example?