Bug 123830 - Way dots and commas work changed in 6.2
Summary: Way dots and commas work changed in 6.2
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.1.1 rc
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-03-04 10:50 UTC by zak
Modified: 2019-03-18 21:43 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Working file, and csv example (25.37 KB, application/x-zip-compressed)
2019-03-04 10:50 UTC, zak
Details

Note You need to log in before you can comment on or make changes to this bug.
Description zak 2019-03-04 10:50:57 UTC
Created attachment 149709 [details]
Working file, and csv example

This sheet has been working the same for the last two years, I update only te line on the last Sheet "NewRateFrom" line two, it does calculations on the first Sheet "New_ExchangeRate" line 4, then I export the 3rd Sheet data to a csv which I use to import into another program. I use the dot/Del key in the numeric keypad when filling in the information. Since upgrading to 6.2 everything calculates fine, but when I export the information in Sheet 3 to csv, the final column contains a comma instead of a dot(.) I've check online for similiar issues which suggests changeing Tools>Options>Language Setting> Decimal Seperator key, but when I change it, the infromation I type in now reflects a dot, but breaks the formulas in the first sheet. Also since 6.1 I saved the export settings when saving to csv, so it was not a setting I cahnged there.
I tried 6.2.0 and 6.2.1.2, both have the issue, 6.1 and previously worked correctly, regionals settings is English(South African)
Comment 1 raal 2019-03-18 21:43:57 UTC
This seems to have begun at the below commit.
 cc49c0e19abe4ec98598642e65e70d65a0a936a5 is the first bad commit
commit cc49c0e19abe4ec98598642e65e70d65a0a936a5
Author: Jenkins Build User <tdf@pollux.tdf>
Date:   Mon Sep 3 14:23:23 2018 +0200

    source 5c10c448b299faf43d9df28bdb9dc4fbb00540aa

author	Eike Rathke <erack@redhat.com>	2018-09-03 09:20:53 +0200
committer	Eike Rathke <erack@redhat.com>	2018-09-03 13:38:13 +0200
commit 5c10c448b299faf43d9df28bdb9dc4fbb00540aa (patch)
tree ca8a1283a206794c24a56712e7aa12b0d3bb998e
parent 5967bae717c83a44d865558373acc08ee365de22 (diff)
tdf#119613 [*-ZA] decimal separator is comma, group separator is space

If I understand it correctly, it's not a bug, but fix of bug 119613