|
|
|
|
|
by rickdeckard
458 days ago
|
|
> I wish someone also solved the issue with excel around refactoring though - esp when cells are being used in formulas, if there was a "Find All References" or Cmd+SHIFT+F (global find) of elements used in formula (not their values) - it would step it up even more towards maintainability. I usually handle this in MS Excel by searching "in workbook" and "in formulas".
Works even better when the elements are in a named cell which is referenced in formulas (i.e. "stat.infra.APIrequests" instead of "$A$5"), this way you can also globally change the element by reassigning the cell-name to another cell |
|