-
-
Notifications
You must be signed in to change notification settings - Fork 18.7k
Open
Labels
Description
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 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:
- https://git.sheetjs.com/sheetjs/sheetjs/src/branch/master/bits/80_parseods.js#L606
- https://github.com/miachm/SODS/blob/master/src/com/github/miachm/sods/OdsReader.java#L502
- https://github.com/ropensci/readODS/blob/7548c3ab8778efc2d6058fc56ca84920b2e3a92f/src/read_ods_internals.cpp#L43
- https://github.com/tafia/calamine/blob/master/src/ods.rs#L561
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>