Description: I have some cells in libreCalc. In fact a table with names of pupils and their marks. In the mark sell i have a condition ( paint background red if mark is less than zero and greater than 10, just to avoid typing errors). When i copy this table to moodle or word, it appears the cells with background red, although the cell value is correct. In librecalc appears with background white. If i delete the conditionals, it works as expected Steps to Reproduce: 1.Make a Cell with conditional format ( ex: background red with marks less than 6) 2.Put in the cell a correct value ( ex: 7). It shows ok in calc. 3.Copy the cells and paste it in Moodle or Microsoft Word.... It apperas the cells with background red, although the value is correct. Actual Results: Paste with wrong conditions format Expected Results: Paste as its shown in calc. The same format and values. Reproducible: Always User Profile Reset: No Additional Info:
I can't reproduce it in Version: 6.1.3.2 (x64) Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb CPU threads: 4; OS: Windows 10.0; UI render: default; Locale: de-DE (de_DE); Calc: To be certain the reported issue is not related to corruption in the user profile, could you please reset your Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and re-test? Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the issue is still present
Created attachment 147000 [details] copy & paste from calc to word
Created attachment 147001 [details] a simple conditional format example
Seems if i copy to writer dont happen... But in moodle and word happens... I have reseted profile. Your example seems to work The difference perhaps is that i use two conditions: value greater than zero and value less than D14 ( for example)
https://drive.google.com/drive/folders/1n6RGj110ZMEYQ3057m71a8lmgiXhDl5U?usp=sharing I have added a example which im currently working...the first column is the name of pupil the second the maximum of that question, i put a different color if the mark is less than zero or more than the maximum mark fot that question...As all the numbers are correct, calc shows it ok, writer also, but importing to excel, word and moodle ( at least) the appear the orange background ( the color assigned to cells that are failing the conditions. I can also send a mail or upload to that folder in google drive if you want to take a look. Thanks
Also making some tests, i noticed than in writer the paste default option is to paste as libreoffice calc object, but in word, excel and moodle is html.. So i guess the problem is special paste in html.
Here: https://drive.google.com/drive/folders/1n6RGj110ZMEYQ3057m71a8lmgiXhDl5U?usp=sharing
(In reply to Eduardo from comment #7) >https://drive.google.com/drive/folders i cannot find an example file, only jpg's. could you please attach a simple example file, where the bug can be reproduced?
Added calc example i thought that with jpg and my comments were enough... You can go for example to sheet Practica1...there are thre questions, with a maximum mark for each...there are now all correct, copy and paste whatever part of the marks and students an in jpg is shown...paste it in moodle, word, excel or in writer in html mode...you would see it shows as if the condition was not successs.....any more information tell me...there also some other bugs that i filled that you can also test....thanks for your help....
Created attachment 147220 [details] copy from lo to word and calc
Created attachment 147221 [details] copy from lo to word and calc with changed values
added to screenshots showing copy & paste from lo to word/excel.
Comment on attachment 147220 [details] copy from lo to word and calc Incredible...now it also works for me..... Just try another one M4* the sheet Pr1 Sorry for inconvenience ( i was not dreaming you can see the screenshots...)
(In reply to Eduardo from comment #13) > Sorry for inconvenience > ( i was not dreaming you can see the screenshots...) setting to resolved/worksforme :-)
Please try with this spreadsheet ive uploaded: called M4* the sheet Pr1...
confirming problem with extract from NotesM4XML1819B.ods
Created attachment 147289 [details] extract from NotesM4XML1819B.ods steps to reproduce: - open attachment - select B14:F18 - copy & paste into word - cell background changes
question is: is it a LibreOffice problem or a MS Office problem ?
Does it happen if it's pasted to another office suite? WPS, onlyoffice ?
Before i have added a google drive folder with two examples... I think is libreoffice, because both on moodle and microsoft word the paste is not correct. Also if you paste in writer with html paste mode doesnt work... As i guess is something related to html, you dont paste the same you copy...
Neither copy&paste for text works from Ms Outlook to LibreOffice Calc. Before current versione of LibreOffice : Versione: 6.4.7.2 (x64) Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5 Thread CPU: 8; SO: Windows 10.0 Build 19041; Resa interfaccia: GL; VCL: win; Versione locale: it-IT (it_IT); Lingua interfaccia: it-IT Calc: threaded The problem were solved doing a Save to CALC and then copy&paste was working. Now it's totally lost the function copy&paste outside from LibreOffice suite. The feature works only internally from/to LibreOffice suite applications. Please solve ! Best regards, Enrico C.
(In reply to Xisco Faulí from comment #18) > question is: is it a LibreOffice problem or a MS Office problem ? This can be reproduced within LO between Calc and Writer, and is a bug specific to the kind of paste used: - the default between Calc and Writer is now RTF paste (it was changed after this bug was opened, in 6.4, see bug 116685), - there's also HTML paste, this is the default when pasting into Word. While pasting in HTML/RTF in Word/Writer looks slightly different compared from one another, the background shows the same issue. Note that something changed between 6.0 and 6.1, previously when pasting the B14:F18 range from attachment 147289 [details], only E17 had orange background, while since 6.1 E14:F17 _except_ E17 has orange background.
Dear Eduardo, 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