I have a spreadsheet in which one column has conditional formatting.
I insert some blank rows. I then copy from a row that has formulas but no data, in order to populate the blank rows with formulas before entering data in them.
The column with the conditional formatting contains a formula which evaluates to zero unless there is an error in the data that I entered. This column is formatted to show in red, but the conditional formatting displays this in pale grey if it is zero.
Before I enter data, this evaluates to zero, but in the newly pasted rows it shows red. If I copy a cell from that column (rather than a whole row), and paste it on there, it correctly goes grey. This is true whether I copy from a cell that is displaying correctly or one that is displaying incorrectly. I can even copy a cell onto itself, and it turns from red to grey.
If I save the spreadsheet, close LibreOffice, and open the spreadsheet again, all rows display correctly, but any further rows I insert display incorrectly again.
I copy some data from a bank statement I downloaded, and the column correctly shows an error until I enter data elsewhere in the row. I now find that sometimes the error column remains red when I have entered the correct data and cleared the error. After I sorted the spreadsheet, this now happens in the rows I inserted, in the new locations where they have gone - i.e. they have taken the problem with them. This behaviour is not consistent - usually the error column behaves correctly, going grey when I clear the error.
Where I have copied and pasted cells (or formats) to correct the conditional formatting, it creates new regions on the list of conditional formatting, which could bloat the spreadsheet in the long term
The spreadsheet was created in OpenOffice 4 under Windows 7, where it worked correctly; I have only just migrated to LibreOffice 5.4.7 and Windows 10.