Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Adrien Monteleone

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 accounting practice", but the Calc is
not doing.


___
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.


Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread David H
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 Mar 2024 at 13:02, 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 accounting practice", but the Calc
> is
> not doing.
>
> At Sat, 9 Mar 2024 18:13:04 -0600 adrien.montele...@lusfiber.net wrote:
>
> >
> > 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 above.
> >
> > or
> >
> > 1. Run Report in GnuCash
> > 2. Select All
> > 3. Copy
> > 4. Open Calc
> > 5. Paste, result is same as above
> >
> > In none of these cases is a web browser involved. (save for the Webkit
> > rendering within GnuCash, if you want to be pedantic about browser
> engines)
> >
> > I just tried all three, and in each case, there is no change in font or
> > alignments.
> >
> > Perhaps your issues involve whatever intermediary (browser) you are
> > involving that is unnecessary.
> >
> > Regards,
> > Adrien
> >
> > On 3/9/24 10:41 AM, 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?
> >
> > ___
> > 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.
>
___
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.


Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Robert Heller
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 adrien.montele...@lusfiber.net wrote:

>
> 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 above.
>
> or
>
> 1. Run Report in GnuCash
> 2. Select All
> 3. Copy
> 4. Open Calc
> 5. Paste, result is same as above
>
> In none of these cases is a web browser involved. (save for the Webkit
> rendering within GnuCash, if you want to be pedantic about browser engines)
>
> I just tried all three, and in each case, there is no change in font or
> alignments.
>
> Perhaps your issues involve whatever intermediary (browser) you are
> involving that is unnecessary.
>
> Regards,
> Adrien
>
> On 3/9/24 10:41 AM, 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?
>
> ___
> 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.


Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Adrien Monteleone

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 above.


or

1. Run Report in GnuCash
2. Select All
3. Copy
4. Open Calc
5. Paste, result is same as above

In none of these cases is a web browser involved. (save for the Webkit 
rendering within GnuCash, if you want to be pedantic about browser engines)


I just tried all three, and in each case, there is no change in font or 
alignments.


Perhaps your issues involve whatever intermediary (browser) you are 
involving that is unnecessary.


Regards,
Adrien

On 3/9/24 10:41 AM, 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?


___
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.


Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Abe Sternberg
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 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 
 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@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.


___
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.


Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread 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@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.

___
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.


Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread David H
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 
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@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.
>
___
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.


Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread Robert Heller


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 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.


Re: [GNC] Importing Reports into LO Calc

2024-03-09 Thread 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@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.


Re: [GNC] Importing Reports into LO Calc

2024-03-08 Thread Adrien Monteleone
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.