Skip to content

BUG: incorrect handling of line breaks in OdsWriter #55728

@dimastbk

Description

@dimastbk

Pandas version checks

  • I have checked that this issue has not already been reported.

  • I have confirmed this bug exists on the latest version of pandas.

  • I have confirmed this bug exists on the main branch of pandas.

Reproducible Example

df = pd.DataFrame(["test\ntest"])
df.to_excel("test.ods")

Issue Description

<table:table-cell office:value-type="string" office:string-value="test&#10;test"><text:p>test
test</text:p></table:table-cell>

I think, this is a bug in ODSWriter, which should convert \n to text:p. Below are files from popular office applications:

And handlers in some ods readers:

Originally posted by @dimastbk in #53924 (comment)

Expected Behavior

Resave example in LibreOffice:

<table:table-cell office:value-type="string"><text:p>test<text:line-break/>test</text:p></table:table-cell>

Create an example in LibreOffice:

<table:table-cell office:value-type="string"><text:p>test</text:p><text:p>test</text:p></table:table-cell>

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions