EPPlusSoftware
Copying row in a sheet does not copy conditional formatting
Opening a worksheet with EPPlus 5.6.4 (and older versions) and copying a pre-formatted row using
ExcelWorksheet.InsertRow(int rowFrom, int rows, int copyStylesFromRow)
does not copy conditional formatting. Normal formatting and contents are copied just fine.
In this case the conditional format was on one cell in the row. It was "Format only cells that contain" and then "No blanks" Background color = yellow. using the excel GUI to set it up.
The expectation is that conditional formats are copied, too.
Yes, currently only cells styles are copied with this parameter. Conditional formatting is another functionality, but as you say it might make sence to copy it too.
@JanKallman Is this something that is planned to be changed? From my testing the conditional formatting being copied is quite unexpected/strange with the position(s) of where it is copied to, if it is copied at all. It's been hard for me to re produce consistently - if I create a consistent test that shows this I will attach that test.
Hi, we've been making a lot of changes to conditional formatting lately. If you're able to provide a consistent test I'll gladly help you resolve any copy issues/bugs.
