A spreadsheet will hold anything you type into it, in any order, with no complaints. That's the whole appeal, and it's also the entire problem. There is nothing checking whether a rent figure got typed into the wrong row, whether a formula that used to sum a column still sums the whole column after you inserted a row above it, or whether the version you're looking at is the version your co-signer edited an hour ago from a shared drive.
I ran my properties out of one for years. It worked, in the sense that nothing caught fire. It also meant every number I looked at came with a quiet asterisk: probably right, unless I fat-fingered something, unless a formula broke, unless I forgot to update it after a call with a tenant.
The moment it actually broke was small and dumb. A dragged formula that stopped including the last two rows after I added a property. Three units quietly stopped counting toward my occupancy total for about six weeks before I noticed the math didn't add up. Nothing catastrophic happened. It could have.
Software that's actually built for this doesn't let a dragged formula silently drop three units. The rent roll isn't a formula you maintain by hand, it's a fact the system already knows, because you told it once when you set up the lease.
A spreadsheet is a blank page that happens to have gridlines. Rental properties deserve something that actually knows what a property, a tenant, and a lease are.