[GNC] Importing Reports into LO Calc

[David Cousens]

Abe,

The default colors which come up in Calc are going to depend upon its
preference settings and any formatting already set in Calc before
importing. GnuCash has no control over that.

Cal's cell "currency" setting has the option of negative numbers
appearing in red. If you format all cells containing numerical currency
data to "Currency" this will work. ALl that is imported into Calc is
the data , not any formatting

The benefit of importing to Calc is that youthen have complete control
over how it is formatted within the constraints of Calc's formatting
capabilities but that comes at the cost of having to manually set that
formatting.

AFAIK it should be possible to create a formatted template in Calc so
that you can import the data into the template and have it appear as
you desire.

On Sat, 2024-03-09 at 11:41 -0500, Abe Sternberg 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.