[GNC] Importing Reports into LO Calc

[Abe Sternberg]

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.