At Sat, 9 Mar 2024 11:41:31 -0500 Abe Sternberg <abe.h.sternb...@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? It is the spreadsheet program (calc). Spreadsheet programs are not accounting programs and don't know anything about "good accounting practice". GnuCash is an accounting program and does know all about "good accounting practice". *I* don't know how to fix this. What are you trying to do with the spreadsheet program? > > > > 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. > > -- Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364 Deepwoods Software -- Custom Software Services http://www.deepsoft.com/ -- Linux Administration Services hel...@deepsoft.com -- Webhosting Services
_______________________________________________ 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.
