plain text report using Firefox/OpenOffice

Derek Atkins warlord at MIT.EDU
Wed Apr 5 17:56:20 EDT 2006


Um, instead of using Cut-and-paste, perhaps a File -> Import in OOo
for the gnucash-exported HTML?

-derek

Quoting TyrusMaynard <mayn at main.nc.us>:

> I haven't been able to identify the odd outcome of text output from 
> html2text on this Ubuntu system and am unable to achieve what Andrew 
> describes.
> But ..... I discovered an unusual feature of the combo of Firefox 
> displaying the  html of a gnucash report and copy/paste insertion 
> into an OpenOffice document.
>   It seems that OpenOffice 1.1.3 recognizes what it receives from the 
> copy paste to compose a multicolumn text report based on the 
> definition of table tags in the original HTML.  This includes the 
> bonus that you can resize the columns to overcome occurrences of any 
> long text data that is forced to wrap within the predefined columns. 
> This is definitely not what you will get if you paste into a plain 
> text editor.
>    This behavior of OO 1.1.3 figures out the column size for each 
> column tag within rows and it has something to do with what Firefox 
> is putting into the copy/paste buffer.  This does NOT occur with a 
> copy/paste from the same HTML report displayed in Opera, or with 
> gnucash as the browser.
>   Does this have to do with some assumptions that Firefox makes about tabs?
>   Do others notice that this behavior is only achieved by the combo 
> of Firefox with Open Office?
>   This will be my work around tool for getting text that I can resize 
> in a wordprocessor. It allowed me to reduce a 20+ page report  to 12 
> pages.
> It also eliminates the bug which "mows" down starting/ending lines in 
> the postscript output for printing in my version of gnome.
>
> I was on the yellow brick road and fell through the clouds to be 
> deposited in Kansas. I guess tornado metaphors are not so good given 
> the recent real destruction, but stumbling onto this solution seems 
> as random as being thrown about by a tornado and coming out lucky.
>
> Thanks for the help when I was twisting around, Ty
>
>
>>>> example below here>>>
> Here are the fields of the report (Num is empty of data):
>
> Date	Num	Description	Transfer from/to	Amount
>
> Here is a sample section acquired by copy/paste to text:
>  Good single line rows , its OK except for the  skew of column which are all
> well aligned in the HTML display in gnucash and other browsers.
>
> 04/05/2005		BRIGGS CONSTR. hydraul oil	Assets.chk153	$23.28 
> 04/07/2005	 ASHEVILLE HOSE & 
> E	Assets.chk153	$29.40	04/22/2005		SmokyMtn Petro hydraul 
> Assets.chk153	$33.66
>
> Here is same sample of HTML sent thru html2 text:
>    "html2text -o output.file -nobs input.file"
>    The date and description field has become multi-row for ??? reason
>
> 04/             BRIGGS CONSTR.
> 05/             hydraul oil           Assets.chk153          $23.28
> 2005
> 04/
> 07/             ASHEVILLE HOSE & E    Assets.chk153          $29.40
> 2005
> 04/             SmokyMtn Petro
> 22/             hydraul               Assets.chk153          $33.66
> 2005
>
> Here is the  sample (first row) of HTML source:
>
> <TR>
> <TD BGCOLOR="#ffffff">
> 04/05/2005
> </TD>
> <TD BGCOLOR="#ffffff">
> <BR>
> </TD>
> <TD BGCOLOR="#ffffff">
> BRIGGS CONSTR. hydraul oil
> </TD>
> <TD BGCOLOR="#ffffff">
> Assets.chk153
> </TD>
> <TD BGCOLOR="#ffffff" NOWRAP ALIGN="right">
> $23.28
> </TD>
> </TR>
>
>
>
>
>
> _______________________________________________
> 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.
>



-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available



More information about the gnucash-user mailing list