Login Page - Create Account

Support Board


Date/Time: Mon, 16 Sep 2024 19:20:18 +0000



Post From: Spreadsheet Study Programming Disappears After Saving?

[2015-03-14 18:09:04]
GiantAvocado - Posts: 67
I performed the upgrade and still have SC crash when I paste or type this formula into the column X:

=IF(Y3=0,X4+Z3-Z4,IF(Y4=0,Y3,X4+Y3))

attached a sample of the sheet pasted into Excel as values.



This would mean that you have a chart with number 22 that contains a Spreadsheet study.
Thx... I deleted chart #22 and sheet #22.

What specific Sheet column are you entering data into? For that particular Sheet number is there a chart with the same number that has a Spreadsheet study?

I believe nothing happens because there is this message in the log:

Chart: ESM5 [CB] Renko 2t #23 | Study: DefaultSpreadsheetStudy | Exception occurred while calling study function. | 2015-03-14 13:54:30 *

For your information: see example attached in Excel (Book1.xlsx), I copy and pasted the values into Excel with the formulas in text above columns X,Y,Z and hi lighted the good working formulas in green and the error formula in red. This is for chart #23 and is sheet #23 of the default spreadsheet.


attachmentBook1.xlsx - Attached On 2015-03-14 18:07:09 UTC - Size: 13.42 KB - 439 views