Bug 153316 - Tabs replaced with SOH character in multi-line text
Summary: Tabs replaced with SOH character in multi-line text
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Calc-Cells
  Show dependency treegraph
Reported: 2023-02-02 05:38 UTC by a19lhu
Modified: 2023-03-23 08:37 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Libre calc auto add/convert tab space to SOH (179.55 KB, image/jpeg)
2023-02-02 05:38 UTC, a19lhu

Note You need to log in before you can comment on or make changes to this bug.
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)

if isnull(ld_menu) or ld_menu = 0 then
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:

search for  ( i typed <ctrl><shift>u1 )
replace with <tab>
Comment 2 Buovjaga 2023-03-23 08:37:55 UTC

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.