https://bugs.freedesktop.org/show_bug.cgi?id=79588
--- Comment #1 from Eike Rathke <[email protected]> --- It could be easier if you would actually give a hint what exactly fails where and when. For example, on sheet Hilfsfelder in H6 there's a formula that uses handelmonat and handeljahr (probably the macros you mentioned), but the entire document does not contain any definition for those so there's already a #NAME? error. Similar for the name jahreingabe in F12. If a name can not be found it's occurrence is changed to lowercase in the formula, but that's just a symptom, not the cause. Might be that these were defined in a profile wide macro library that either isn't present anymore in your installation or isn't accessed by the saved document but only from the template file. Sorry, but as given without these macros and a description where exactly they are located there isn't much we could do. Please provide the necessary information if possible. Furthermore, some named expressions use the DATEVALUE() function (German DATUMWERT) with a locale dependent string argument. This will work correctly only in a de-DE (German-Germany) locale but may give Err:502 in other locales. Either make sure you didn't change locale on your system or better use the locale independent DATE() function instead (which takes numeric arguments instead of strings so may need some rewrite of your expressions). There are also other expressions that rely on the German date format. Last but not least, something seriously broke the formulas on sheet Drucken in columns B and K, they contain series of concatenated #REF! errors. This already in the .ots you attached. -- 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
