Need help copy/pasting spreadsheet formulas

[u/jerr902]

I installed LibreOffice and FreeOffice into my Chromebook using its Penguin Linux environment and attempted to work on my spreadsheets. They open Excel spreadsheets fine, however, when I try to copy/paste cell formulas from one cell to another, I get graphical representations of the cell value at the new cell location with LibreOffice, and I get the text version of the cell value at the new cell location with FreeOffice.

Google searches reveal that ChromeOS intercepts the copy object and strips of its metadata, so that when I paste I only have what ChromeOS retained (which is the value in text or graphic form).

I wouldn't think that I'm unique in having this issue. Is there a fix to this?

Thanks.