Last Updated: 06 Jun 2022 09:31 by Patrick
Created on: 06 Jun 2022 09:31
Category: SpreadProcessing
Type: Bug Report
SpreadProcessing: Renaming a sheet to a name with empty spaces, does not add single quotes to new name in formula references. This invalidates said formulas.

For example:
Renaming a sheet named "Sheet1" to "Sheet 1", should update formulas references to it to 'Sheet 1!' (notice single quotes), which it does not. The formula =SUM(Sheet1!A2:C2) changes to the invalid expression =SUM(Sheet 1!A2:C2). This breaks formulas referencing that sheet.

Iterate all cells with formulas in the workbook and add single quotes to the beginning and end of sheet name reference. The attached project changes the name of Sheet1 and then fixes all formula references to it by enclosing its name in single quotes.

Attached Files: