Multiple newlines in OSD file cell get parsed to single newline #2927

I am parsing a OSD workbook and one of the cells has multiple lines in it (see image below)

After parsing using

const workBook = XLSX.read(file);

The workbook contains the parsed cell:

Where the multiple newlines are represented by only one \n character.

I was wondering if I am doing something wrong in the parsing, or that I have found an issue here?

I am parsing a OSD workbook and one of the cells has multiple lines in it (see image below) ![image](/attachments/a00d7bac-e641-47f3-8da6-405d9251488c) After parsing using ``` const workBook = XLSX.read(file); ``` The workbook contains the parsed cell: ![image](/attachments/59f4e911-b69f-426c-b35d-0960f0b24bd6) Where the multiple newlines are represented by only one `\n` character. I was wondering if I am doing something wrong in the parsing, or that I have found an issue here?

image.png

4.1 KiB

image.png

7.4 KiB

Thanks for reporting! The empty lines are internally represented as paragraph elements (p in ODS, 文本串 in UOS) with no bodies. Those are currently skipped but should be translated to newline characters.

Thanks for reporting! The empty lines are internally represented as paragraph elements (`p` in ODS, `文本串` in UOS) with no bodies. Those are currently skipped but should be translated to newline characters.

Hi @sheetjs ,

Do you know when this change will be released?

Hi @sheetjs , Do you know when this change will be released?

We're aiming for a release this month. It is unclear whether it will be 0.19.4 or 0.20.0

Labels Milestones

Multiple newlines in OSD file cell get parsed to single newline #2927