Suppose you have an excel report where you some numbers to validate and that excel file has some logic such as cell A is greater than cell B then show cell C as green.
Now let's say you have a framework that allows you to write tests that validates cell A and B but not C.
Obviously the user will validated every cells that the user is interested in.
So you can see there is a gap between how the user would test the report and how the framework available verifies.
How do you guys tackle those type of situations? How do you write a test that mimics user interactions from A-Z? Do you compensate the gap with something else (i.e. manual testing)?