Description: Trying to use the function Text to Column from the Menu Data, selecting the String Delimiter as the quotation mark (") and selecting separated by Space, the function does not respect the Delimiter. The Delimiter string should also be removed from the result. Text example: 19/06 “XDGFNSGB WWWWWWWWWW FJVNBSFDGONBSOIGNB” 54,48 Steps to Reproduce: 1.Insert the example text in a cell 2.Open Menu Data and select the function Text to Column 3.In the function interface, select Separated by as Space, select the Delimiter String as the Quotation Mark 4. In the Fields, you will be seeing the wrong behavior. Actual Results: 19/06/20 “XDGFNSGB WWWWWWWWWW FJVNBSFDGONBSOIGNB” 54,48 Expected Results: 19/06/20 XDGFNSGB WWWWWWWWWW FJVNBSFDGONBSOIGNB 54,48 Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Version: 7.0.0.3 (x64) Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: pt-BR (pt_BR); UI: en-US Calc: threaded
Created attachment 164979 [details] Text to column interface showing the bug The picture shows the Text to Column UI and the BUG. When you apply the command, the result is also with the BUG.
In your example the first “ is a U+201C LEFT DOUBLE QUOTATION MARK, not a " U+0022 QUOTATION MARK, so that can not work.
This quotation mark is what my keyboard writes. The Libreoffice was installed without any modification to the settings. What should I do to set the correct configuration?
(Correct status would be to set back to "unconfirmed" if you don't agree with the resolution. as it was never set to "new" nor "fixed") I agree with Eike's comment, the characters don't match, so that can't work. Closing a "resolved - not a bug", but please provide an example file if you still don't agree. (The double quote being converted to a different character depends on where you typed it and what autocorrect rules the software might have)