Getting the Canadian Currency symbol right (was Re: Unrealized Gains showing on Balance Sheet)

Kate Logan katelogan.canada at gmail.com
Sat Feb 11 11:25:01 EST 2017


Thanks so much Victor. I have been trying to ignore the annoying "C" and
now it's gone!
Kate

On 02/10/2017 03:07 PM, R. Victor Klassen wrote:
> When I said it was a bug, I was referring to the C$ where it should read $.   I know nothing about the rest of your problem, which you seem to have solved.
> 
> Since that reply, I went and looked at the bug report, and noticed that there IS a workaround.   It isn’t pretty, but it’s not nearly as painful as what I’ve been doing for the last two years, since it doesn’t involve massaging each and every report.
> 
> Turns out if you go to the Tools menu, there’s something called a securities editor (which you might not stumble across if you aren’t tracking investments).  Open that up, and if, like me you don’t have the finance::quotes installed, you will see a mostly empty window.   At the bottom right is a checkbox with the text “show currencies” or some such.  Click that and you’ll have a single line appear in the window.  Click on the triangle, and you get all the currencies in the world (or at least all the ones GnuCash knows about).   Scroll down to the Canadian Dollar, select it, and then click edit (down in the bottom right area).  Now you can remove that pesky “C” from the display.   While you’re at it, you might want to edit the symbols for US dollar, US dollar next day, and US dollar same day.  Unless you never use US dollars.
> 
>> On Feb 10, 2017, at 10:06 AM, R. Victor Klassen <rvklassen at gmail.com> wrote:
>>
>> This is a bug that was introduced some years ago, with the move from 2.4.x to 2.6.x.   
>>
>> If you are good with command-line use, I can send along a sed script that I use with a procedure that looks like:
>>
>> - Make report
>> - Copy report into spreadsheet
>> - Save as csv
>> - Run through sed script to remove currencies (at command line)
>> - Read back into spreadsheet
>>
>>
>>
>>> On Feb 9, 2017, at 11:59 AM, Kate Logan <katelogan.canada at gmail.com> wrote:
>>>
>>> I run the balance sheet for one of my projects (a couple of rental
>>> houses) at the end of the fiscal year. All my amounts print with a
>>> leading "C" as C$123 (don't know why). Last year the report was fine.
>>> This year there is a line " unrealized gains" with an amount of "C$" (no
>>> amount). The next line is "total equity", also with an amount of "C$"
>>> followed by "total liabilities & equity", also with an amount of "C$".
>>>
>>> What is happening? and how do I fix it?
>>>
>>> Thanks for any help.
>>>
>>> Kate Logan
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>
> 
> 


More information about the gnucash-user mailing list