Looks like changing back to en_GB has solved it. Don't need to have commas! Thing is I never changed it to FR in the first place! Thank you very much for your help. Now, how do unsubscribe from the list without losing permanent access, just in case I need help in the future? Regards
*Pam Dooner* On 14 December 2017 at 02:32, John Ralls <[email protected]> wrote: > The base currency of the book is completely separate from the LC_MONETARY > setting in the environment, so you can have a Euro account and still have > LC_MONETARY set to en_GB so that you have dots for the decimal separator. > > As for storing 99/100 as ‘0.99’, that’s backwards. GnuCash always stores > numbers as rationals and the SX string parser knows how to parse rationals > so I think that if you actually write “99/100” in your SX formula it will > be locale-safe. You might try switching back to en_GB, editing the SXes to > use rationals instead of decimals, and then switch back to fr_FR for the > commas (assuming that you actually want to “go native” and use commas for > the decimal separator). That should resolve the problem without having to > delete and recreate the scheduled transactions. > > One more thing: The list is archived at https://lists.gnucash.org/ > mailman/listinfo/gnucash-user so even if you do accidentally delete a > message you can still read it there. > > Regards, > John Ralls > > On Dec 13, 2017, at 1:11 PM, Pam Dooner <[email protected]> wrote: > > Just to clarify. My OS is in English but I live in France ! > > Le mer. 13 déc. 2017 à 21:38, Pam Dooner <[email protected]> a écrit : > > Thank you very much for resending this. The message had gone into my spam > box and I’d deleted it before I realised it wasn’t spam. I’d hoped to not > have to delete the old scheduled transactions but looks like that’s what is > required. > > Le mer. 13 déc. 2017 à 20:17, Dave H <[email protected]> a écrit : > > John Ralls replied to Pam's original other posting a couple of days ago > with a wiki link to changing langauage and other locale settings as follows > ... > > Cheers Dave H. > > > On Dec 11, 2017, at 9:54 AM, Pam Dooner <[email protected]> wrote: > > Hi. I just upgraded to High Sierra and while gnucash opens and is > > usable, > > trying to open the scheduled transaction editor crashes the editor and > gnush has to be force-quit. I get a parsing error on opening if there > > are > > any scheduled transactions run since last opened so I wanted to edit the > transactions as the program no longer accepts the full stop as a decimal > separator since my locale is in euros. I then thought I'd just create > > new > > scheduled transactions but that crashes too. After the parsing error > message the program opens but the amount of the entry is blank and it > > keeps > > repeating this each time I open the program. It means I have to enter > > each > > of my scheduled transactions manually, which is a bit of pain to say the > least, since I have 2 separate bank accounts! Any solution, workaround? > > > Did you delete the old scheduled transactions, the ones with dots for > decimal separators? > > Regards, > John Ralls > > [1] > http://wiki.gnucash.org/wiki/Locale_Settings#Changing_the_Language_on_OSX > > > > On 14 December 2017 at 04:58, Derek Atkins <[email protected]> wrote: > > Changing the currency is not sufficient. You need to change how numbers > are printed. I'm not sure how to do that on your platform. > > -derek > Sent using my mobile device. Please excuse any typos. > > On December 13, 2017 1:44:52 PM Pam Dooner <[email protected]> wrote: > > Changing the locale seems only to affect new accounts. I have tried to > ask for GBP but nothing has changed. > Pam > > > *Pam Dooner* > > On 13 December 2017 at 19:39, Derek Atkins <[email protected]> wrote: > > Yes, if you change your locale back to the old locale it should work > again. > > -derek > > On Wed, December 13, 2017 1:34 pm, Pam Dooner wrote: > > Thank you for this explanation. If I change my locale to UK, will > everything then be OK? Otherwise how do I change the SX definitions? > Regards, > Pam > > > *Pam Dooner* > > On 13 December 2017 at 16:30, Derek Atkins <[email protected]> wrote: > > Hi, > > Pam Dooner <[email protected]> writes: > > yes, definitely 2.6.18. Just tried again and this time managed to > > get > > a > > pop-up saying "An error occurred while processing 0.99" > I am trying to change all my decimal points to commas to coincide > > with > > the > > euro locale that I have to use now it seems. In the older > > versions, > > there > > was no issue with commas and points. I have UK accounts and > > european > > accounts so ought to be able to use both but this version (and the > > previous > > one) seem to cause the error if I try to use a decimal point. So > > I'll > > have > > to try to edit the file elsewhere and re-import it. I had hoped > > there > > might > > have been a way of globally changing all previous entries with a > > decimal > > point to commas. In the actual accounts, it has changed them all > > to > > commas > > but not in scheduled transactions! > Pam > > > Scheduled Transactions do not survive a locale change, specifically > > a > > change where the decimal separator changes characters. The reason > > is > > that the SX data is stored as text, not as a numeric, so "99/100" > > gets > > stored as 0.99 and then it expects to be parsed as 0.99 -- however > > if > > you change your locale so that a comma is a decimal separator then > GnuCash expects to read back 0,99. But when it sees 0.99 it doesn't > know how to interpret that. > > The only fix is to change the SX definitions, or to change your > > locale > > specification of (IIRC) LC_NUMERIC back to the old style. > > I don't know if there is a way change the character from within the > program. > > *Pam Dooner* > > > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > > -derek > -- > Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory > Member, MIT Student Information Processing Board (SIPB) > URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH > [email protected] PGP key available > > > > > -- > Derek Atkins 617-623-3745 <(617)%20623-3745> > [email protected] www.ihtfp.com > Computer and Internet Security Consultant > > > > -- > > Sent from Pam’s iPhone > > -- > Sent from Pam’s iPhone > _______________________________________________ > gnucash-user mailing list > [email protected] > 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. > > > _______________________________________________ gnucash-user mailing list [email protected] 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.
