Login Page - Create Account

Support Board


Date/Time: Sat, 18 May 2024 20:20:51 +0000



Post From: formula columns being overwritten in spreadsheet system for trading

[2019-03-08 00:29:30]
rabbitTrader - Posts: 16
In a spreadsheet system for trading, the number of formula columns is set to 16 (the default). The number of rows is set to 5. Anything entered in K3-Z3 is automatically copied down through the next 4 rows. Example: I enter "test" or "=J12*J13" in S3, and these values are copied down from S4 through S7. Equations that were running in these rows previously without issue are now overwritten to be identical to whatever is in row 3.

My first instinct was to painstakingly move all my equations to rows beyond row 7, but I'm worried there's something deeper going on here that needs to be addressed.

The issue persists after upgrading to version 1880 (x64).

Thanks.