Created attachment 162087 [details] Image of 'bug' Text to Columnns in .xlsx spreadsheet is not functioning as I'd expect it to. I'm trying to parse out a set of records, using a comma separator. After selecting the cells and then selecting Data>Text to Columns I then select the comma as the separator of choice. The records all merge into one cell. This is one of several unexpected behaviours with this function. Image of 'bug' attached.
Please attach a sample file for test.
File sent by return email. Not sure how to do it via this page.(In reply to m.a.riosv from comment #1) > Please attach a sample file for test. (In reply to m.a.riosv from comment #1) > Please attach a sample file for test.
(In reply to Gordon Dudley Bossley from comment #2) > File sent by return email. Not sure how to do it via this page.(In reply to > m.a.riosv from comment #1) > > Please attach a sample file for test. As you attach the screenshot. On the top of the comments. I'm not able to reproduce your issue. Seems the new line it's not recognized. Please test with a clean profile Menu/Help/Restart in Safe Mode.
Created attachment 162144 [details] Sample file File att.
Created attachment 162145 [details] working well Version: 6.4.4.2 (x64) Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: GL; VCL: win; Locale: ro-RO (ro_RO); UI-Language: en-US Calc: threaded
Fine for me. Versión: 6.4.5.1 (x64) Id. de compilación: be964ce243d03404cfeed53d0487f5d6bd49c627 Subprocs. CPU: 4; SO: Windows 10.0 Build 19608; Repres. IU: GL; VCL: win; Configuración regional: es-ES (es_ES); Idioma de IU: es-ES Calc: threaded
(In reply to m.a.riosv from comment #3) > Please test with a clean profile Menu/Help/Restart in Safe Mode. Gordon: you did not mention, if you tried this. I can't reproduce the problem either Arch Linux 64-bit Version: 7.1.0.0.alpha0+ Build ID: 54e1e5f597705a1244701c75233a2c3a68a7d844 CPU threads: 8; OS: Linux 5.8; UI render: default; VCL: kf5 Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 9 October 2020
Dear Gordon Dudley Bossley, 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
Dear Gordon Dudley Bossley, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp