Report export via HTML open by excel

[David T.]

It seems to me that the major difference in the two screen shots is that in the older version, there appears to be a space following the "PHP", whereas in the second, there isn't. That is probably confusing Excel. As Paul mentioned, if you replace all instances of "Php" with "", you should be able to treat the data as numeric (and use Excel to format the cells for your currency).

David



________________________________
 From: Paul Schwartz <pmjs1115 at yahoo.com>
To: "The00Dustin at gmx.net" <The00Dustin at gmx.net>; 'Dodjie60' <dodjiel at fastmail.fm>; "gnucash-user at gnucash.org" <gnucash-user at gnucash.org> 
Sent: Friday, July 27, 2012 6:30 AM
Subject: Re: Report export via HTML open by excel
 
Having seen your examples, there are several suggestions. Since you don't have $, then remove all of the "Php " in the file. Then try the value() function. 

Also, it looks like your report is creating links; turn that option off so that there is only text in the report; things might work better.

HTH

Paul



>________________________________
> From: Dustin Henning <The00Dustin at gmx.net>
>To: 'Dodjie60' <dodjiel at fastmail.fm>; gnucash-user at gnucash.org 
>Sent: Friday, July 27, 2012 6:30 AM
>Subject: RE: Report export via HTML open by excel
> 
>Dodje,
>    This is what I was trying to describe, and as such, what I expected
>to see when you posted images (except the php currency marker, but if your
>system knows that is a currency marker, it should be fine).  Cells are
>general by default unless they are somehow set as something else.  IOW, it
>is good that they aren't "stored as text."  Why do you want them to be
>stored as numbers?  If you are using formulas, have you tried to use those
>formulas since the warning about them being "stored as text" isn't there?
>If you haven't, you should, because they may be recognized as numbers
>automatically in general.  If you have and they don't work, click on the
>column header (C in this case), then right click on any highlighted cell,
>and choose number (or currency) instead of general.  This should change them
>all at once.  If it doesn't, then what you are getting out of GnuCash may be
>the cause.  If you are pasting into Excel, you can also click the button
>that pops up after you paste and choose "use text import wizard" if it is
>available.  From that wizard, you might be able to get what you want by
>splitting the php into a separate cell or something.
>    Dustin
>
>-----Original Message-----
>From: gnucash-user-bounces+the00dustin=gmx.net at gnucash.org
>[mailto:gnucash-user-bounces+the00dustin=gmx.net at gnucash.org] On Behalf Of
>Dodjie60
>Sent: Friday, July 27, 2012 03:40
>To: gnucash-user at gnucash.org
>Subject: Re: Report export via HTML open by excel
>
>Paul,
>
>Attached 2 image as stated problem. First using the new version and the old
>version.
>
>http://gnucash.1415818.n4.nabble.com/file/n4655898/02_PM.png 
>
>http://gnucash.1415818.n4.nabble.com/file/n4655898/40_PM.png 
>
>
>
>-----
>The almighty dollar says that 'IN GOD WE TRUST".
>--
>View this message in context:
>http://gnucash.1415818.n4.nabble.com/Report-export-via-HTML-open-by-excel-tp
>4655876p4655898.html
>Sent from the GnuCash - User mailing list archive at Nabble.com.
>_______________________________________________
>gnucash-user mailing list
>gnucash-user at gnucash.org
>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
>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
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.