Description: With autocorrect options disabled, as much as is possible, pasting of formulas still seems to force fractions and breaks the formulas - and in a way that cannot be easily worked around. Steps to Reproduce: Paste from a plain text file "=1/2" to any cell on a new file, with the format already then number:general Actual Results: see then "=1⁄2" is made with a Unicode fraction slash U+2044 and not the usual solidus U+002F and some zero width space U+200B has been introduced as a prefix, which stops it as a formula. Expected Results: expected formula to action as 0.5 or worst case default as text but not badly translated. Reproducible: Always User Profile Reset: No Additional Info: Repeat this with " =0+1⁄2 =9+1/2 " to see the oddity also that =9+1/2 works - so "=0+" is not a workaround. ------------------- [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes
Copying from you comment and pasting in a new spreadsheet works fine for me. Version: 7.0.5.0.0+ (x64) Build ID: e29387a749edb1bf39ca2b558099964da42b3a4b CPU threads: 4; OS: Windows 10.0 Build 21296; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 86c8c775bbefe333d684e12c99855a3c1de68051 CPU threads: 4; OS: Windows 10.0 Build 21296; UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL Please detail your steps to paste, if using paste unformatted text or any other way.
Copying from my comment =1/2 and pasting in a new spreadsheet, does reproduce this 7.0.4.2 Perhaps is and obvious bug already fixed, if you're on a later version. I do the [Help].[Check for updates]="LibreOffice 7.0 is up to date." and I'd rather stick to stable versions.
[Automated Action] NeedInfo-To-Unconfirmed
Not reproduced. Arch Linux 64-bit Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: ac21d937690c1ef995df22e11384e0fab226472e CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 2 December 2021 Please copy and paste here the contents of your Help - About. This allows us to know more about your system. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the information.
Dear davidpbrown, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Closing - seems fixed