Why aren't dynamic drop down lists working when I transfer excel to Libre mac

when I transfer my windows excel file with dynamic drop down lists to Libre for my mac I am getting errors

@alishanley - What file format do you use when you transfer to PC?
I would use ods, which means you better run LIbO on your Windows and Mac machine.

I could make a test using LibO on a Mac OSX 10.6.8 and on a Windows machine XP/SP3. The drop down list work fine on both machines. File format ods.