Support Board
Date/Time: Sun, 09 Feb 2025 04:23:32 +0000
Post From: Own calculations on Quote spreadsheet, cell references not updated
| [2020-08-04 12:29:33] |
| TeeJay - Posts: 123 |
|
Is it not possible to use own calculations on quote spreadsheets with updated cell references. I have the settings for spreadsheets to update cell references in global settings but it does not work. E.g. my quote spreadsheet uses columns A to S for the quote data. If I then have own data and formulas in T to Z and I have e.g in Z2 the formula =Z1*G9(G9 content of quotes) and I then append some symbols to the quotes the content of G9 is shifted down like intended, but the formula in Z2 stays Z1*G9, which of course is wrong then. Is this intended like that? Thanks |