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 <[email protected]> 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 > > [email protected] > > 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 > [email protected] > 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 [email protected] 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.
