Bug 153316

Summary: Tabs replaced with SOH character in multi-line text
Product: LibreOffice Reporter: a19lhu
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: ilmari.lauhakangas
Priority: medium Keywords: bibisected, bisected, regression
Version: 6.2.0.3 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By: Luboš Luňák
Bug Depends on:    
Bug Blocks: 108252    
Attachments: Libre calc auto add/convert tab space to SOH

Description a19lhu 2023-02-02 05:38:59 UTC
Created attachment 185056 [details]
Libre calc auto add/convert tab space to SOH

I copy (ctrl + c) some VB code (with tab space in some line)

EX:
if isnull(ld_menu) or ld_menu = 0 then
else
select menu_name,menu_ename
into   :ls_menu_name,:ls_menu_en
from   sy_menus
where  menu_id = :ld_menu;
if ls_menu_en <> '' then
dw_100.object.st_100.text = ls_menu_name
dw_100.object.st_101.text = ls_menu_en
end if
end if

then open Libre cacl, dupble click a cell -> paste (ctrl +v).

I copy that cell, paste to VB script editor, and the scipt cannot run.
For check, i paste to Notepad++, and found some special charater (SOH) cause the problem. Please refer the picture.
Please help me to check this.

Thanks and best regards.
Comment 1 Werner Tietz 2023-02-02 18:53:57 UTC
Cannot help why this happens, but how to fix it in basic-ide:

→Edit→Search&replace:
search for  ( i typed <ctrl><shift>u1 )
replace with <tab>
Comment 2 Buovjaga 2023-03-23 08:37:55 UTC
https://en.wikipedia.org/wiki/C0_and_C1_control_codes#SOH

Bibisected with linux-64-6.2 to fb32f28a2b7f0c33533592b855ead127b858040c
avoid using EditEngine in ScEditUtils::GetString() if possible

I pasted to Notepad++ in a Windows VM for testing to see the SOH chars.
I made my own piece of text with tabs at the beginning of lines.