https://bugs.documentfoundation.org/show_bug.cgi?id=164454
Bug ID: 164454
Summary: Loading older .xlsx warn "Newlines prohibited in
paragraph!"
Product: LibreOffice
Version: 25.2.0.0 alpha0+
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
With latest master, opening certain .xlsx spreadsheets exported from Google
Docs which contain line breaks within cells generates many messages like:
warn:legacy.osl:110321:110321:editeng/source/editeng/impedit2.cxx:2838:
FastInsertText: Newline not allowed!
warn:legacy.tools:110321:110321:editeng/source/editeng/editdoc.cxx:1031:
EditDoc::InsertText: Newlines prohibited in paragraph!
--> If the .xlsx is read and then immediately saved (making no changes), the
saved spreadsheet does not produce these warnings when reloaded.
Therefore it seems like the import or export process "fixes" whatever causes
the problem.
Unfortunately new spreadsheets downloaded from Google Docs continue to display
this problem. I am seeing this on a personnel data sheet which for obvious
reasons I can't attach for analysis. So no test case!
I'm reporting this because it affects production spreadsheets which come from
Google Docs, and the problem is unlikely to be noticed during normal testing
because (as noted above), the problem is "fixed" when a sheet is imported or
exported from/to .xlsx
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 2305fe302e12c4256e452589e2533772d4213e59
CPU threads: 12; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Steps to Reproduce:
1. As noted, I'm unable to provide a good test case because the act of editing
the spreadsheet to remove confidential data and saving it seems to 'fix' the
problem (sorry)
2.
3.
Actual Results:
See attached log file
Expected Results:
Silence on stdout/stderr absent a problem the user must respond to.
Reproducible: Always
User Profile Reset: No
Additional Info:
.
--
You are receiving this mail because:
You are the assignee for the bug.
