Support Board

Date/Time: Sun, 19 May 2024 19:22:40 +0000

Post From: Formula disappering in spreadsheet study

[2015-07-08 22:53:32] Link To Thread - Link To Post [Go To First Post]
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