Open Office Question

[sasha_feather]

I am having this thing where my work looks fine in Open Office (ods), but when I go to save it to xls format, my pie charts disappear and are just blank squares! What is going on?!

ALSO where is "track changes" feature in Open Office??

*remembers to breath*

Comments

[j00j]

Talking through this stuff often helps, in my experience of doing tech support. Hm. What if you made a converted to XLS copy of the other ODS document you were pasting from? See if the charts are okay in that, then copy-paste them into your new Excel document where those charts were disappearing? I don't know exactly what you're doing with the data, so I don't know if it's actually a viable option, but it seems like it might be a workaround.

Also, this is a weird thing, so it might be worth submitting a bug report to the open office community if you feel up to it sooner or later-- it might mean that they will later figure out what in the code is causing this wackiness to occur.

[sasha_feather]

So, jesse_the_k and I figured this out just now, and apparently it is a known bug for ubuntu (or Windows, apparently) and open office; the way to fix it is to "paste special" and to then choose "gdi metafile" instead of "Star Object descriptor" (I am working in Ubuntu right now, but I assume it's the same/similar in Windows). I am taking your advice and copy/pasting from xls versions of the files. Thanks for your help!