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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
