You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2016/09/11 22:05:02 UTC
[Issue 127105] New: Paste from web page changes figures
https://bz.apache.org/ooo/show_bug.cgi?id=127105
Issue ID: 127105
Issue Type: DEFECT
Summary: Paste from web page changes figures
Product: General
Version: 4.1.2
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: ui
Assignee: issues@openoffice.apache.org
Reporter: biggspw@gmail.com
Created attachment 85668
--> https://bz.apache.org/ooo/attachment.cgi?id=85668&action=edit
Calc doc showing results of two paste types
Only tested this on Windows 7 PC.
I copied a table from one of my web pages
(http://www.stivescameraclub.co.uk/bs3/programme.html) and pasted into Calc and
the dates were changed. Using the context menu and choosing Paste Special /
Unformatted Text pasted in the correct dates.
Writer pastes the SAME wrong dates as well. Again Paste Special / Unformatted
Text works.
Have attached a Calc spreadsheet showing the changes.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127105] paste to AOO reads SDVAL or SDNUM instead of |
value |
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127105
--- Comment #9 from damjan@apache.org ---
As per a similar LibreOffice bug:
https://bugs.documentfoundation.org/show_bug.cgi?id=60071
The SDVAL and SDNUM carry numeric and formatting information, "not only when
saving/loading as HTML but also when copying via clipboard and paste special in
HTML format. For example it is possible to transport the assigned number
formats of a copied Calc cell range pasted as HTML to Writer." (comment 4 by
Eike Rathke)
What I think we should be doing, is checking whether the value between <TD> and
</TD> matches the SDVAL value when formatted by SDNUM, and letting the <TD>
value win if not.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127105] paste to AOO reads SDVAL or SDNUM instead of |
value |
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127105
--- Comment #11 from mroe <mr...@gmx.net> ---
(In reply to Peter from comment #8)
> Since SDVAL is something OO Family specific, we should ignore it.
This is a contradiction in itself!
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127105] Paste from web page changes figures
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127105
--- Comment #4 from Peter <le...@gmail.com> ---
Okay this behaviour is realy old.
Related bugs:
https://bz.apache.org/ooo/show_bug.cgi?id=11684 (about OO exporting this
rubbish)
https://bz.apache.org/ooo/show_bug.cgi?id=29733 (about dublicate output, maybe
even a dublicate)
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127105] Paste from web page changes figures
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127105
Abhishek Mehendale <me...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|0 |1
CC| |mehendaleabhi24@gmail.com
Status|UNCONFIRMED |CONFIRMED
--- Comment #1 from Abhishek Mehendale <me...@gmail.com> ---
I could replicate this bug using above link.
System Information: Mac OS X Sierra (Version: 10.12.1)
OpenOffice version: 4.1.3 AOO413m1(Build:9783) - Rev. 176138
Steps to reproduce:
1. Open http://www.stivescameraclub.co.uk/bs3/programme.html on your web
browser.
2. Copy table on which is present on the webpage.
3. Open Spreadsheet (Calc).
4. Perform paste operation on any of the cell.
Expected Output:
1. Numeric values change.
Output I got:
1. Numeric values change.
Further Testing:
Try pasting with 'paste special' function, Everything works fine.
I tried same thing with different tables which are available on web. Paste
function works perfectly.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127105] Paste from web page changes figures
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127105
Peter <le...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |leginee@gmail.com
Component|ui |code
OS|Windows 7 |All
--- Comment #3 from Peter <le...@gmail.com> ---
See https://help.libreoffice.org/Writer/Special_Tags
Does AOO do this too or is it a LO enhancement?
I am not sure why AOO reacts on SDVAL. It should not do this from a
requirements point of view. HTML does not specify such a Value for TD as far as
I know.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127105] Paste from web page changes figures
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127105
Phillip Biggs <bi...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |biggspw@gmail.com
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127105] paste to AOO reads SDVAL or SDNUM instead of |
value |
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127105
Peter <le...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|Paste from web page changes |paste to AOO reads SDVAL or
|figures |SDNUM instead of <td> value
| |</td>
--- Comment #6 from Peter <le...@gmail.com> ---
changeing title to something more technical terms.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127105] paste to AOO reads SDVAL or SDNUM instead of |
value |
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127105
--- Comment #10 from Peter <le...@gmail.com> ---
I dont agree. From HTML perspective it is still a messay solution.
However in an OOHTML approach, yea we should do this.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127105] paste to AOO reads SDVAL or SDNUM instead of |
value |
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127105
--- Comment #8 from Peter <le...@gmail.com> ---
Expectation is to import HTML specification. It says so on the Paste button
Popup.
Since SDVAL is something OO Family specific, we should ignore it.
If we want to support such a behaviour we should add an own Filter for this.
my 2 cent.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127105] paste to AOO reads SDVAL or SDNUM instead of |
value |
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127105
--- Comment #7 from mroe <mr...@gmx.net> ---
I think this issue /isn't/ a duplicate of issue 127105.
88071 describes problems with the /export/ of numbers resp. the number format.
SDVAL and SDNUM are special tags that are written from
StarOffice/OpenOffice/LibreOffice. As stated in comment 2 these tags are
reimported correctly!
So this behaviour is wanted and not an issue.
We don't know why these tags are written into the named web page. Maybe there
is also an export problem but this can only be stated by the producer of the
web page.
So in my opinion: 88071 is CONFIRMED, but 127107 should be RESOLVED: NOT AN
ISSUE.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127105] Paste from web page changes figures
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127105
damjan@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |damjan@apache.org
--- Comment #2 from damjan@apache.org ---
<TR>
<TD WIDTH="35" HEIGHT="17" ALIGN="center">SEP</TD>
<TD WIDTH="19" ALIGN="center" SDVAL="2" SDNUM="2057;">05</TD>
<TD WIDTH="47" ALIGN="center" SDVAL="7.30" SDNUM="2057;">7.30</TD>
<TD id="myTableCells" WIDTH="229">WCPF Members Disc</TD>
<TD id="myTableCells" WIDTH="211"> </TD>
</TR>
AOO uses the values from the SDVAL fields instead of between the <TD> and </TD>
tags that web browsers show.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127105] Paste from web page changes figures
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127105
Peter <le...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jes@martnet.com
--- Comment #5 from Peter <le...@gmail.com> ---
*** Issue 88071 has been marked as a duplicate of this issue. ***
--
You are receiving this mail because:
You are the assignee for the issue.