Bug 147111 - Sterling symbol £ 0xc2a3 in data import is saved as ﾣ 0xefbea3
Summary: Sterling symbol £ 0xc2a3 in data import is saved as ﾣ 0xefbea3
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-02-01 17:13 UTC by number774
Modified: 2022-02-01 21:05 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 number774 2022-02-01 17:13:47 UTC 
Description:
The column filter dialog on text import does not save the pound sign correctly.

Steps to Reproduce:
1.Import a text file.
2.Set the import to separate columns by the UK currency symbol
3.Import the data
4. Close calc
5. Open calc, and import another file
6. Note that the saved delimiter is not correct.
My guess is that the pound sign isn't the only foreign language character that does it.

Actual Results:
Saved symbol is ﾣ

Expected Results:
Saved symbol is £


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.4.7.2
Build ID: 1:6.4.7-0ubuntu0.20.04.2
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: en-GB (en_GB.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 Julien Nabet 2022-02-01 19:16:31 UTC 
On pc Debian x86-64 with LO Debian testing package 7.3.0, I don't reproduce this.

LO 6.4.7 is quite old, please use LO ppa to upgrade LO (see https://launchpad.net/~libreoffice/+archive/ubuntu/ppa) or better, upgrade Ubuntu to a more recent version.
Comment 2 Eike Rathke 2022-02-01 19:27:49 UTC 
Can reproduce in 6.4.7, 7.0.6 and 7.1.8, but not in 7.2.5 or upcoming 7.3.0

Using £ as field separator for an import, opening the next .csv file the dialog still contains the £ character as Other.
Comment 3 number774 2022-02-01 20:56:11 UTC 
@jnabet that's interesting that I have an old version of Open Office. I'm running Ubuntu 20.04.3 LTS with all the patches it wants to give me.
I guess my next move is to raise an Ubuntu bug!
Thanks.
Comment 4 Julien Nabet 2022-02-01 21:05:15 UTC 
(In reply to number774 from comment #3)
> @jnabet that's interesting that I have an old version of Open Office. I'm
> running Ubuntu 20.04.3 LTS with all the patches it wants to give me.
> I guess my next move is to raise an Ubuntu bug!
> Thanks.

Libreoffice is a fork from OpenOffice.
It might be expected that Ubuntu 20.04.3 only proposes last version of a specific branch in your case 6.4 branch.
In Linux world, it's a bit a compromise between very stable/mature programs but old version and bleeding edge but might be unstable.
Personally, I use Debian testing as a compromise (there's also Debian stable and SID). Of course it's depend on the use of a machine, is it just your personal machine or is it a production server.