from:"Raimund Strehl"

[GNC] Styles of different items in GNUcash reports

2021-01-11 Thread Raimund Strehl

I am trying to fix an issue with the formatting of different items in a simple 
journal or general ledger.
What I am trying to achieve is to format the primary sorting key in BOLD, but 
it appears that this item does not have s style of its own.
In my case the primary sorting key are the accounts
The primary sorting key in the generated report seems to be using the 
background color as defined for the subheader (in e.g. the technicolor style).
But it does not appear to have a text style of its own, it appears to use the 
test style as defined for the normal text field 
Example of report 

1000 Bank account One <-- I want this bold
01.01.2020 Transfer 2000 EUR
02.01.2020 Transfer 1000 EUR
Total 3000 EUR
1100 Bank account Two <-- I want this bold 
03.01.2020 Transfer 6000 EUR
05.01.2020 Transfer 4000 EUR
Total 1 EUR

Does anyone have an idea of a workaround or any ongoing improvement to allow 
this in GNUcash.
Right now my only option is to export the HTML, import in Excel and do this 
manually. 
Feels like a waste of time as the report function in GNUcash is otherwise very 
nice and easy.

Thank you for all advice

Ray
___
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] Styles of different items in GNUcash reports

2021-01-14 Thread Raimund Strehl

Yes, that’s where I am making the adjustments.
But there is no adjustment for the “primary sorting key”


Från: Christopher Lam 
Skickat: den 13 januari 2021 11:17
Till: mummins heitzel 
Kopia: GnuCash users group 
Ämne: Re: [GNC] Styles of different items in GNUcash reports

Check the style sheets on the edit menu.

On Wed, 13 Jan 2021, 5:41 pm mummins heitzel, 
mailto:mumm...@gmx.net>> wrote:
   I am trying to fix an issue with the formatting of different items in a
   simple journal or general ledger.

   What I am trying to achieve is to format the primary sorting key in
   BOLD, but it appears that this item does not have s style of its own.

   In my case the primary sorting key are the accounts The primary sorting
   key in the generated report seems to be using the background color as
   defined for the subheader (in e.g. the technicolor style).

   But it does not appear to have a text style of its own, it appears to
   use the test style as defined for the normal text field Example of
   report


   1000 Bank account One <-- I want this bold

   01.01.2020 Transfer 2000 EUR

   02.01.2020 Transfer 1000 EUR

   Total 3000 EUR

   1100 Bank account Two <-- I want this bold

   03.01.2020 Transfer 6000 EUR

   05.01.2020 Transfer 4000 EUR

   Total 1 EUR


   Does anyone have an idea of a workaround or any ongoing improvement to
   allow this in GNUcash.

   Right now my only option is to export the HTML, import in Excel and do
   this manually.

   Feels like a waste of time as the report function in GNUcash is
   otherwise very nice and easy.

   Anyone who can point to a GNUcash developer forum, for these types of
   issues.


   Thank you for all advice


   Ray
___
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.
___
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] Styles of different items in GNUcash reports

2021-01-14 Thread Raimund Strehl

I was advised by the moderator that I could only post from the registered mail 
address. That is why I reposted from 
mumm...@gmx.net,which<mailto:mumm...@gmx.net,which> is the registered one.

Raimund

From: Alan A Holmes 
Sent: Wednesday, January 13, 2021 14:46
To: 'mummins heitzel'; gnucash-user@gnucash.org
Subject: RE: [GNC] Styles of different items in GNUcash reports

This is a repeat of the question originally posted on 11th January from
Raimund Strehl, presumably the same person now using a different e-mail
address and name. Adrien Monteleone responded to the original. If you're
unhappy with the original response it would have be polite to continue the
original thread rather than start a new one from different credentials.

Alan A Holmes

-Original Message-
From: gnucash-user
[mailto:gnucash-user-bounces+gnucash=alanaholmes.me...@gnucash.org] On
Behalf Of mummins heitzel
Sent: 13 January 2021 09:41
To: gnucash-user@gnucash.org
Subject: [GNC] Styles of different items in GNUcash reports

   I am trying to fix an issue with the formatting of different items in a
   simple journal or general ledger.

   What I am trying to achieve is to format the primary sorting key in
   BOLD, but it appears that this item does not have s style of its own.

   In my case the primary sorting key are the accounts The primary sorting
   key in the generated report seems to be using the background color as
   defined for the subheader (in e.g. the technicolor style).

   But it does not appear to have a text style of its own, it appears to
   use the test style as defined for the normal text field Example of
   report

   1000 Bank account One <-- I want this bold

   01.01.2020 Transfer 2000 EUR

   02.01.2020 Transfer 1000 EUR

   Total 3000 EUR

   1100 Bank account Two <-- I want this bold

   03.01.2020 Transfer 6000 EUR

   05.01.2020 Transfer 4000 EUR

   Total 1 EUR

   Does anyone have an idea of a workaround or any ongoing improvement to
   allow this in GNUcash.

   Right now my only option is to export the HTML, import in Excel and do
   this manually.

   Feels like a waste of time as the report function in GNUcash is
   otherwise very nice and easy.

   Anyone who can point to a GNUcash developer forum, for these types of
   issues.

   Thank you for all advice

   Ray
___
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.

___
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] Fwd: [gnucash-de] Reversed banlanced accounts setting does not work in reports

2019-01-23 Thread Raimund Strehl

Thank you. 
I haven't seen the thread. Could you maybe forward it.
BR
Raimund


-Ursprungligt meddelande-
Från: D  
Skickat: den 23 januari 2019 02:09
Till: Gnucash Users 
Kopia: Raimund Strehl 
Ämne: Re: [GNC] Fwd: [gnucash-de] Reversed banlanced accounts setting does not 
work in reports

Raimund,


I saw the same issues recently.

The changes you see are purposeful. In order to make the totals add up, the 
person changed the way that the transaction report handles this setting. As I 
am not a programmer, I am not able to delve in to try and find a fix for it.I

The thread from the last couple of weeks goes into more detail.

David T.


On January 23, 2019, at 12:45 AM, "Frank H. Ellenberger" 
 wrote:

Hi Raimund,

forwarding to the english list

Regards
Frank

 Weitergeleitete Nachricht 
Betreff: [gnucash-de] Reversed banlanced accounts setting does not work in 
reports
Datum: Sat, 19 Jan 2019 23:02:47 +0000
Von: Raimund Strehl 
An: gnucash...@gnucash.org 

GnuCash 3.2 on Windows 10:



Reports such as Transaction report do not respect the "reverse balanced 
accounts" setting on subtotals for income accounts.



Individual transactions will show be shown reversed, but not account subtotals



e.g.



GnuCash 2.6.21 "reverse balanced accounts" to reverse sign on income accounts



Income account X:

Transaction A 200 EUR

Transaction B 300 EUR

Total 500 EUR



GnuCash 3.2 "reverse balanced accounts" to reverse sign on income accounts



Income account X:

Transaction A 200 EUR

Transaction B 300 EUR

Total -500 EUR





I assume it is a bug in the reporting function.

This bug seems to have appeared between version 2.6.21 and 3.2

Does anyone know the reason for this or a fix for this?



Thanks for any hints

Ray






___
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] Fwd: [gnucash-de] Reversed banlanced accounts setting does not work in reports

2019-01-23 Thread Raimund Strehl

Thank you. But this thread does not handle the fact that the “reverse balanced 
accounts” setting is ignored in the totals.
Unfortunately I am not a programmer, but if someone can point me to where the 
file for the general ledger report is saved, I can have a look and maybe try to 
figure out how to correct the mistake.
Remember, this was correctly implemented in 2.6 and then disappeared.
BR
Raimund

Från: David T. 
Skickat: den 23 januari 2019 15:02
Till: Raimund Strehl ; Gnucash Users 

Ämne: Re: SV: [GNC] Fwd: [gnucash-de] Reversed banlanced accounts setting does 
not work in reports

Sure! Since google isn't available in Germany,
https://lists.gnucash.org/pipermail/gnucash-user/2019-January/082029.html



On Wed, Jan 23, 2019 at 18:20, Raimund Strehl
mailto:raimund.str...@novamar.de>> wrote:
Thank you.
I haven't seen the thread. Could you maybe forward it.
BR
Raimund

-Ursprungligt meddelande-
Från: D mailto:sunfis...@yahoo.com>>
Skickat: den 23 januari 2019 02:09
Till: Gnucash Users mailto:gnucash-user@gnucash.org>>
Kopia: Raimund Strehl 
mailto:raimund.str...@novamar.de>>
Ämne: Re: [GNC] Fwd: [gnucash-de] Reversed banlanced accounts setting does not 
work in reports

Raimund,


I saw the same issues recently.

The changes you see are purposeful. In order to make the totals add up, the 
person changed the way that the transaction report handles this setting. As I 
am not a programmer, I am not able to delve in to try and find a fix for it.I

The thread from the last couple of weeks goes into more detail.

David T.


On January 23, 2019, at 12:45 AM, "Frank H. Ellenberger" 
mailto:frank.h.ellenber...@gmail.com>> wrote:

Hi Raimund,

forwarding to the english list

Regards
Frank

 Weitergeleitete Nachricht 
Betreff: [gnucash-de] Reversed banlanced accounts setting does not work in 
reports
Datum: Sat, 19 Jan 2019 23:02:47 +
Von: Raimund Strehl 
mailto:raimund.str...@novamar.de>>
An: gnucash...@gnucash.org<mailto:gnucash...@gnucash.org> 
mailto:gnucash...@gnucash.org>>

GnuCash 3.2 on Windows 10:



Reports such as Transaction report do not respect the "reverse balanced 
accounts" setting on subtotals for income accounts.



Individual transactions will show be shown reversed, but not account subtotals



e.g.



GnuCash 2.6.21 "reverse balanced accounts" to reverse sign on income accounts



Income account X:

Transaction A 200 EUR

Transaction B 300 EUR

Total 500 EUR



GnuCash 3.2 "reverse balanced accounts" to reverse sign on income accounts



Income account X:

Transaction A 200 EUR

Transaction B 300 EUR

Total -500 EUR





I assume it is a bug in the reporting function.

This bug seems to have appeared between version 2.6.21 and 3.2

Does anyone know the reason for this or a fix for this?



Thanks for any hints

Ray





___
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] Fwd: [gnucash-de] Reversed banlanced accounts setting does not work in reports

2019-01-23 Thread Raimund Strehl

Thank you David,
Now I found the change of subject in the thread. And there is a link to the 
code there as well.
I agree with the thread poster that one should display the reversed subtotal 
amount honoring the setting and calculate the rand total with a negative sign.
I am not a coder, but I will have a look whether I understand anything.
BR
Raimund

Från: D 
Skickat: den 24 januari 2019 02:15
Till: Raimund Strehl ; Gnucash Users 

Ämne: Re: SV: SV: [GNC] Fwd: [gnucash-de] Reversed banlanced accounts setting 
does not work in reports


Sorry. The start of the thread is misleading. Following the thread, you will 
see that with 
https://lists.gnucash.org/pipermail/gnucash-user/2019-January/082031.html the 
discussion turns to precisely the issue you're asking about.


On January 23, 2019, at 8:27 PM, Raimund Strehl 
mailto:raimund.str...@novamar.de>> wrote:

Thank you. But this thread does not handle the fact that the “reverse balanced 
accounts” setting is ignored in the totals.
Unfortunately I am not a programmer, but if someone can point me to where the 
file for the general ledger report is saved, I can have a look and maybe try to 
figure out how to correct the mistake.
Remember, this was correctly implemented in 2.6 and then disappeared.
BR
Raimund

Från: David T. mailto:sunfis...@yahoo.com>>
Skickat: den 23 januari 2019 15:02
Till: Raimund Strehl 
mailto:raimund.str...@novamar.de>>; Gnucash Users 
mailto:gnucash-user@gnucash.org>>
Ämne: Re: SV: [GNC] Fwd: [gnucash-de] Reversed banlanced accounts setting does 
not work in reports

Sure! Since google isn't available in Germany,
https://lists.gnucash.org/pipermail/gnucash-user/2019-January/082029.html



On Wed, Jan 23, 2019 at 18:20, Raimund Strehl
mailto:raimund.str...@novamar.de>> wrote:
Thank you.
I haven't seen the thread. Could you maybe forward it.
BR
Raimund

-Ursprungligt meddelande-
Från: D mailto:sunfis...@yahoo.com>>
Skickat: den 23 januari 2019 02:09
Till: Gnucash Users mailto:gnucash-user@gnucash.org>>
Kopia: Raimund Strehl 
mailto:raimund.str...@novamar.de>>
Ämne: Re: [GNC] Fwd: [gnucash-de] Reversed banlanced accounts setting does not 
work in reports

Raimund,


I saw the same issues recently.

The changes you see are purposeful. In order to make the totals add up, the 
person changed the way that the transaction report handles this setting. As I 
am not a programmer, I am not able to delve in to try and find a fix for it.I

The thread from the last couple of weeks goes into more detail.

David T.


On January 23, 2019, at 12:45 AM, "Frank H. Ellenberger" 
mailto:frank.h.ellenber...@gmail.com>> wrote:

Hi Raimund,

forwarding to the english list

Regards
Frank

 Weitergeleitete Nachricht 
Betreff: [gnucash-de] Reversed banlanced accounts setting does not work in 
reports
Datum: Sat, 19 Jan 2019 23:02:47 +
Von: Raimund Strehl 
mailto:raimund.str...@novamar.de>>
An: gnucash...@gnucash.org<mailto:gnucash...@gnucash.org> 
mailto:gnucash...@gnucash.org>>

GnuCash 3.2 on Windows 10:



Reports such as Transaction report do not respect the "reverse balanced 
accounts" setting on subtotals for income accounts.



Individual transactions will show be shown reversed, but not account subtotals



e.g.



GnuCash 2.6.21 "reverse balanced accounts" to reverse sign on income accounts



Income account X:

Transaction A 200 EUR

Transaction B 300 EUR

Total 500 EUR



GnuCash 3.2 "reverse balanced accounts" to reverse sign on income accounts



Income account X:

Transaction A 200 EUR

Transaction B 300 EUR

Total -500 EUR





I assume it is a bug in the reporting function.

This bug seems to have appeared between version 2.6.21 and 3.2

Does anyone know the reason for this or a fix for this?



Thanks for any hints

Ray




___
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.

[GNC] PDF export of reports

2019-01-25 Thread Raimund Strehl

Hi all,

Don't know if anyone else has noticed and if maybe there is a whole thread 
already, but PDF export has a flaw.
I have tested this on several Windows 10 machines on Gnucash 2.6 and 3.2/3.4.

Reports export fine to PDF, but at page transitions it can happen, that a line 
of text gets cut in half.

First half is on the end of one page and other half is at the start of next 
page.

This seems to happen independently of page size settings. If the lines in the 
report /e.g. general ledger report by chance match with the space available on 
the page it looks fine on that page,
but on the next page it can run into the problem.

I think what is missing is a command checking like this
IF this line does not fit on page
DO NOT start printing it
BUT send a new page command and continue with printing the line.

You can see, I am not a programmer

Any ideas for a solution or a workaround??

As it is now, I have to export as HTML, import in Excel and then print a 
useable PDF with clean page transitions

BR
Raimund

___
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] PDF export of reports

2019-01-27 Thread Raimund Strehl

If I am not mistaken the same problem occurs when printing the report from 
Gnucash using print to pdf or to a printer. I think this is an issue that 
should have high priority as the export and print functions are rendered 
unusable by this.
Any coders listening in here?  :-)
Raimund

Raimund

From: Geert Janssens 
Sent: Saturday, 26 January 2019 09:50
To: gnucash-user@gnucash.org
Cc: Tommy Trussell; Raimund Strehl
Subject: Re: [GNC] PDF export of reports

Op zaterdag 26 januari 2019 00:40:11 CET schreef Tommy Trussell:
> On Fri, Jan 25, 2019 at 2:57 PM Raimund Strehl 
>
> wrote:
> > PDF export has a flaw.
> > I have tested this on several Windows 10 machines on Gnucash 2.6 and
> > 3.2/3.4.
> >
> > Reports export fine to PDF, but at page transitions it can happen, that a
> > line of text gets cut in half.
> >
> > First half is on the end of one page and other half is at the start of
> > next page.
> >
> > This seems to happen independently of page size settings. If the lines in
> > the report /e.g. general ledger report by chance match with the space
> > available on the page it looks fine on that page,
> > but on the next page it can run into the problem.
>
> ...
>
> > Any ideas for a solution or a workaround??
> >
> > As it is now, I have to export as HTML, import in Excel and then print a
> > useable PDF with clean page transitions
>
> This is a known bug, and the good news is you already know the workaround!
> (Export as HTML, open the report in a web browser or some other program and
> print to PDF from there.) You'll find that it probably also affects reports
> sent to a printer.
>
> I believe the bug has been addressed in NON-Windows versions of GnuCash,
> but still affects Windows due to an outdated software "library" outside the
> control of GnuCash developers.

Unfortunately it's only addressed for linux. On MacOS we have the same issue.

Other than that you're dead on.

Regards,

Geert

___
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] PDF export of reports

2019-01-27 Thread Raimund Strehl

I use the path via Excel now, and it works. Luckily I only print once a year.
I can't code unfortunately, otherwise this would be a nice challenge.
Raimund

-Ursprungligt meddelande-
Från: Geert Janssens  
Skickat: den 26 januari 2019 17:45
Till: Raimund Strehl 
Kopia: gnucash-user@gnucash.org; Tommy Trussell 
Ämne: Re: [GNC] PDF export of reports

Op zaterdag 26 januari 2019 16:57:55 CET schreef Raimund Strehl:
> If I am not mistaken the same problem occurs when printing the report 
> from Gnucash using print to pdf or to a printer. I think this is an 
> issue that should have high priority as the export and print functions 
> are rendered unusable by this. Any coders listening in here?  :-) 
> Raimund
> 
> Raimund

Feel free to jump in and provide the necessary patches...

The currently active devs are aware of the problem but as John explained in 
another reply there's no easy solution. But there are a few workarounds:

1. open the reports in your favorite webbrowser and print from there 2. copy 
the report into Excel or LibreOffice calc (optionally adjust to your
taste) and print from there
3. run gnucash 3.x on linux and enjoy integrated printing/pdf export.

Regards,

geert


___
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.

[GNC] Styles of different items in GNUcash reports

Re: [GNC] Styles of different items in GNUcash reports

Re: [GNC] Styles of different items in GNUcash reports

Re: [GNC] Fwd: [gnucash-de] Reversed banlanced accounts setting does not work in reports

Re: [GNC] Fwd: [gnucash-de] Reversed banlanced accounts setting does not work in reports

Re: [GNC] Fwd: [gnucash-de] Reversed banlanced accounts setting does not work in reports

[GNC] PDF export of reports

Re: [GNC] PDF export of reports

Re: [GNC] PDF export of reports

9 matches

Site Navigation

Mail list logo

Footer information