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