https://bugs.freedesktop.org/show_bug.cgi?id=54854
--- Comment #13 from Forester <pbronline-freedesk...@yahoo.co.uk> --- Created attachment 79505 --> https://bugs.freedesktop.org/attachment.cgi?id=79505&action=edit Python macro illustrating the issue and several workarounds Salut Jacques, Attached is a Python macro that revisits this bug. With the PageName.oxt installed, open a new workbook. Create at least one sheet, select any sheet. It does not matter what the sheets are named. In cells E2 and E3 enter the formulae: =PAGENAME(A1) =PAGEINDEX(E2) It is easy to see the results are correct. Now run the attached macro. #NAME! will appear in cells E6 and E7. This is the bad behaviour A that the original bug report complained about. This uses the setFormula() method of .com.sun.star.table.XCell interface. I believe this the correct way to enter a formula using the UNO API. It seem work for built-in functions but not add-in functions. Correct results appear in cells E10 and E11. This works around the bug by using a replace descriptor to change '=' to '='. The formula are 're-entered' and interpreted correctly. Nice to see this workaround from the days before Windows™ still works. Correct results appear in cells E14 and E15. This time the 'dispatch' interface has been used to simulate user input. Clumsy. It is what you would get if you use 'macro record' and then translate the !LibreOffice Basic in Python. Yuk. Correct results appear in cells E18 and E19. This uses setFormula() but uses the PageName functions' full UNO Component IDs. I don't think this should be necessary. It does not work form the UI. Can you run this and confirm the bug ? Merci d'avance, Forester -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
