https://bugs.freedesktop.org/show_bug.cgi?id=81003
--- Comment #2 from Noel Power <[email protected]> --- (In reply to comment #1) > I got that error message in each LibO version I tested, the oldest being > LibO 3.3.3 and the newer being 4.4.0.0.alpha0+ (*) > > (*) Build ID: b9dca968c6fd0ab5ca140c65b0e54d153cd34986 > TinderBox: Win-x86@42, Branch:master, Time: 2014-07-18_22:51:20 > > I add BASIC expert to CC list to hear his opinion. > > that file loads fine in MS Excel Viewer the problem seems related to handling of the Date type (and specifically when that type is passed as a param to a formula) iirc there is some special handling or conversion for Dates in VBA mode (or something... tbh it's a long time since I looked at that stuff) If you rewrite the macro signature without the type specifier for the Date types it should work in both excel and libreoffice e.g. Public Function getCompound(initValue As Double, initDate, finalDate, intRate As Double) As Double so initDate & finalDate are treated as Variant types -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
