Josh (the blog)

Hey there. I’m Josh, a SydneyCanberra-based maker of Internets. I don’t update this very often.


@joahua

OpenOffice Calc and Base suck

I recognise this post is highly ironic in light of yesterday’s remarks about my not being able to use a spreadsheet in parody of Apple’s Mac/PC ads, but, please, let it slide.

So all I want is an enum field. Or a multiple choice box, easy to get in Excel.

Neither of these are available at time of writing. The term “enum” has only been mentioned on any OO.o mailing lists pertaining to Base nine times, ever. And it supposedly connects to a MySQL server. Yeah, right.

I guess it’s back to rapid prototyping of a web interface to deal with data entry, or using Excel/Access… sigh. This was meant to be the quick and easy (and open source) solution.