Niklas Nebel wrote:
On 05/13/09 07:29, Gordon wrote:
Doesn't work.
If you have Office 2007 SP2 installed AND the Sun plug-in, the issues
still remain with ODS formulae. Presumably SP2 over-rides any third
party plug in, and there's no way (AFAICS) to disable the SP2
"support" for ODF...
See http://blogs.sun.com/malte/entry/using_the_sun_odf_plugin.
Niklas
I have just discovered how to do it.
Ensure the Sun plug-in is installed.
In Excel 2007, click on the Add-In tab. Click on the "Import ODF
Document" icon in the Custom Toolbars section. Navigate to your ods
document.
I've just tested this and it preserves the formulae.
Any other way of opening the ods document strips out the formula, even
with the Sun plug-in installed.
HTH
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
