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: .
Created attachment 198255 [details] stdout/stderr log
Hello Jim Avera, Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public; remove any sensitive information before attaching it. See <https://wiki.documentfoundation.org/QA/FAQ#sanitize> for help on how to do so.)
P.S. I don't think this is specific to Google Docs: I tried sanitizing the spreadsheet, preserving all the embedded newlines, then importing into Google Docs and then downloading from Google to .xlsx -- but LO had not trouble reading that .xlsx (except for some unrelated warnings). --> If the problem was related to how Google Docs exports to .xlsx then this sanitized spreadsheet would probably have exhibited the problem.
@BogdanB -- Please suggest a procedure for removing the confidential information. If you haven't already done so, please read the problem description to see what I already tried.
Ok, since .xlsx is a zipped collection of xml files, I wrote a script to unzip and clobber as much as I can of the confidential bits. After re-zipping, the problem still occurs when opening the result, so it is a good test case. Note that if the file is opened in LO and saved, the resulting file (regardless of what edits if any were done) will not reproduce the problem.
Created attachment 198258 [details] Demo spreadsheet
With debug version of LibreOffice I am getting: warn:vcl.gtk:3847:3847:vcl/unx/gtk3/fpicker/SalGtkFilePicker.cxx:950: no parent widget set warn:legacy.tools:3847:3982:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.tools:3847:3982:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.tools:3847:3982:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.tools:3847:3982:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.tools:3847:3982:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.tools:3847:3982:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:oox:3847:3980:oox/source/helper/progressbar.cxx:67: ProgressBar::setPosition - invalid position warn:oox:3847:3980:oox/source/helper/progressbar.cxx:67: ProgressBar::setPosition - invalid position warn:oox:3847:3980:oox/source/helper/progressbar.cxx:67: ProgressBar::setPosition - invalid position warn:legacy.tools:3847:3982:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.tools:3847:3982:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.tools:3847:3982:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.tools:3847:3982:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.tools:3847:3982:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.tools:3847:3982:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.tools:3847:3982:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:oox:3847:3983:oox/source/helper/progressbar.cxx:67: ProgressBar::setPosition - invalid position warn:oox:3847:3983:oox/source/helper/progressbar.cxx:67: ProgressBar::setPosition - invalid position warn:oox:3847:3983:oox/source/helper/progressbar.cxx:67: ProgressBar::setPosition - invalid position warn:oox:3847:3982:oox/source/helper/progressbar.cxx:67: ProgressBar::setPosition - invalid position warn:oox:3847:3982:oox/source/helper/progressbar.cxx:67: ProgressBar::setPosition - invalid position warn:oox:3847:3982:oox/source/helper/progressbar.cxx:67: ProgressBar::setPosition - invalid position warn:legacy.osl:3847:3847:editeng/source/editeng/impedit2.cxx:2915: FastInsertText: Newline not allowed! warn:legacy.tools:3847:3847:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.osl:3847:3847:editeng/source/editeng/impedit2.cxx:2915: FastInsertText: Newline not allowed! warn:legacy.tools:3847:3847:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.osl:3847:3847:editeng/source/editeng/impedit2.cxx:2915: FastInsertText: Newline not allowed! warn:legacy.tools:3847:3847:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.osl:3847:3847:editeng/source/editeng/impedit2.cxx:2915: FastInsertText: Newline not allowed! warn:legacy.tools:3847:3847:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.osl:3847:3847:editeng/source/editeng/impedit2.cxx:2915: FastInsertText: Newline not allowed! warn:legacy.tools:3847:3847:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.osl:3847:3847:editeng/source/editeng/impedit2.cxx:2915: FastInsertText: Newline not allowed! warn:legacy.tools:3847:3847:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.osl:3847:3847:editeng/source/editeng/impedit2.cxx:2915: FastInsertText: Newline not allowed! warn:legacy.tools:3847:3847:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.osl:3847:3847:editeng/source/editeng/impedit2.cxx:2915: FastInsertText: Newline not allowed! warn:legacy.tools:3847:3847:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.osl:3847:3847:editeng/source/editeng/impedit2.cxx:2915: FastInsertText: Newline not allowed! warn:legacy.tools:3847:3847:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.osl:3847:3847:editeng/source/editeng/impedit2.cxx:2915: FastInsertText: Newline not allowed! warn:legacy.tools:3847:3847:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.osl:3847:3847:editeng/source/editeng/impedit2.cxx:2915: FastInsertText: Newline not allowed! warn:legacy.tools:3847:3847:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.osl:3847:3847:editeng/source/editeng/impedit2.cxx:2915: FastInsertText: Newline not allowed! warn:legacy.tools:3847:3847:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! warn:legacy.osl:3847:3847:editeng/source/editeng/impedit2.cxx:2915: FastInsertText: Newline not allowed! warn:legacy.tools:3847:3847:editeng/source/editeng/editdoc.cxx:1018: EditDoc::InsertText: Newlines prohibited in paragraph! Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: a3b0ef4088183c4a3b2ec3fef08ef91314eaef54 CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
Unrelated to Google Sheets (not "Docs", as in comment 0); unrelated to "older" XLSX. May be reproduced from scratch using MS Excel: In Excel, create a cell with two paragraphs (when typing there, use Alt+Enter to add a new line inside a cell). After that, open that cell's format properties, and uncheck "Wrap text" on Alignment tab. Save as XLSX. This file will show the warning in LibreOffice.
Related to commit b224e450d09a0405043a011d48f4f57e88cdc344, where the loading of multiline text was fixed.
Also: I can't confirm the "If the .xlsx is read and then immediately saved (making no changes), the saved spreadsheet does not produce these warnings when reloaded". Testing with Version: 25.2.0.1 (X86_64) / LibreOffice Community Build ID: ddb2a7ea3a8857aae619555f1a8743e430e146c9 CPU threads: 24; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win Locale: de-DE (ru_RU); UI: en-US Calc: CL threaded I see the warnings after save-in-Calc-and-reload.