Bug 148689 - [FILEOPEN] "Symbolic Link" SLK / SYLK trigrams
Summary: [FILEOPEN] "Symbolic Link" SLK / SYLK trigrams
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Cells
  Show dependency treegraph
 
Reported: 2022-04-20 16:18 UTC by SheetJS
Modified: 2023-06-05 15:33 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
printscreen from excel (8.83 KB, image/png)
2022-07-15 06:13 UTC, raal
Details

Note You need to log in before you can comment on or make changes to this bug.
Description SheetJS 2022-04-20 16:18:59 UTC
Description:
Trigrams matching the pattern /\x1B[\x20-\x2F][\x30-\x3F]/ are decoded into a single byte whose high bits are taken from the second character and whose low bits are taken from the third character.

In specific, LO does not understand the trigram \x1B\x20\x3d -> "\r"

Steps to Reproduce:
https://raw.githubusercontent.com/SheetJS/test_files/master/crlf/crlf.slk (download and open)

Actual Results:
Cell value is `abc =
def`


Expected Results:
Cell value should be "abc\r\ndef" (where "\r" is the ASCII character 0x0d and "\n" is the ASCII character 0x0a)


Reproducible: Always


User Profile Reset: Yes



Additional Info:
The "\r" character can be forced in Excel by using the formula function CODE(13)
Comment 1 raal 2022-07-15 06:13:27 UTC
Created attachment 181271 [details]
printscreen from excel
Comment 2 raal 2022-07-15 06:15:47 UTC
Confirm Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: a93d7e7df6804cd6f1f2fa1ef0e6e95ce6c3752a
CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded