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

            Bug ID: 172587
           Summary: Chinese text shown garbled (a.k.a. mojibake) in text
                    import dialog preview when pasting unformatted text
           Product: LibreOffice
           Version: 25.8.7.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]
            Blocks: 109239

Created attachment 207553
  --> https://bugs.documentfoundation.org/attachment.cgi?id=207553&action=edit
Screenshot showing garbled text in Text Import dialog

This is a bug forwarded from a Simplified Chinese chat group.

When pasting Chinese text from other applications into LO Calc, usually the
text import dialog is involved. Multiple users say that they occasionally see
garbled text in the preview area of the "Field" section of the dialog. It
doesn't affect the result of pasting, as the pasted text in the cells are still
correct.

Steps to Reproduce:
1. From an application other than LibreOffice (web browser, Windows notepad,
etc.), copy the following example Chinese text (without the quotation marks):
"""
第一季《凡人修仙传:风起天南》 2020年7月25日
特别篇《燕家堡之战》 2021年1月31日
"""
2. Paste it in Calc and make sure to paste as unformatted text (usually Ctrl+V
will do, but can be enforced by selecting Edit > Paste Special > Paste
Unformatted Text).
3. The "Text Import" dialog should open. In the preview area at the bottom, see
the garbled text as if the text encoding is wrong, as shown by the attached
screenshot.

Expected Result:
Legible Chinese text as copied in the preview.

Actual Result:
Garbled text in the preview.

Notes:
1. Not all Chinese text trigger this bug. The example text is provided by one
of the user reporting the problem, and it reliably triggers the bug for
everyone.
2. Multiple users reproduce this bug on both Linux and Windows, so setting the
"OS" field as "All".
3. Adding random English characters in front of the Chinese text, such as
"""
aa第一季《凡人修仙传:风起天南》 2020年7月25日
aa特别篇《燕家堡之战》 2021年1月31日
"""
no longer triggers the bug.

Version Information:
I can reproduce with both 25.8.7 and 26.8 Beta1 on Windows 11 25H2:
Version: 25.8.7.3 (X86_64)
Build ID: 30742500f2d3eb4366ac312fa33d3dcabdb3eba5
CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster;
VCL: win
Locale: zh-CN (en_US); UI: en-US
Calc: CL threaded
and
Version: 26.8.0.0.beta1 (X86_64)
Build ID: c134df25b92c3052b7df95cfa5a66e061f9c2664
CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Vulkan;
VCL: win
Locale: en-US (en_US); UI: zh-CN
Calc: CL threaded


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=109239
[Bug 109239] [META] CSV / TSV / Text Import and export / Text to Columns
dialogs bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to