Re: [GNC] [SPAM] Re: Decimal points messed up

[John Ralls]

2.4.11 was released more than 6 1/2 years ago. It was built for 32 bits so the 
miracle that it runs on Mojave will end with Catalina, which doesn't run 32-bit 
binaries. You're very likely the only user left still running 2.4 on MacOS.

You can of course hack away on invoice.scm in 3.6 if you like. Normally I'd say 
that was a suboptimal solution because you'd have to make a patch and reapply 
it with every upgrade after modifying it to accommodate whatever changes had 
been made to the report since the last upgrade. But since you don't upgrade 
much I guess that won't matter to you.

Using the custom settings doesn't mean that you need to create a saved 
configuration for every invoice. You can create a template with the logo and 
whatever other formatting changes you like and save that, then open it and make 
further changes in the options as needed for individual invoices.

Notice that the Layout tab also has a block at the bottom for entering custom 
CSS where you might be able to add the space in the amounts and can certainly 
adjust the table spacing. Mind, however, that I don't use invoices at all and 
can't give you more specific guidance. Perhaps others here can.

Regards,
John Ralls

> On Aug 28, 2019, at 3:52 AM, Axel Essbaum  wrote:
> 
>> 
>> I see also that the new invoice layout is a bit problematic for me.  Where 
>> before I had "CHF 390.00" I now have "SFr.390.00" (no space between currency 
>> and value).  Also, the cells in the printed table have very little space to 
>> the cell borders.  I'm wondering if it's worth the effort to dig through the 
>> default invoice.scm to get the layout I want (like it used to be in 2.4) or 
>> if I should just stay with 2.4.  Are there any particular gotchas with 
>> running 2.4.11 with Mojave?
> 
> 
> Don't suppose this is easy to work around?  (2.4.11 in Mojave)
> 
> 
> Crashed Thread:0
> 
> Exception Type:EXC_CRASH (SIGABRT)
> Exception Codes:   0x, 0x
> Exception Note:EXC_CORPSE_NOTIFY
> 
> Termination Reason:DYLD, [0x4] Symbol missing
> 
> Application Specific Information:
> dyld: launch, loading dependent libraries
> DYLD_FRAMEWORK_PATH=/Applications/Gnucash.app/Contents/Frameworks
> DYLD_LIBRARY_PATH=/Applications/Gnucash.app/Contents/Resources/lib:/Applications/Gnucash.app/Contents/Resources/lib/gnucash::/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ImageIO.framework/Versions/A/Resources/:/Applications/Gnucash.app/Contents/Resources/lib:/Applications/Gnucash.app/Contents/Resources/lib/gnucash
> 
> Dyld Error Message:
>  Symbol not found: _inflateValidate
>  Referenced from: 
> /System/Library/Frameworks/ImageIO.framework/Versions/A/Resources/libPng.dylib
>  Expected in: /Applications/Gnucash.app/Contents/Resources/lib/libz.1.dylib
> in 
> /System/Library/Frameworks/ImageIO.framework/Versions/A/Resources/libPng.dylib
> 
> - Axel
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] [SPAM] Re: Decimal points messed up

[Axel Essbaum]

> 
> I see also that the new invoice layout is a bit problematic for me.  Where 
> before I had "CHF 390.00" I now have "SFr.390.00" (no space between currency 
> and value).  Also, the cells in the printed table have very little space to 
> the cell borders.  I'm wondering if it's worth the effort to dig through the 
> default invoice.scm to get the layout I want (like it used to be in 2.4) or 
> if I should just stay with 2.4.  Are there any particular gotchas with 
> running 2.4.11 with Mojave?


Don't suppose this is easy to work around?  (2.4.11 in Mojave)


Crashed Thread:0

Exception Type:EXC_CRASH (SIGABRT)
Exception Codes:   0x, 0x
Exception Note:EXC_CORPSE_NOTIFY

Termination Reason:DYLD, [0x4] Symbol missing

Application Specific Information:
dyld: launch, loading dependent libraries
DYLD_FRAMEWORK_PATH=/Applications/Gnucash.app/Contents/Frameworks
DYLD_LIBRARY_PATH=/Applications/Gnucash.app/Contents/Resources/lib:/Applications/Gnucash.app/Contents/Resources/lib/gnucash::/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ImageIO.framework/Versions/A/Resources/:/Applications/Gnucash.app/Contents/Resources/lib:/Applications/Gnucash.app/Contents/Resources/lib/gnucash

Dyld Error Message:
  Symbol not found: _inflateValidate
  Referenced from: 
/System/Library/Frameworks/ImageIO.framework/Versions/A/Resources/libPng.dylib
  Expected in: /Applications/Gnucash.app/Contents/Resources/lib/libz.1.dylib
 in 
/System/Library/Frameworks/ImageIO.framework/Versions/A/Resources/libPng.dylib

- Axel

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] [SPAM] Re: Decimal points messed up

[Axel Essbaum]

>> 
>> Next issue.  In 2.4.11 I modified the Default Style Sheet to use a heading 
>> banner image.  How do I add this in 3.6?  I don’t find the setting when I 
>> edit a Style Sheet.
>> 
>> In 2.4.11 I also modified invoice.scm in 
>> /Applications/Gnucash/Contents/Resources/share/gnucash/guile-modules/gnucash/report/
>>  as follows (diff output):
>> 
>> $ diff invoice.scm invoice.scm~
>> 262c262
>> < "g" (N_ "Display the action?") #f))
>> ---
>>   "g" (N_ "Display the action?") #t))
>> 277c277
>> < "k" (N_ "Display the entry's discount") #f))
>> ---
>>   "k" (N_ "Display the entry's discount") #t))
>> 282c282
>> < "l" (N_ "Display the entry's taxable status") #f))
>> ---
>>   "l" (N_ "Display the entry's taxable status") #t))
>> 333,350c333
>> <  (_ "Please submit payment to the following account.
>> < Bitte zahlen Sie auf das folgende Konto.
>> < 
>> < Bank:
>> < 
>> < XXX
>> < XXX
>> < 
>> < Account:
>> < 
>> < CHXX   
>> < ")))
>> ---
>>(_ "Thank you for your patronage")))
>> 
>> What’s the best way to achieve the above invoice formatting and text changes 
>> in 3.6?
> 
> 
> The picture option has moved to the Layout tab, the Action, Discount, and 
> Taxable options are on the Display Columns tab, and the Payable To toggle and 
> string are on the Display tab of Report Options for the invoices. Set it up 
> and then save the configuration. Use Report>Saved Configurations to run it in 
> the future.
> 

Hi John,

In the past I never used the Report option to create a printable invoice.  
Rather, I edited the default Style Sheet and 
/Applications/Gnucash/Contents/Resources/share/gnucash/guile-modules/gnucash/report/invoice.scm
 such that all I had to do was click "Print Invoice" to get what I needed.  I 
think you are now suggesting I create a Report for each invoice I want to 
print, which is many more steps.

I see also that the new invoice layout is a bit problematic for me.  Where 
before I had "CHF 390.00" I now have "SFr.390.00" (no space between currency 
and value).  Also, the cells in the printed table have very little space to the 
cell borders.  I'm wondering if it's worth the effort to dig through the 
default invoice.scm to get the layout I want (like it used to be in 2.4) or if 
I should just stay with 2.4.  Are there any particular gotchas with running 
2.4.11 with Mojave?

Thanks,

- Axel


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] [SPAM] Re: Decimal points messed up

[John Ralls]

> On Aug 26, 2019, at 4:25 AM, Axel Essbaum  wrote:
> 
>>> 
>>> Thanks for the helpful response.  I am happy with a comma separator.  But I 
>>> get:
>>> 
>>> $ defaults write -a Gnucash AppleLocale en_GB.UTF-8
>>> 2019-08-24 06:54:51.749 defaults[13856:1130038] Unexpected argument 
>>> en_GB.UTF-8; leaving defaults unchanged.
>>> 
>>> This is Mojave, btw.
>>> 
>>> Any idea what I need to do different?
>>> 
>>> Thanks!
>> 
>> Sorry, the option is -app and you need to single-quote the locale:
>>   defaults write -app Gnucash AppleLocale 'en_GB.UTF-8'
>> Sometimes the defaults system is persnickety and denies knowing about 
>> Gnucash:
>> "Can't determine domain name for application Gnucash; defaults unchanged" in 
>> which case you can tell it the full path
>>   defaults write -app /Applications/Gnucash.app AppleLocale 'en_GB.UTF-8’
> 
> This worked!  Thank you!
> 
> Next issue.  In 2.4.11 I modified the Default Style Sheet to use a heading 
> banner image.  How do I add this in 3.6?  I don’t find the setting when I 
> edit a Style Sheet.
> 
> In 2.4.11 I also modified invoice.scm in 
> /Applications/Gnucash/Contents/Resources/share/gnucash/guile-modules/gnucash/report/
>  as follows (diff output):
> 
> $ diff invoice.scm invoice.scm~
> 262c262
> < "g" (N_ "Display the action?") #f))
> ---
>"g" (N_ "Display the action?") #t))
> 277c277
> < "k" (N_ "Display the entry's discount") #f))
> ---
>"k" (N_ "Display the entry's discount") #t))
> 282c282
> < "l" (N_ "Display the entry's taxable status") #f))
> ---
>"l" (N_ "Display the entry's taxable status") #t))
> 333,350c333
> <  (_ "Please submit payment to the following account.
> < Bitte zahlen Sie auf das folgende Konto.
> < 
> < Bank:
> < 
> < XXX
> < XXX
> < 
> < Account:
> < 
> < CHXX   
> < ")))
> ---
> (_ "Thank you for your patronage")))
> 
> What’s the best way to achieve the above invoice formatting and text changes 
> in 3.6?


The picture option has moved to the Layout tab, the Action, Discount, and 
Taxable options are on the Display Columns tab, and the Payable To toggle and 
string are on the Display tab of Report Options for the invoices. Set it up and 
then save the configuration. Use Report>Saved Configurations to run it in the 
future.

Regards,
John Ralls
 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] [SPAM] Re: Decimal points messed up

[Axel Essbaum]

>> 
>> Thanks for the helpful response.  I am happy with a comma separator.  But I 
>> get:
>> 
>> $ defaults write -a Gnucash AppleLocale en_GB.UTF-8
>> 2019-08-24 06:54:51.749 defaults[13856:1130038] Unexpected argument 
>> en_GB.UTF-8; leaving defaults unchanged.
>> 
>> This is Mojave, btw.
>> 
>> Any idea what I need to do different?
>> 
>> Thanks!
> 
> Sorry, the option is -app and you need to single-quote the locale:
>   defaults write -app Gnucash AppleLocale 'en_GB.UTF-8'
> Sometimes the defaults system is persnickety and denies knowing about Gnucash:
> "Can't determine domain name for application Gnucash; defaults unchanged" in 
> which case you can tell it the full path
>   defaults write -app /Applications/Gnucash.app AppleLocale 'en_GB.UTF-8’

This worked!  Thank you!

Next issue.  In 2.4.11 I modified the Default Style Sheet to use a heading 
banner image.  How do I add this in 3.6?  I don’t find the setting when I edit 
a Style Sheet.

In 2.4.11 I also modified invoice.scm in 
/Applications/Gnucash/Contents/Resources/share/gnucash/guile-modules/gnucash/report/
 as follows (diff output):

$ diff invoice.scm invoice.scm~
262c262
< "g" (N_ "Display the action?") #f))
---
   "g" (N_ "Display the action?") #t))
277c277
< "k" (N_ "Display the entry's discount") #f))
---
   "k" (N_ "Display the entry's discount") #t))
282c282
< "l" (N_ "Display the entry's taxable status") #f))
---
   "l" (N_ "Display the entry's taxable status") #t))
333,350c333
<  (_ "Please submit payment to the following account.
< Bitte zahlen Sie auf das folgende Konto.
< 
< Bank:
< 
< XXX
< XXX
< 
< Account:
< 
< CHXX   
< ")))
---
(_ "Thank you for your patronage")))

What’s the best way to achieve the above invoice formatting and text changes in 
3.6?

Thanks again,

- Axel

—
Axel Essbaum
a...@essbaum.com 



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] [SPAM] Re: Decimal points messed up

[John Ralls]

> On Aug 23, 2019, at 9:59 PM, Axel Essbaum  wrote:
> 
>> 
>> On 23 Aug 2019, at 23:10, John Ralls  wrote:
>>> On Aug 23, 2019, at 9:01 AM, Axel Essbaum  wrote:
>>> Hi All,
>>> 
>>> Longtime Mac GC user, still running my original 2.4.11 install from… 10 
>>> years ago?  I am now looking at upgrading to 3.6 and am encountering a 
>>> problem with the "grouping" character and decimal points being transposed.  
>>> I am using GC with CHF (I am in Switzerland), but my computer is set up in 
>>> English.
>>> 
>>> In System Prefs > Langauge and Region I have Region = Switzerland.  On that 
>>> pane in Advanced I have Number Separator Grouping = ' and decimal = .  
>>> Currency is CHF and Currency Grouping = ' and decimal = .
>>> 
>>> In GC Prefs I have Locale = CHF (Swiss Franc).
>>> 
>>> But two thousand CHF, which I would expect to see as CHF 2'000.00 is 
>>> actually displayed SFr. 2.000,00.
>>> 
>>> I can live with SFr. but I can't have a decimal point used for grouping.
>>> 
>>> Anyone have any ideas what I can adjust to fix this?
>> 
>> The problem is that while Apple's native localization (based on a library 
>> called ICU) has the correct numeric and monetary formats for Switzerland, 
>> their C runtime library localization files that GnuCash uses have the wrong 
>> values for thousands separator and decimal point.
>> 
>> MacOS won't let you edit the file even with admin privileges (i.e. sudo) and 
>> AFAIK no other country uses an apostrophe for the thousands separator so I 
>> don't think that there's any way to get the apostrophe thousands separator 
>> short of switching to Linux.
>> 
>> Since you're using GnuCash in English anyway you could just tell defaults
>>  defaults write -a Gnucash AppleLocale en_GB.UTF-8
>> and it will use comma for the thousands separator and dot for the decimal 
>> point. You'll want to change the default currency in Preferences on the 
>> Accounts and Reports tabs to CHF instead of locale.
> 
> Hi John,
> 
> Thanks for the helpful response.  I am happy with a comma separator.  But I 
> get:
> 
> $ defaults write -a Gnucash AppleLocale en_GB.UTF-8
> 2019-08-24 06:54:51.749 defaults[13856:1130038] Unexpected argument 
> en_GB.UTF-8; leaving defaults unchanged.
> 
> This is Mojave, btw.
> 
> Any idea what I need to do different?
> 
> Thanks!

Sorry, the option is -app and you need to single-quote the locale:
   defaults write -app Gnucash AppleLocale 'en_GB.UTF-8'
Sometimes the defaults system is persnickety and denies knowing about Gnucash:
"Can't determine domain name for application Gnucash; defaults unchanged" in 
which case you can tell it the full path
   defaults write -app /Applications/Gnucash.app AppleLocale 'en_GB.UTF-8'

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] [SPAM] Re: Decimal points messed up

[Axel Essbaum]

> On 23 Aug 2019, at 23:10, John Ralls  wrote:
>> On Aug 23, 2019, at 9:01 AM, Axel Essbaum  wrote:
>> Hi All,
>> 
>> Longtime Mac GC user, still running my original 2.4.11 install from… 10 
>> years ago?  I am now looking at upgrading to 3.6 and am encountering a 
>> problem with the "grouping" character and decimal points being transposed.  
>> I am using GC with CHF (I am in Switzerland), but my computer is set up in 
>> English.
>> 
>> In System Prefs > Langauge and Region I have Region = Switzerland.  On that 
>> pane in Advanced I have Number Separator Grouping = ' and decimal = .  
>> Currency is CHF and Currency Grouping = ' and decimal = .
>> 
>> In GC Prefs I have Locale = CHF (Swiss Franc).
>> 
>> But two thousand CHF, which I would expect to see as CHF 2'000.00 is 
>> actually displayed SFr. 2.000,00.
>> 
>> I can live with SFr. but I can't have a decimal point used for grouping.
>> 
>> Anyone have any ideas what I can adjust to fix this?
> 
> The problem is that while Apple's native localization (based on a library 
> called ICU) has the correct numeric and monetary formats for Switzerland, 
> their C runtime library localization files that GnuCash uses have the wrong 
> values for thousands separator and decimal point.
> 
> MacOS won't let you edit the file even with admin privileges (i.e. sudo) and 
> AFAIK no other country uses an apostrophe for the thousands separator so I 
> don't think that there's any way to get the apostrophe thousands separator 
> short of switching to Linux.
> 
> Since you're using GnuCash in English anyway you could just tell defaults
>  defaults write -a Gnucash AppleLocale en_GB.UTF-8
> and it will use comma for the thousands separator and dot for the decimal 
> point. You'll want to change the default currency in Preferences on the 
> Accounts and Reports tabs to CHF instead of locale.

Hi John,

Thanks for the helpful response.  I am happy with a comma separator.  But I get:

$ defaults write -a Gnucash AppleLocale en_GB.UTF-8
2019-08-24 06:54:51.749 defaults[13856:1130038] Unexpected argument 
en_GB.UTF-8; leaving defaults unchanged.

This is Mojave, btw.

Any idea what I need to do different?

Thanks!

- Axel
a...@essbaum.com 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.