You can certainly set that as a style in Calc.
Regards,
Adrien
On 3/9/24 9:01 PM, Robert Heller wrote:
I think the OP's issue is the fact that Calc does not preserve the red
coloring of the negative numbers. The red coloring of the negative numbers is
something *GnuCash* is doing as a "good
Hi Robert,
If I copy and paste a Gnucash report directly into LibreOffice Calc
(version 7.6.4.1 on Win10) everything is black as expected except for the
negative numbers that are red which is what I also expected to happen ?
Not sure what's happening with OP's calc.
Cheers David H.
On Sun, 10
I think the OP's issue is the fact that Calc does not preserve the red
coloring of the negative numbers. The red coloring of the negative numbers is
something *GnuCash* is doing as a "good accounting practice", but the Calc is
not doing.
At Sat, 9 Mar 2024 18:13:04 -0600
1. Export Report
2. Open Calc
3. Open the report file in Calc. Result is the report imported into
cells based on the html table.
or
1. Export Report
2. Open Calc
3. Click 'Sheet' Menu, then 'Insert Sheet from file...' and select the
exported report file. Answer the dialogs, result is same as
Thanks. It may be best if I start this thread again. I sincerely
appreciate your taking the time to get me knowledgeable.
Abe
On 3/9/2024 15:35, David H wrote:
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
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
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
At Sat, 9 Mar 2024 11:41:31 -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
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
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.
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
11 matches
Mail list logo