[Libreoffice-bugs] [Bug 136374] New: Text to column does not respect the Delmiter String when the Separated by Space

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136374

            Bug ID: 136374
           Summary: Text to column does not respect the Delmiter String
                    when the Separated by Space
           Product: LibreOffice
           Version: 7.0.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kschwarz at gmail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200901/e016686f/attachment.htm>