Is libreoffice compatible with bloomberg terminals in the same way that excel is?

when i copy and paste values from bloomberg to calc, i don’t get all the data that i should be getting?

Try with Paste special, select unformatted text, there you can specify the data type for every column.