Thanks guys.
Firstly, yes i have always charged the battery while switched off which i presumed was correct, including while doing these checks.
Secondly, even after last night's 4 hours charge, just now there was only 1 LED lit and after riding for 5 seconds it completely died so last night's charge actually didn't do anything.
Third, see picture for proof of me testing the battery while on. Again it shows 32.7. I then used the probes to check the charging socket with the battery on and it shows 0v. For completeness i then checked the charger while switched on and it read 41.5v.
Just to clarify something as well, there has been a couple of times over the last couple of years that it may have been more than a few months without use but i always charged it before putting it away. Also I'm not sure if it was as long as 3 months in between uses. It was always stored in a dry shed on a shelf so wasn't at risk of damp or heat.