https://bugs.freedesktop.org/show_bug.cgi?id=79588
--- Comment #2 from Bernhard <[email protected]> --- (In reply to comment #1) > 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. Hi Eike, thank you for the quick response. You are wright - I gave too less information. Here is a short description. Only the sheet Handel is important here to show the problem. Ignore the other sheets, they are not completely finished. Also the buttons ExportPDF, Sortieren and DruckenMonat on the symbol bar in Handel is still under construction and may not work, that is OK. Try the following: 1) On A3 and B3 I put some buttons to in-/de-crement the values for month and year above. I open the document, and they work. The macros assigned do their job when I press a button --> OK 2) On D3 you find a button calling a macro which set Q1 to 0. You can try that: Set Q1 manually to 5 and press the button on D3 and Q1 becomes 0 --> OK 3) The formula in R1 depends on Q1 and will be executed, when Q1 is updated, even with the same value as before. So pressing the button on D3 should execute the formula in R1 because of the update of Q1. Important is, that the macro "getrowofcursor" within the formula is not called! If I set the cursor in C7 and press the button on D3, it should write 7 into R1, but it doesn't. I see the names of the macro within the formula in R1 is written in lowercase letters. To correct that: When I now adapt one of the names within the formula in R1 to GETROWOFCURSOR and press enter, everything works. After that all names of that macro-call in that formula are written in capital letters and the button on D3 works as expected!? After saving, closing and opening the document again, the functionality of the formula in R1 has gone - WHY??? --> ERROR The point is, macros called by pressing a button work fine, but macros called from within formulas don't work! I wrote the formula "=GETROWOFCURSOR()+Q1-Q1" into R3 and press enter - it works. Pressing the button on D3 adapts R3 with the row of the current cursor position. After saving, closing and opening the document again, I see #NAME? in R3 and the button on D3 doesn't work anymore. That is the behaviour on my PC. -- 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
