Support Board
Date/Time: Wed, 10 Sep 2025 13:32:34 +0000
Post From: SC Quits when Paste Large Formula into Spreadsheet Window
| [2016-04-06 14:02:16] |
| User791263 - Posts: 151 |
|
UPDATED (this section posted in new post below) I though might be Possible INFINTE or Undeterminate Value in Formula. It is not. It's something strange. Perhaps a circular reference, such as K3 referring to NOT L3 true, and vise versa. Just adding one term: L3=0 caused K then shut down the SC instance w/ no warning. I did several tests, pasting a little at a time. Nor has the problem anything to do with size-characters limit (althought these are big 2200 ch. forumlas). I'm going to Post this part as a new post in this thread, so the disregard can be negated. Will provide additional details as available. - - - - BELOW is Original post This behaved same under 1382 as 1392. I've seen this consistently now, when my K column formula gets up to about 2160 (est) characters, pasted into New Spreadsheets >> view window, when I hit "OK", that window closes, then .5 second later, my whole instance vanishes- gone. I keep that window inside the spreadsheet view. That spreadsheet is not detached. I only use NOTEPAD to avoid special characters, and it does not do this on smaller formulas. This has only grown this big lately, so I think that may be the cause. I do have line feeds at each condition, about 36 lines. I can't use other columns to split the formula-- they're all used up as components of K, M, etc. I shut down, reboot, even, but still same behavior. Have I hit a formula characters limit? Any ideas? Obviously I can't refine and develop on that while trading. Date Time Of Last Edit: 2016-04-06 17:16:22
|