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

New Issue

kklasing · 2023-04-25T14:54:32Z

kklasing commented

2023-04-25 14:54:32 +00:00

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

sheetjs commented

2023-04-25 15:53:00 +00:00

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.

sheetjs referenced this issue from a commit

2023-04-30 07:59:40 +00:00

parse self-closing text:p uof:文本串 (fixes #2927)

sheetjs closed this issue

2023-04-30 07:59:40 +00:00

kklasing commented

2023-05-09 07:23:30 +00:00

Hi @sheetjs ,

Do you know when this change will be released?

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

sheetjs commented

2023-05-09 16:50:17 +00:00