Not the same in Go-Office / NeoOffice
I have just tried to replicate the purported "bug" in NeoOffice, a mac port of OpenOffice based on Novell's branch Go-office, and it behaves just like Excel, i.e. it only changes visible entries. However, to me as a programmer, it seems more logical to apply edits to all cells with the same criterion, or at least to have the option to do so. Most Linux distros such as Ubuntiu and OpenSuse, use this build. Also I have used OOo on three platforms alongside M$ Office at work and never experienced the compatibility problems some other so-called professionals have. OpenOffice opens almost anything. MS Office is fine-tuned to open MS Office documents + RTF, which Microsoft helped define. I spent the best part of 3 months writing a PHP library to export to RTF, so I know what I'm talking aboit. OpenDocument is simply a more logical format that facilitates conversion between diverse systems. Don't let this FUD lead you to believe you need to shell out £200 on MS Office Pro. You don't. Even the Student Edition (currently discounted to £50) is rip-off compared to the much more complete free alternative OpenOffice. What we probably need is an OpenOffice Light, along the lines of proprietary Mac-Only IWork, but with clean HTML export.