Support Board

Date/Time: Fri, 03 May 2024 08:43:30 +0000

Post From: Out of memory error and all formulas erased. nonCLR 1090

[2014-02-09 21:59:00] Link To Thread - Link To Post [Go To First Post]
namlem - Posts: 94
Hello SC team, I wanted to calculate huge amount of rows using latest nonCLR SC. I noticed that memory went up to 3.9GB and then I got a message box "Out of memory" and SC terminated. I didn't have a chance to get a log file. I saw it had messages like "SC_MainWindow expection..." and within next SC start all formulas in SpreadSheet disappeared! This is second time when I rewrote my formulas for new CLR and can't normally work with this SC version. Here are 2 problems: 1. which I mentioned already - to prevent calculation on load - in my case I did a mistake (though 40k of rows to calculate is not too much) and sat too many rows to calculate, next time within a load I must wait and some time later hit the same "out of memory" error and SC terminates - so in this case, how can I reduce value for number of rows to calculate if I cant enter the platform? And 2nd issue - do what ever you want, but to lose formulas in Spreadsheet is no go, doesn't matter what kind of error occurred. I noticed, when I press "save all" spreadsheet's file size turns to 0 and after data is saved it has a normal size. Maybe make sense to do an intermediate backup copy of Spreadsheet before any operation with it?....