I have exported a csv file which contains amount values with euro symbol but Calc prints ���. It looks fine when opening the file in a text editor. I have control over the generation of csv file so if there’s something wrong with the file, please let me know. The file is available at the link below
Open the file in a plain text editor and copy a few rows.
Open a new Writer document and paste.
Log in at this place and upload the Writer document.
Check that you have selected Unicode (UTF-8) in the text import dialogue. I would guess that it is set to 7 at the moment
1 Like
Ah yes. It was set to UTF-7. Is there something I can do to the csv file to make Libre detect it as UTF-8?
I generate this with php and I add the UTF-8 BOM with this code.
$fp = fopen('purchases.csv', 'w');
fwrite($fp, "\xEF\xBB\xBF"); // UTF-8 BOM
MS Excel detects the encoding as UTF-8 just fine.
The wrong character set is a bug that will be fixed in the upcoming version 24.8. Until then, just choose the right char set manually.
As indicated in your screenshot, the £ 150.00 on top of your record set is not recognized as a number. The value is bound to the left cell border.
When importing this data set into LibreOffice Calc:
Char set: UTF-8 or whatever looks right in the preview.
Locale: English (Irish) because of the point decimals in € currency.
Detect special numbers: Checked
This will import the dates and the currencies as correct numeric values, with the exception
of the amounts in £.
A small correction: in 25.2.5 (expected in the end of July), and in 25.8 (expected in the end of August).
1 Like
The second is a consequence of the first.
In the modern world, BOM is rarely used.