Can no longer copy spreadsheet cells from libreoffice calc to another app like thunderbird and paste as html table. Was working in 4.1.1.2. No longer works in 4.2.0.x. Uninstalled 4.2.0.x, reinstalled 4.1.1.2, worked again. Desired action: - create spreadsheet in LibreOffice calc - open target app (in this case, thunderbird, create new email message) - copy cell range - paste into thunderbird message - from LO calc 4.2, nothing happens. from LO calc 4.1, paste works fine
Hi No problem for me... There mus be something elase wrong on your system? Pls ask the user-support. For exmaple there is a group of users with a great variety of skills that can offer help with questions: http://www.libreoffice.org/get-help/ Regards, Cor
I know that you said you could not replicate the problem but I am now having the same problem on my system and so is a co-worker. If you'd be so kind Cor Nouws, could you please try once more and make sure? I agree that it's possible it is some other issue with the machines, but it may also be possible that you made a mistake with program versions or something. Thanks for your hard work and sorry if I mis-set any fields on this response (like "invalid")....I am new to this process.
Update - I can copy from calc to writer, so perhaps it's a Thunderbird issue not a calc issue? Just a thought... Also if I save the file as .XLSX first it still doesn't work. If I make an XLSX spreadsheet using Excel though, it works.
I can confirm the problem. Write some content with formatting in Calc. Copy it and paste it "as HTML". It failed in: Seamokey Composer Excel 2010 Word 2010 In Editor PSPad I can insert it as HTML-Source. There I notice, that it has the doctype <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> and tags in lower case. Previous versions (e.g. Version: 4.2.0.0.alpha0+ Build ID: 8624906bc437b242ea0df17801bc77d0f273f32c TinderBox: Win-x86@6, Branch:master, Time: 2013-07-05_04:07:10) had doctype <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> and tags in upper case. With that paste works in the other applications. I use Version: 4.3.0.0.alpha0+ Build ID: 160db96a882a2be8c3307e8a04beda4ae93a13c4 TinderBox: Win-x86@39, Branch:master, Time: 2014-01-19_09:25:52 on 32-bit Windows 7.
That is a thought, and I tried that, too, but it felt like it was pasting not as HTML in writer but more as an OLE object (or equivalent - I am showing my age with that one...). And again, LO 4.1.1.2 pastes just fine. I uninstalled 4.2.x.x and downgraded back to the earlier version. > Comment # 3 on bug 74584 from biocidedevelopmentcorp@gmail.com > Update - I can copy from calc to writer, so perhaps it's a Thunderbird issue > not a calc issue? > > Just a thought... > > Also if I save the file as .XLSX first it still doesn't work. If I make an > XLSX spreadsheet using Excel though, it works. > You are receiving this mail because: > You are on the CC list for the bug. > You reported the bug.
I reverted to ver 4.1 and it works well so it definitely is caused by ver 4.2
Hi, It works fine for me, so looks as a Windows specific problem. Someone was so friendly to mail me directly to confirm the existence of the problem form him. Regards, Cor
I can confirm the problem with windows 7. Write some content with formatting in Calc. Copy it and paste it in a text area in my browser (chrome) and you get only the content (no formating). used to work fine before.
I can also confirm this bug. After upgrading to LibreOffice Version: 4.2.0.4 I cannot paste selected text or Calc cells into Mozilla Thunderbird email body. I can paste the clipboard contents into Notepad, or into Thunderbird Subject box. I can also paste it into Firefox Form fields like this one: (EXAMPLE COPIED TEXT) In Thunderbird it seems to paste a "backspace" instead of the actual text if you have a signature text in the email body. HTML Before paste attempt: <br> <div class="moz-signature">-- <br> <b>Ivan Williams <br> <br> </b></div> HTML After paste attempt: <!--DOCTY--><!--DOCTY--> <div class="moz-signature">-- <br> <b>Ivan Williams <br> <br> </b></div> However RightClick -> Paste Without Formatting does still work.
I'm seeing this same behavior. Cannot paste from 4.2.0.4 (Windows XP x86) into Thunderbird when composing in html mode unless you do "paste without formatting".
This is my work around: Save LibreOffice document as HTML document. Open in your favourite browser. Copy from browser and paste into Thunderbird. This way you retain formatting such as tables and font.
Find this report too late (my bugreport was 74806). I can confirm the behavior. Under Win 7, copy several Spreadsheets cells in Libre Office version 4.2.0.4, and pasting them into a new Thunderbird message (version 24.3.0), does not work. A paste without formatting works. It works under Libre Office 4.1.1.2. Richard
*** Bug 74806 has been marked as a duplicate of this bug. ***
(In reply to comment #4) > I can confirm the problem. Write some content with formatting in Calc. Copy > it and paste it "as HTML". It failed in: > Seamokey Composer > Excel 2010 > Word 2010 > > In Editor PSPad I can insert it as HTML-Source. There I notice, that it has > the doctype > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > and tags in lower case. > Previous versions (e.g. Version: 4.2.0.0.alpha0+ > Build ID: 8624906bc437b242ea0df17801bc77d0f273f32c > TinderBox: Win-x86@6, Branch:master, Time: 2013-07-05_04:07:10) had doctype > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > and tags in upper case. With that paste works in the other applications. > > I use Version: 4.3.0.0.alpha0+ > Build ID: 160db96a882a2be8c3307e8a04beda4ae93a13c4 > TinderBox: Win-x86@39, Branch:master, Time: 2014-01-19_09:25:52 > on 32-bit Windows 7. Also fails in Yahoo Mail
This problem also come in our company. We need to revert back old version until this problem solve in current version.
It's as easy as 1. Copy a range from calc 2. Attempt to paste into a gmail body a. In Firefox 27.0.1, the cursor blinks but nothing else happens. b. In Chrome 32.0.1700.107, I get the table unformatted This is fairly important in my company. I can't submit my time sheet. :-)
Ditto on the importance. How do we get somebody assigned to this bug? More posts? Get all your colleagues to submit?
Please don't add any more noise here. That would only repel people from looking into it.
I got this. Looks like someone's "cleanup" of lower-casing the html tag names caused has this regression. On Windows, the HTML tags *must* be uppercase.
*** Bug 74537 has been marked as a duplicate of this bug. ***
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3d481254a07fe82d11953f9825a2f8fc6eeabc0b fdo#74584, fdo#74537: HTML tags *must* be UPPERCASE. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
4.2 backport request: https://gerrit.libreoffice.org/8132
BTW, Regina's comment in Comment 4 about the tags being lowercase helped me find the cause. Thanks a lot.
Unfortunately the change affected the HTML detection code. Looking into it.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1f74a3ce201bad68f160584900285e2c087ab2c0 fdo#74584: Upcase the tag name before searching. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
by way of a failing unit test i noticed there were some followup commits that needed to be reverted too...
Michael Stahl committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=96a1f60aeb2a7954533da9b4aa4947efb7a65e70 fdo#74584: Revert "html: Options need to be lowercase, too" The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Michael Stahl committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3c84fa61570113d1dfb2523ab88f268eeeb46c3c fdo#74584: Revert "fix html tests" The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
is this a duplicate of bug #74738? there ist the same problem with LO writer
*** Bug 74659 has been marked as a duplicate of this bug. ***
*** Bug 74674 has been marked as a duplicate of this bug. ***
*** Bug 74738 has been marked as a duplicate of this bug. ***
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f1f8b3bfdc3406ea79b662a2fda3d0c1cb87bb10 fdo#74584: Revert various previous changes to upcase HTML tags. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=88c6cbda921f1e3627910f9028ff2e29f26160e7 fdo#74584: These tags should be lowercase for correct clipboard handling. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Here is a better fix for 4.2: https://gerrit.libreoffice.org/8154
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3ba02e9ec03df980803f35c4b16ce8b8ce90cb66&h=libreoffice-4-2 fdo#74584: These tags should be lowercase for correct clipboard handling. It will be available in LibreOffice 4.2.3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Caolan McNamara committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=456b92609cdd0795e165ca4487419d1f329bb158 fdo#74584: complete revert various previous changes to upcase HTML tags The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9ffb9d0baa22f85cc7c22a198760f90a4a857458&h=libreoffice-4-2-2 fdo#74584: These tags should be lowercase for correct clipboard handling. It will be available already in LibreOffice 4.2.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 75312 has been marked as a duplicate of this bug. ***
Finally fixed. Finally.
To Kohei Yoshida and all the other developers involved, I thank you.
Did this make it to 4.2.1?
(In reply to comment #42) > Did this make it to 4.2.1? Unfortunately no as 4.2.1 is already released. It will be in 4.2.2 that will be released in about 2 weeks.
Wonderful! Thank you all for you hard work, making LO a amazing office suite and fixing bugs!! Maarten 2014-02-21 18:40 GMT+01:00 <bugzilla-daemon@freedesktop.org>: > *Comment # 43 <https://bugs.freedesktop.org/show_bug.cgi?id=74584#c43> > on bug 74584 <https://bugs.freedesktop.org/show_bug.cgi?id=74584> from > Tomaz Vajngerl <quikee@gmail.com> * > > (In reply to comment #42 <https://bugs.freedesktop.org/show_bug.cgi?id=74584#c42>) > > Did this make it to 4.2.1? > > > Unfortunately no as 4.2.1 is already released. It will be in 4.2.2 that will be > released in about 2 weeks. > > ------------------------------ > You are receiving this mail because: > > - You are on the CC list for the bug. > >
*** Bug 74381 has been marked as a duplicate of this bug. ***
*** Bug 75396 has been marked as a duplicate of this bug. ***
*** Bug 75402 has been marked as a duplicate of this bug. ***
*** Bug 75417 has been marked as a duplicate of this bug. ***
*** Bug 75184 has been marked as a duplicate of this bug. ***
*** Bug 74949 has been marked as a duplicate of this bug. ***
*** Bug 74638 has been marked as a duplicate of this bug. ***
*** Bug 75575 has been marked as a duplicate of this bug. ***
*** Bug 75606 has been marked as a duplicate of this bug. ***
*** Bug 75677 has been marked as a duplicate of this bug. ***
*** Bug 74513 has been marked as a duplicate of this bug. ***
It did not work! I just installed 4.2.2 only text are pasted not the table
I have today installed 4.2.2 RC on a couple of Windows 7 and Windows 8.1 machines and copy - paste works fine. I have copied from Calc to Windows Live Mail and the table has been copied along with single line borders. I had un-installed the old version before installing this version. There was another problem in one of the PCs and it was rectified by reseting the User profile. This is how it was done: 1. Close Libre Office (including quickstart from system tray) 2. Open folder %appdata%\libreoffice\4 3. Rename folder "user" 4. Open Libre Office
*** Bug 75842 has been marked as a duplicate of this bug. ***
Created attachment 95314 [details] ODS saved to XLSX file, no fram controls in Excel.
Comment on attachment 95314 [details] ODS saved to XLSX file, no fram controls in Excel. not-related to this bug. Sorry for the noise (currently guiding attacher at IRC). Ignore it please :)
*** Bug 75266 has been marked as a duplicate of this bug. ***
*** Bug 75522 has been marked as a duplicate of this bug. ***
Confirmed fixed: can now paste both Calc region and Writer document via copy from LO to Thunderbird. LibreOffice: Version: 4.2.2.1 Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f Thunderbird: 24.3.0 OS: Windows 7 Home Premium SP1 (64-bit) Thank you!
*** Bug 76262 has been marked as a duplicate of this bug. ***
Created attachment 95984 [details] Original picture copied to MS Paint.
Created attachment 95985 [details] Copied picture in clipboard as Metafile.
Created attachment 95986 [details] Copied picture in clipboard as Picture.
Created attachment 95987 [details] Copied picture in clipboard as Bitmap.
Hi, I am using Libreoffice 4.3.2.1 I can still confirm that this bug affects copying pictures to the image editor called Irfanview on Windows XP SP3. Upon further investigation it can be said that there is some problem in Libreoffice about copying pictures to Windows clipboard. Please note that Ms Paint can render the copying picture correctly. However there are 4 types of clipboard data in memory when copied from Libreoffice and except one, they are corrupted. Therefore some image programs rendering corrupted image when pasted. Example; Please check attached picture files. 1- Original picture copied to Ms Paint. (orj.jpg) 2- Original picture copied and Windows Clipboard is being used to display contents, using (view--> Enhanced Metafile) (metafile.jpg) Please notice the difference in the image compared the orj.jpg 3- Original picture copied and Windows Clipboard is being used to display contents, using (view--> Picture) (picture.jpg) Please notice this is a correct display of the image which MS Paint probably using to import. 4- Original picture copied and Windows Clipboard is being used to display contents, using (view--> Bitmap) (bitmap.jpg) Please notice the corruption in the image. A lot of image software could be using the bitmap format for pasting images , and they would get corrupted image from Libreoffice most of the time. 5- There is a clipboard data type Dib Bitmap but it can not be displayed in clipboard viewer so I pass that one. Not every image is being affected as severe as the ones I attached, however this is affected every copied image from Libreoffice. The only workaround I have is to paste the image to MS Paint first. Later cut the image from MS Paint , and paste it to any software I want. It works without any corruption. However this is very annoying to use this workaround instead of pasting directly to an image editor. Best Regards, Burak Ural
Hi Burak, Thanks for reporting this but the bug you describe has nothing to do with this bug (except both happen at copy/paste). The problem of this bug was that we changed html tags from upper-case to lower-case and unintentionally broke some things that relied on upper-case tag names. Can you please open a new bug for your problem. I remember seeing a bug related to irfanview and copy/paste - maybe try to find that one. Regards, Tomaž
Hi Tomaž, I had previously reported this as a new bug 75522. However Joel Madero marked it as a duplicate of 74584. How should I proceed , I am new here :) Regards, Burak Ural
Ah.. I see. Sorry I didn't know the original bug was marked as duplicate. I have reopened that bug as I think it is not related to this one. Please can you copy everything to that bug. I will take a look at it during weekend. Sorry for the inconvenience, you did everything correct. :) Regards, Tomaž