Hi list.
I have tried saving an ODS file that uses the function doobieMult() from
the DoobieDoo Calc add-in example (see
http://www.biochemfusion.com/doc/Calc_addin_howto.html). That works
fine. You can get a copy of the file via
http://www.biochemfusion.com/doc/doobie-func-example.ods
However, when I export the spreadsheet to .XLS format and open it again
I get nonsense back :-(.
1) Excel 97/2000/XP The cell formula tries to reference
DOOBIECONCAT() instead of doobieMult() - with obvious wrong results.
2) Excel 95 The cell formula reads "(#NAME?;A1;B1)" - does
not work of course.
3) Excel 2003 XML The cell formula is blank, while the sheet cell
displays "of:]=COM.DOOBIECOMPANY....DOOBIEMULT([.A1];[.B1])"
Did I miss something while creating the add-in or is this an actual bug
in OOo Calc import/export filters ? I badly need this or my end-users
won't be able to exchange sheets across OOo and Excel.
OS: Windows XP
OOo version: 3.0.1 build 9379
Kind regards
-- Jan Holst Jensen
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org
For additional commands, e-mail: dev-h...@api.openoffice.org
