[GNC] Accounts columns currency

[Alen Siljak]

   > Sent: Sunday, April 15, 2018 at 12:10 AM
   > From: "John Ralls" <jralls at ceridwen.us>
   > To: "Alen Siljak" <alen.siljak at gmx.com>
   > Cc: gnucash-user at gnucash.org
   > Subject: Re: [GNC] Accounts columns currency
   >
   > > - I wanted to convert my XML book to SQLite and modify the
   root-account currency. However, I see no other book format options
   besides xml. GnuCash was installed from the default OpenSuse repo.
   > > - Checked one of the SQLite backup files and the root account is
   already in EUR commodity.
   > > - The summary line at the bottom of the Accounts window is showing
   all the amounts in Euros, respecting the default currency setting, it
   seems.
   > >
   > > But the list of columns that can be added to the Accounts window
   still only contains the locale currency (GBP).
   > > Changing the system default language also had no effect on the
   currency displayed here.
   > > I was going to check the config directory but I see no
   ~/.config/gnucash.
   >
   > Having only the XML backend indicates that you haven't installed
   either libdbi or the dbd driver packages.
   >
   > Language and locale are separate. Currency, numeric separators, time
   formats, etc. are locale settings. If you launch GnuCash from the
   command line you can set the locale for it with e.g. LANG=de_DE
   gnucash. If you use a desktop icon it's easier to set it in
   /usr/share/etc/gnucash/environment. It's about halfway down and says #
   LANG = nl_BE. Remove the # and set it to your locale of choice. If you
   want the same language just uncomment the following line. If you want a
   different language, uncomment the following line and replace {LANG}
   with a comma-separated list of two-letter language codes in order of
   preference, e.g. fr,de,en.
   >
   > Is this 2.6.something or 3.0? For 2.6.something the config directory
   is ~/.gnucash.
   >
   > Are you sure you selected the Choose radio button in
   Preferences>Accounts>Default Currency?

   Many thanks for all the tips. Got everything working now!

   Sqlite driver was missing.
   I switched my system locale to en_IE as it seems to be the only one
   matching my settings, without the need to mix different locales for
   language, currency, date format, etc. In Yast, "Language" is the name
   for all the related settings even though it shows way less detail than
   running "locale".

   So it seems that the additional columns in the Accounts window are
   always using the locale currency. At least on linux.
   I was expecting this would be the default currency from the settings.
   Do you have any opinion on this? Should I file it as a bug? I mean, my
   original problem is solved and it is likely not affecting too many
   people out there so it might as well pass.

   My gnucash package is v3.0.-1.1.
   And, no, the .config/gnucash is definitely not there but obviously the
   config files are located somewhere.
   The .register-cursor row is almost unusable with a dark theme as the
   text remains black (and gets a dark background from the theme) so I'll
   look around for the settings folder in order to modify the text color
   to something lighter.

   Cheers