Bug 143639 - Converting a spreadsheet to CSV results in a file with an invalid Unicode byte sequence
Summary: Converting a spreadsheet to CSV results in a file with an invalid Unicode byt...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.5.2 release
Hardware: x86-64 (AMD64) macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-07-31 12:16 UTC by rhys.wilkins
Modified: 2021-08-01 14:40 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 rhys.wilkins 2021-07-31 12:16:14 UTC 
Description:
Converting a spreadsheet using soffice --headless --convert-to csv file.ods results in a file with an invalid byte sequence when the source file contains a "£" symbol (GBP, UK pound sign).

Steps to Reproduce:
1. Create spreadsheet with a cell containing a £ symbol
2. Use soffice --headless --convert-to csv file
3. Note that CSV file contains invalid Unicode data

Actual Results:
File that's broken and can't be opened by apps that check Unicode

Expected Results:
A valid file that opens correctly


Reproducible: Always


User Profile Reset: No



Additional Info:
I have the UK Language Pack installed - I don't know if this is related
Comment 1 m_a_riosv 2021-08-01 14:40:19 UTC 
You need to use the proper options for that.
https://help.libreoffice.org/latest/en-US/text/shared/guide/start_parameters.html?DbPAR=SHARED#bm_id3156410
search for 'infilter'