We have a problem with preserving conditional formatting when combining workbooks. For example, wb1.xlsm and wb2.xlsx:
- wb2.xlsx has 3-Color Scale fromatting for A1 cell on "Tab2" worksheet;
- As a result, formatting for A1 on "Tab2" changed.
I tested the scenario against v18.104.22.168. It works fine in the new version. However, we use v22.214.171.124 in our production where the problem appears.We have a lot of complains from our customers. Please provide a workaround for v126.96.36.199 as we cannot migrate to the new version without comprehensive testing.