[kmymoney] [Bug 473322] SLQLite "kmmSplits"."sharesFormatted" Data Corrupt perhaps??

[JAH]

https://bugs.kde.org/show_bug.cgi?id=473322

--- Comment #6 from JAH <vanquestor at gmail.com> ---
Thanks for your kind reply (and work on kmymoney).

I use the sqlite3 command to process preprepared .sql queries that produce .csv
reports with calculated ratios etc. 

I noticed that prices (over 1000) stored in the "kmmPrices"."priceFormatted"
field for example, include a comma as the thousand separator, which has to be
parsed out for sql calculations. These ."xxxxFormatted" would be much easier &
neater to use in sql calculations but can't be relied upon "raw" if some
include commas etc - hence my add on question. (The alternative of parsing
fractions for substrings does require some very very long expressions in some
instances.)

I had not previously reported it as a bug because I inferred from the manual
that this formatting was part of the "xxxxxFormatted" fields purpose  - to
improve the readability of large amounts on screen (but hoped there might be a
settings option to turn it off  - that I had missed) 

>From the handbook:
"Monetary amounts and share values are shown both in numerator/denominator
format, and, with a field name suffixed with 'Formatted', in the form as shown
on your screens."

Perhaps in light of your last comment I should have reported it earlier as a
bug?

-- 
You are receiving this mail because:
You are the assignee for the bug.