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.
Paste with wrong conditions format
Paste as its shown in calc. The same format and values.
User Profile Reset: No
I can't reproduce it in
Version: 220.127.116.11 (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
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)
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.
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.
(In reply to Eduardo from comment #7)
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: 18.104.22.168 (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
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 !
(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.