Issue 24040

Summary:	formatting Error when pasting html table into spreadsheet
Product:	Calc	Reporter:	tobypowell <toby>
Component:	ui	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1
Target Milestone:	---
Hardware:	PC
OS:	Windows 2000
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

Description tobypowell 2004-01-02 10:45:07 UTC

When I go to my online banking, on https://www.nwolb.com/secure, it presents me 
with a table that displays all my balances, but I like to work out how much 
capital I have in total, not spread over 5 accounts.

If I copy the table in internet explorer (5 or 6 - the site doesn't let any 
other browser in) then paste into excel 2000, the columns are preserved. If I 
paste into excel 2003 the values are interpreted into their correct £xxx values

If I paste into OpenOffice the values are interpreted as one long string.

If I paste into Notepad, the values are interpreted as what looks like multi-
line space delimited text (one line for each row).

I presume that Excel has a way of interpreting the source of the table and 
recognises the code that produced it, rather than the plain text version.

Ideally, if I paste into the spreadsheet the format should remain roughly the 
same as the html I pasted it from. I can't be the only one trying to do this?

The following is the HTML that I am attempting to copy

**BEGIN HTML**
<table border="0" cellPadding="2" cellSpacing="1" width="100%">

	

<tr class="bgNavy">
	<td class="ftr" style="text-align:center;vertical-align:top" 
align="center">
		<span class="bgNavy"><b>ACCOUNT NAME</b></span><br>
		<img src="images/clear.gif" width="190" height="1"><br>
	</td>
	<td class="ftr" style="text-align:center;vertical-align:top" 
align="center">
		<span class="bgNavy"><b><nobr>ACCOUNT 
NUMBER</nobr></b></span><br>
		<img src="images/clear.gif" width="130" height="1"><br>
	</td>
	<td class="ftr" style="text-align:center;vertical-align:top" 
align="center">
		<span class="bgNavy"><b>BALANCE</b></span><br>
		<img src="images/clear.gif" width="70" height="1"><br>
	</td>

	<td class="ftr" style="text-align:center;vertical-align:top" 
align="center">
	<span class="bgNavy"><b>AVAILABLE</b></span><br>
	<img src="images/clear.gif" width="70" height="1"><br>
	</td>
	
</tr> 

		<tr class="tblRow" title="Click here to see this account's Mini-
Statement" onMouseOver="this.className='bgHighLight'" 
onMouseOut="this.className='tblRow'" onClick="frameNav('balances.asp?0')">
	
			<td class="tblCell" style="text-align:left" 
align="left" name="row0">Secret&nbsp;E-savings</td>
			<td class="tblCell" style="text-align:center" 
align="center"><span title='This is the Sort Code'>xxxxxx</span> <span 
title='This is the Account Number'>xxxxxxx</span></td>
			<td class="tblCell" style="text-align:right" 
align="right">£xxxx.xx</td>
			
				<td class="tblCell" style="text-align:right" 
align="right">£xxxx.xx</td>
			
			</tr>
	
		<tr class="tblSelect">
	
			<td class="tblCell" style="text-align:left" 
align="left" name="row1">Current&nbsp;Account</td>
			<td class="tblCell" style="text-align:center" 
align="center"><span title='This is the Sort Code'>xxxxxx</span> <span 
title='This is the Account Number'>xxxxxxx</span></td>
			<td class="tblCell" style="text-align:right" 
align="right">£xxxx.xx</td>
			
				<td class="tblCell" style="text-align:right" 
align="right">£xxxx.xx</td>
			
			</tr>
	
		<tr class="tblRow" title="Click here to see this account's Mini-
Statement" onMouseOver="this.className='bgHighLight'" 
onMouseOut="this.className='tblRow'" onClick="frameNav('balances.asp?2')">
	
			<td class="tblCell" style="text-align:left" 
align="left" name="row2">Savings&nbsp;Account</td>
			<td class="tblCell" style="text-align:center" 
align="center"><span title='This is the Sort Code'>xxxxxx</span> <span 
title='This is the Account Number'>xxxxxxx</span></td>
			<td class="tblCell" style="text-align:right" 
align="right">£xxxx.xx</td>
			
				<td class="tblCell" style="text-align:right" 
align="right">£xxxx.xx</td>
			
			</tr>
	
		<tr class="tblRow" title="Click here to see this account's Mini-
Statement" onMouseOver="this.className='bgHighLight'" 
onMouseOut="this.className='tblRow'" onClick="frameNav('balances.asp?3')">
	
			<td class="tblCell" style="text-align:left" 
align="left" name="row3">E&nbsp;savings</td>
			<td class="tblCell" style="text-align:center" 
align="center"><span title='This is the Sort Code'>xxxxxx</span> <span 
title='This is the Account Number'>xxxxxxx</span></td>
			<td class="tblCell" style="text-align:right" 
align="right">£xxxx.xx</td>
			
				<td class="tblCell" style="text-align:right" 
align="right">£xxxx.xx</td>
			
			</tr>
	
		<tr class="tblRow" title="Click here to see this account's Mini-
Statement" onMouseOver="this.className='bgHighLight'" 
onMouseOut="this.className='tblRow'" onClick="frameNav('balances.asp?4')">
	
			<td class="tblCell" style="text-align:left" 
align="left" name="row4">Super&nbsp;Secret&nbsp;Saving</td>
			<td class="tblCell" style="text-align:center" 
align="center"><span title='This is the Sort Code'>xxxxxx</span> <span 
title='This is the Account Number'>xxxxxxx</span></td>
			<td class="tblCell" style="text-align:right" 
align="right">£xxxx.xx</td>
			
				<td class="tblCell" style="text-align:right" 
align="right">£xxxx.xx</td>
			
			</tr>
	
		<tr class="tblRow" title="Click here to see this Credit Card's 
Mini-Statement" onMouseOver="this.className='bgHighLight'" 
onMouseOut="this.className='tblRow'" onClick="frameNav('balances.asp?5')">
	
			<td class="tblCell" style="text-align:left" 
align="left">Gold&nbsp;Card-VISA&nbsp;GCA</td>
		

		<td class="tblCell" style="text-align:center" 
align="center">xxxxxxxxxxxxxxxx</td>
		<td class="tblCell" style="text-align:right" align="right">£-
xxxx.xx</td>
		
		
				<td class="tblCell" style="text-align:right" 
align="right">£xxxx.xx</td>
					
		</tr>
	
	<tr>
		<td colspan="4" style="text-align:center" align="center">
		<br>
			<table cellpadding="0" cellspacing="0" border="0" 
width="100%">

			<tr>
				<td width="50%" align="center">
					<input name="buttonChange" width="200" 
type="submit" value="Edit Account Name" class="btnNav" style="width:200">
				</td>

				<td width="50%" align="center">
					<input name="buttonDetails" width="200" 
type="submit" value="View Account Details" class="btnNav" style="width:200">
				</td>
			</tr>
				
			</table>
			
		</td>
	</tr>
	</table>
** END HTML**


There was one bug I saw that had something similar to do with this, but the 
poster lost contact.

Sorry if I missed some similar bug on my search.

Comment 1 frank 2004-01-09 14:27:17 UTC

Hi Bettina,

it seems to me that the user wants Calc to interpret text values from the
Clipboard after pasting them as numbers or in this case as currency.

Frank

Comment 2 ace_dent 2008-05-16 02:55:56 UTC

OpenOffice.org Issue Tracker - Feedback Request.

The Issue you raised has the status 'New' pending further action, but has not
been updated within the last 4 years. Please consider re-testing with one of the
latest versions of OOo, as the problem(s) may have already been addressed.
Either use the recent stable version: http://download.openoffice.org/index.html
or consider trying the new OOo 3 BETA (still in testing):
http://download.openoffice.org/3.0beta/
 
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
http://www.openoffice.org/issues/query.cgi
 
Many thanks,
Andrew
 
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html

Comment 3 bettina.haberer 2010-05-21 14:49:59 UTC

To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".