[GNC] Importing Reports into LO Calc

[David H]

Abe,

You can't include/paste pictures inline on the Gnucash mailing list so they
didn't show up :-(  You have to either save each pic as a file and attach
them to your email or I've found that you can get away with pasting 1 pic
as the very last thing in your email and it makes it.

Cheers David H.


On Sun, 10 Mar 2024 at 02:42, Abe Sternberg <abe.h.sternberg at gmail.com>
wrote:

> I guess I am a bit dense - old age will do that to you.  Let me try and
> be a bit more specific on my actions and the errors I get. Below is a
> screenshot of a budget performance report in GnuCash.
>
>
>
> Next, I export it to the folder I want it in and open it in Calc. The
> file opens in a browser tab, and I cut and paste the data into Calc.
> Notice the different colors used.
>
>
>
> I wonder why the colors are there in the first place instead of the
> expected black.  The negative numbers being in red is good accounting
> practice.  Look at what happens when I copy them into Calc.  Once again
> I get a shift in colors and the negative numbers are not in red and
> cannot be changed using cell format.  Is the problem in GnuCash or in Calc?
>
>
>
> Thanks for your help.
>
> Abe
>
>
>
> On 3/8/2024 21:47, Adrien Monteleone wrote:
> > Abe, next time, please start a new thread by sending a new message to
> > the list rather than replying to someone else's.
> >
> > As for how to get reports into Calc, I usually copy/paste, but you can
> > also just 'open' the exported report, or you can 'insert sheet from
> > file' into an existing workbook. (again, choosing the exported report)
> > When exporting, it probably wouldn't hurt to use an .html filename
> > extension.
> >
> > I have in a few reports seen some alignment issues, but that was due
> > to special padding used by that particular report rather than a
> > cleaner HTML. I think I filed a bug on it.
> >
> > Otherwise, I've had no issues bringing them into Calc.
> >
> > Regards,
> > Adrien
> >
> > On 3/8/24 1:45 PM, Abe Sternberg wrote:
> >> After a long hiatus from GnuCash and preparing reports, I find that I
> >> am back in that business.  The good news is that I am good to go on
> >> getting my reports structured the way I want. The bad news is that
> >> now I can't figure out how to import the HTML report into Calc.  I
> >> have tried everything I can think of, including cutting and pasting.
> >>
> >> The error is that some fields are imported in a different colored
> >> font, this seems to be limited to numeric fields.  I have another
> >> situation where totals in a table do not cross-foot - they are not
> >> equal when adding row totals across and column totals going down.
> >>
> >> I had this correct, but have forgotten what to do.
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > 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
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>