Users should be able to copy HTML straight from web documents and, when pasting into Calc, have formatting preserved as far as reasonably possible. For example, a very recognisable and common tag is <SUP>, which formats text in superscript. This is supported in Writer, but not in Calc. I am using the command `xclip -o -selection clipboard -t text/html` to view the actual contents of the clipboard, using the text/html media type. Strangely, when copying from Writer into Calc <SUP> is respected, whereas when copying from a standard browser such as Firefox it is not. Even more confusing, copying from Calc does not include <SUP> in the HTML, yet when pasting back into Calc or Writer *invisible superscript markings are respected*. I don't see how this last point is possible, but I assume there is either something hidden in the clipboard contents which xclip is not extracting, or the LibreOffice runtime is sharing special data within itself regarding the clipboard. # Results The ^ notation is used to denote superscript. ## Copying a^2 from Firefox xclip: > <meta http-equiv="content-type" content="text/html; charset=utf-8">a<sup>2</sup> Calc: a2 Writer: a^2 ## Copying a cell containing a^2 from Calc xclip: > <!DOCTYPE html> > <html><head> > <meta http-equiv="content-type" content="text/html; charset=utf-8"/> > <title></title> > <meta name="generator" content="LibreOffice 7.6.0.3 (Linux)"/> > <style type="text/css"> > body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Liberation Sans"; font-size:x-small } > a.comment-indicator:hover + comment { background:#ffd; position:absolute; display:block; border:1px solid black; padding:0.5em; } > a.comment-indicator { background:red; display:inline-block; border:1px solid black; width:0.5em; height:0.5em; } > comment { display:none; } > </style> > </head><body> > <table cellspacing="0" border="0"> > <colgroup width="85"></colgroup> > <tr> > <td height="17" align="left">a2</td> > </tr> > </table> > </body></html> Calc: a^2 Writer: a^2 [although 2 is rendered in the "Lohit Devanagari" typeface] ## Copying a^2 from Writer xclip: > <!DOCTYPE html> > <html> > <head> > <meta http-equiv="content-type" content="text/html; charset=utf-8"/> > <title></title> > <meta name="generator" content="LibreOffice 7.6.0.3 (Linux)"/> > <style type="text/css"> > @page { size: 21cm 29.7cm; margin: 2cm } > p { line-height: 115%; margin-bottom: 0.25cm; background: transparent } > </style> > </head> > <body lang="en-GB" link="#000080" vlink="#800000" dir="ltr"> > <p>a<sup>2</sup></p> > </body></html> Calc: a^2 [although the typeface is now blank] Writer: a^2 # Expected results At the very least, <SUP> should be respected in Calc. Characters contained within <SUP> tags should *always* be rendered in superscript, regardless of the particulars of the rest of the clipboard.
test page https://www.w3schools.com/tags/tryit.asp?filename=tryhtml_sup Reproducible with Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d8dbf35c48698e49c527d740853ce4edc4f1afa9 CPU threads: 4; OS: Linux 6.2; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Dear Dom [:ator], To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug