Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
A couple of year ago a user of Super User reported difficulties with summing values purporting to be Euros imported to LibreOffice Calc in CSV format. In the Q the user does not mention the locale...
#2: Post edited
by
Alexei
·
2020-11-01T06:58:54Z (about 4 years ago)
#1: Initial revision
by
pnuts
·
2020-10-14T19:57:45Z (about 4 years ago)
Summing values formatted for a different locale
A couple of year ago a user of Super User reported difficulties with summing values purporting to be Euros imported to LibreOffice Calc in CSV format. In the [Q](https://superuser.com/questions/1353973/summing-euro-amounts-in-libreoffice-calc) the user does not mention the locale settings, but did write "*I've used the LEFT function to get just the number part, though that still leaves me with a string.*" Some sample data was provided, but not its location so assuming the following:  and `,` to separate thousands, `.` for decimal, how to determine the sum of the above text-format amounts?