Conditional formatting cannot be displayed when pasting using the camera method.

When I paste the table into a different area (using the camera method), the formatting for some cells is not properly displayed. These cells have “Conditional Formatting” applied, and their colors change based on their content. When I make changes to the original table, I can see that there is no issue and the colors update correctly. This problem also occurred when I used the table as a “linked image.”

Visual Explanation;

• 

  (The original table is on the left; on the right is the same table pasted using the camera method. Both are in the same file and tab.)

• When I copy and paste the hidden rows separately (using the camera method again), the conditional formatting appears. In other words, there is no specific issue with the rows where the “formatting styles” cannot be displayed properly:

  
  • Unfortunately, I didn’t get any results when I tried the “shake” method.
• • When I tried it on a new worksheet, the result remained the same.
  • I also tried the “Repair Office” option, but the problem persists. Could there be a row height limit when copying this type of table using the “camera tool” (when capturing screenshots of conditional formatting)

• • When the total row height in the tables exceeds a certain value, the “conditional formatting” properties of the table I move to another location using the “camera tool” do not display.
  • When I copy 26 rows to another location with each row set to 32.75 units in height, all properties are displayed; however, when I change it to 33 units in height, the formatting starts to break. And this total value (26 × 32.75 = 851) isn’t consistent either. When I try to set individual height values for the cells to reach a total height of 851, the issue isn’t resolved. Sometimes I get proper display when the total height is 777, and sometimes when it’s 661.

What do you think is the root cause of this problem I’m facing? How can I solve it?

Office Version Information:

Ref: 

https://learn.microsoft.com/tr-tr/answers/questions/5861040/excelde-tabloyu-ba-l-resim-olarak-yap-t-ramama-sor