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

[sasha_feather]

e.g. are they staying in the ODS file, and are they then visible in the XLS file when opened in Open Office, and are they visible in Excel if you have it?

Nope! They are only visible in the ods file. Well there are a couple of charts visible, and I thought about this: they are ones that I made fresh, rather than copy-pasting from a different, compiled-data ods file that I had been working off of. Those are the ones that mysteriously vanished. The fresh ones, internally created, persisted.

You know I feel less anxious just talking through this, so thanks. :)

[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!