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...