Formula Translation should only modify cell references within specific sheets #4
Description
This is a tricky one. But not too hard.
Ideally, the translate method would take an argument which is a sheet name, and we should only modify cell references that contain a sheet name and the sheet name listed is the one that matches the argument. If no sheet name argument is given, we have to only modify cell references which don't contain a sheet name. This assumption comes from if a user doesn't provide a sheet name argument, odds are the formula they are trying to modify came from their current active sheet and any cell ref within that sheet won't feature a sheet name that points to itself. Confusing to type out but hopefully that makes sense.
Most of this can be done with simple string logic rules but ideally we should come up with a robust solution that involves both str parsing and dictionary parsing to check for these things within the translate method's processes.