Apache OpenOffice (AOO) Bugzilla – Issue 24040
formatting Error when pasting html table into spreadsheet
Last modified: 2013-02-07 22:39:36 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 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 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 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 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 Secret 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 Card-VISA 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.
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
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
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".