Created attachment 199013 [details] Demonstration video To reproduce: 1. In calc, expand the formula bar widget to multi-line mode 2. Write a complex formula with line breaks for readability, such as: = IF( ISBLANK(col_col_tip_amount); col_amount_paid / (1 + federal_tax + state_tax) * federal_tax; col_amount_paid / (1 + federal_tax + state_tax) / (1 + tip_rate) * federal_tax) 3. Select all within the formulabar editing textfield widget, Copy 4. Select another cell, then click the formulabar's editing textfield 5. Paste the multiline formula Result: it's all on one line, as you can see in the attached demonstration video. --------- Tested on: Version: 25.2.0.3 (X86_64) / LibreOffice Community Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069 CPU threads: 8; OS: Linux 6.12; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Flatpak Calc: threaded
Reproducible with: Version: 24.2.7.2 (X86_64) / LibreOffice Community Build ID: ee3885777aa7032db5a9b65deec9457448a91162 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: es-MX (es_ES); UI: en-US Calc: CL threaded "formula bar widget" = input line There is no problem if the formula is pasted in a cell in edit mode.
*** This bug has been marked as a duplicate of bug 147480 ***
Not sure if a duplicated, since bug 147480 is about pasting in Writer. The new lines don't hold with Versión: 6.4.7.2 (x64) Id. de compilación: 639b8ac485750d5696d7590a72ef1b496725cfb5 Subprocs. CPU: 4; SO: Windows 10.0 Build 17763; Repres. IU: predet.; VCL: win; Configuración regional: es-AR (es_AR); Idioma de IU: es-ES Calc: threaded