Support Board
Date/Time: Sun, 22 Dec 2024 05:14:36 +0000
Post From: Formula disappering in spreadsheet study
| [2015-07-08 22:53:32] |
| User224651 - Posts: 28 |
|
I have a chart book with 5 charts in it. Each chart has a spreadsheet study attached to it. The spreadsheets do not query each other for data. recently the formula in the spreadsheet studies has begun disappearing from cell ie. cell k3 is "=if(ap3=1,1,0)" I change it to "=if(and(cf3=0,ch3=0,ap3=1),1,0) I reload the chart attached to the spreadsheet to allow the formula to propagate down column k. I check cell k3 and it reads =if(ap3=1,1,0)" Cell M4 contains "if(aq3=1,1,0)" next I delete the formula in cell m4 I reloaded the chart attached to the spreadsheet. Cell M4 contins the original formula, "=if(ap3=1,1,0)" Is this a known behavior? Is it possible to repair the chartbook/ spreadsheets? Are there steps I can take to avoid this behavior in the Future? All the best, Alex |