Hi Gordon, it seems I should put something about the "Add-In tab" into the FAQ ;)
In older versions of MS Office, you see the tool bar immediately, but not in Office 2007, where you need this extra step.... > Any other way of opening the ods document strips out the formula, even > with the Sun plug-in installed. Right - unfortunately, for Excel and PowerPoint I didn't find a way to implement the same neat integration like in Word :( See http://www.sun.com/software/star/odf_plugin/faqs.jsp Malte. Gordon wrote, On 05/13/09 11:00: > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
