bikewisperer – you are talking utter tripe – a spoke has no strength in compression at all. None. It just bends.
In a spoked wheel all the weight is hanging from the upper spokes – the bottom ones carry no load at all. None. Not 1 g of the weight.
At rest with no weight loaded all the spokes are in tension. When a load is applied the upper spokes gain more tension, the lower ones loose tension – thus the load is hanging from the top spokes.
where you are getting confused is the entire wheel has strength in compression. Put a load on the rim from the top of the rim the wheel wiill try to go eggshaped – but the spokes front and rear will resist this as the tension in them increases while the tension in the to and bottom ones decrease.
it basic mechanics. A spoke has no strength in compression whatsoever