Bug 148749 - FILEOPEN Lotus 123 entity encoding
Summary: FILEOPEN Lotus 123 entity encoding
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Character
  Show dependency tree / graph
 
Reported: 2022-04-23 19:35 UTC by SheetJS
Modified: 2023-08-18 17:31 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Attachments
sample file (3.89 KB, application/vnd.lotus-1-2-3)
2022-05-10 09:37 UTC, Xisco Faulí 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description SheetJS 2022-04-23 19:35:31 UTC 
Description:
Lotus 1-2-3 encodes certain characters like "\r" and "\n".  The general pattern appears to be /\x0F[\x20-\x2F]/, and the encoded character code is understood to be the low 4 bits of the second character.  For example, "\x0F-" maps to "\r" and "\x0F*" maps to "\n"

Steps to Reproduce:
https://github.com/SheetJS/test_files/raw/master/crlf/CRLFR9.123 (download and open)

Actual Results:
Cell B1 is "abc-*def"

Expected Results:
Cell B1 is "abc\r\ndef" (or "abc\ndef" depending on LO newline normalization)


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Comment 1 Xisco Faulí 2022-05-10 09:37:51 UTC 
Created attachment 180035 [details]
sample file
Comment 2 Buovjaga 2023-01-09 11:02:33 UTC 
Confirmed

Arch Linux 64-bit, X11
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 8ae84bb5566e12df64236a116b9d1889d6f5f052
CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded Jumbo
Built on 9 January 2023