Support Board
Date/Time: Sun, 12 Jan 2025 23:57:11 +0000
Post From: Replace tool for spreadsheet studies
| [2017-03-07 02:12:09] |
| User553714 - Posts: 184 |
|
Medium term can you please consider adding a find & replace menu tool for spreadsheet studies? I think this may be fairly involved so there is no hurry. The main reason for requesting this is to deal with changing formulas in multiple sheets, specifically for the sheet numbering (Global settings >> Spreadsheet settings >> Update references) does not change the sheet numbers; quite often I will develop a strategy in one sheet which I then need to replicate to all the sheets in a chartbook. This means I have to manually change every formula in subsequent sheets which have a "Sheet1!" reference to the new sheet number, Sheet2, Sheet3, etc.. Not only is this cumbersome and time consuming worse still is that it's almost certain that you will make an error somewhere in the process and reference the wrong sheet. Having the ability to search the sheet formulas will quickly and easily remove this risk. Regards |