How to know when a bet has been cancelled?

[GeorgeUK]

Funky - i would doubt it.

Once the data is deleted, i would assume it's gone. For keeping a note of partial matches, i'd add another column - and maybe but it back in the appropriate column after the cancel

[Mitch]

If you want to test it, put £4 on an event which hasn't any offers on the Lay side at odds that no-one will give you.
Then take £2 of it yourself and cancel the rest.
Then put the bet ref from the original bet in col. N

I'm fairly sure it will tell you the matched odds and stake. I made a sheet a while back which had to keep track of about 20 bets and that's the way I did it. You don't even have to put the bet ref on the same row as the selection it was made against. Very useful!