[GNC] Importing Reports into LO Calc

[Abe Sternberg]

Thanks.  It may be best if I start this thread again.  I sincerely 
appreciate your taking the time to get me knowledgeable.

Abe

On 3/9/2024 15:35, David H wrote:
> 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.
>