[GNC] Importing Reports into LO Calc

[David H]

Hi Robert,

If I copy and paste a Gnucash report directly into LibreOffice Calc
(version 7.6.4.1 on Win10)  everything is black as expected except for the
negative numbers that are red which is what I also expected to happen ?
Not sure what's happening with OP's calc.

Cheers David H.


On Sun, 10 Mar 2024 at 13:02, Robert Heller <heller at deepsoft.com> wrote:

> I think the OP's issue is the fact that Calc does not preserve the red
> coloring of the negative numbers.  The red coloring of the negative
> numbers is
> something *GnuCash* is doing as a "good accounting practice", but the Calc
> is
> not doing.
>
> At Sat, 9 Mar 2024 18:13:04 -0600 adrien.monteleone at lusfiber.net wrote:
>
> >
> > 1. Export Report
> > 2. Open Calc
> > 3. Open the report file in Calc. Result is the report imported into
> > cells based on the html table.
> >
> > or
> >
> > 1. Export Report
> > 2. Open Calc
> > 3. Click 'Sheet' Menu, then 'Insert Sheet from file...' and select the
> > exported report file. Answer the dialogs, result is same as above.
> >
> > or
> >
> > 1. Run Report in GnuCash
> > 2. Select All
> > 3. Copy
> > 4. Open Calc
> > 5. Paste, result is same as above
> >
> > In none of these cases is a web browser involved. (save for the Webkit
> > rendering within GnuCash, if you want to be pedantic about browser
> engines)
> >
> > I just tried all three, and in each case, there is no change in font or
> > alignments.
> >
> > Perhaps your issues involve whatever intermediary (browser) you are
> > involving that is unnecessary.
> >
> > Regards,
> > Adrien
> >
> > On 3/9/24 10:41 AM, Abe Sternberg 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?
> >
> > _______________________________________________
> > 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.
> >
> >
>
> --
> Robert Heller             -- Cell: 413-658-7953 GV: 978-633-5364
> Deepwoods Software        -- Custom Software Services
> http://www.deepsoft.com/  -- Linux Administration Services
> heller at deepsoft.com       -- Webhosting Services
>
> _______________________________________________
> 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.
>